generate-cds-analytical-query
Installation
SKILL.md
Generate CDS Analytical Query
Generate an analytical CDS query — a transient projection view with provider contract analytical_query — on top of an existing analytical cube (@Analytics.dataCategory: #CUBE).
This skill replicates SAP Joule's "CDS Analytical Query Generation" capability by combining ARC-1 (SAP system access) with mcp-sap-docs (documentation & best practices). The query view is what end users consume in analytical clients (SAP Analytics Cloud, Analysis for Office, embedded analytics) — it selects measures and dimensions from a cube and arranges them on rows/columns/free axes.
Prerequisites — read this first
- Requires SAP_BASIS 7.57+ (S/4HANA 2022+). The
provider contract analytical_queryform is unavailable on 7.56 and earlier. Note thatSAPManage(action="probe")rap.availableis necessary but not sufficient — RAP shipped in 7.54, so atruedoes not confirm the 7.57 floor. To gate reliably, check the release directly, e.g.SAPQuery(sql="SELECT release FROM cvers WHERE component = 'SAP_BASIS'")and require>= 757; otherwise be ready for the provider-contract syntax error to surface at activation (Step 5) and stop there. - You need an existing cube. This skill projects ON a cube. If no cube exists yet, run the
generate-analytics-star-schemaskill first to build the cube + dimensions, then come back here.