What is the structure of InfoCube?

1.	What is the structure of InfoCube?
Answer» An InfoCube is used to store the data physically. It consists of a number of InfoObjects that are filled with data from staging. It has the structure of a star schema. In SAP BI, an Infocube contains Extended Star Schema as shown above. An InfoCube consists of a fact table which is surrounded by 16 dimension tables and master data that is lying outside the cube.

Answer»

An InfoCube is used to store the data physically. It consists of a number of InfoObjects that are filled with data from staging. It has the structure of a star schema.

In SAP BI, an Infocube contains Extended Star Schema as shown above.

An InfoCube consists of a fact table which is surrounded by 16 dimension tables and master data that is lying outside the cube.

Discussion

No Comment Found

Related InterviewSolutions

What is UD connect in SAP BW system? How does it allow reporting in BI system?
What is the use of DB connection in SAP BW data acquisition?
How data is stored in PSA?
In SAP BW, is it possible to have multiple data sources have one InfoSource?
To load the data from a file source system, what is requirement in BI system?
While loading data from flat files, when separators are used inconstantly. How this will read in BI load?
What is the use of Navigational attributes?
Explain the difference between InfoCube and ODS?
What is Partition of an InfoCube?
How can you achieve performance optimization in SAP Data Warehouse?

What is the structure of InfoCube?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment