generate-analytics-star-schema

To generate a CDS analytical model from a RAP business object, you use an automated tool that creates a star schema. This process automatically builds the necessary cube view, dimension views, and text views without manual coding.

A star schema in SAP CDS is an analytical data structure consisting of a central cube view surrounded by dimension and text views. It simplifies complex reporting and analysis by organizing data into this efficient relational model.

Generating analytical models for SAP requires SAP_BASIS 7.5x or higher. This version is necessary because it provides the underlying analytics annotations needed to properly define and activate the CDS views.

Yes, you can create analytical star schemas from plain DDIC tables. The generation process supports both standard DDIC tables and RAP business objects as source data to build the cube and dimension views.

Manually building CDS analytical models is difficult because it requires coding multiple interconnected cube, dimension, and text views. Automating this generation saves time and reduces errors when creating complex analytical data structures.