SAP B1 Question:
Download Job Interview Questions and Answers PDF
WHERE DO YOU STORE THE MASTER DATA IN BI 7.0?
Answer:
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.
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.
Download SAP B1 Interview Questions And Answers
PDF
Previous Question | Next Question |
Why we are going for customization? Give me a scenario? | What are the common Transport errors in SAP BW? |