generate-analytics-star-schema
Installation
SKILL.md
Generate CDS Analytics Star Schema
Generate a CDS analytical model — a star schema consisting of a cube view (@Analytics.dataCategory: #CUBE), one or more dimension views (#DIMENSION), and text views (#TEXT) — on top of a RAP business object or a plain DDIC table.
This skill replicates SAP Joule's "CDS Analytical Model Generation" capability (basic + extended scope) by combining ARC-1 (SAP system access) with mcp-sap-docs (documentation & best practices). Basic scope = cube + reuse existing dimensions. Extended scope = also generate new dimensions, and start from a DDIC table (not just a RAP BO).
Prerequisites — read this first
- Requires SAP_BASIS 7.5x with the analytics annotations. Verify with
SAPManage(action="probe")(rap.available). If RAP/CDS isn't available, stop. - The output is a set of interdependent CDS views (cube → dimensions → texts). They must be created as inactive drafts and activated together so SAP's activator resolves the cross-references in one pass. This skill uses
SAPWrite(action="batch_create", activateAtEnd: true)for exactly that.