⟩ WHERE DO YOU STORE THE MASTER DATA IN BI 7.0?
Unlike the older version of BW which uses star schema, BI
7.0 uses the extended star schema. In this, master data is
stored outside the cube.
In the star schema, both master data and transaction data
resides inside the cube bringing many problems: master data
not reusable, computing of alphanumeric values and analysis
being limited.
In BI 7.0 Master data is stored outside the cube which
makes it reusable, and alphanumeric values can be computed
and many more analysis are possible.