Types of infocubes in BI
This document is clearly for the beginners, not for experts…
Types of Infocubes
In BI 7.0 we are having 3 types Infocubes which are mainly used.
The Infocube which is used for Summarized data. The Infocube which is a Physical Storage Device which is used to store the data.
The Infocube is used for Transactional data only. The Infocubes are used to create Summarized reports
The 3 types of Infocubes are:
- Standard Infocube.
- Virtual Infoproivder (or) Virtual Infocube.
- Real-Time Infocube.
- Standard Infocube Stores The Physical Data, Data is Stored in the Standard Infocube.
- The Structure of the Standard Infocube is One Fact Table surrounded by the Dimension Tables.
Customer Dimension Material Dimension
Time Dimension Unit Dimension Data Packet Dimension
Virtual Infoprovider doesn’t store any physical data at the time of the query execution it receives data directly from the source system.
These are mainly used for data reconciliation during integration testing.
Reconciliation means validating the source system data with BI data.
In you don’t have the Sufficient Transaction codes (or) source system reports to perform the data reconciliation during
during integration testing we create virtual infoprovider.
Types of Virtual Infoproviders:
The types of virtual infoproviders are defines based on the data loading mechanisms
- Virtual Infoproviders with Direct Access DTP.
- Virtual Infoproviders with Function Module.
- Virtual Infoproviders with BAPI’s(business app programing interface)–which is used for Non-SAP.
→ In real-time infocube, we can write the data into the cube, Real-time infocubes are used for planning purposes.
→ For Standard cubes, we can load the data into the cube where as in real-time infocube we can load the data into the cube and we can write the data into the cube, That means while loading the data into the real-time infocube Planning is not possible. Similarly while writing that data (Planning the data) into the real-time infocube loading is not possible.
How to make the real-time infocube as Load behavior?
→ Select InfoArea → Right Click → Create Infocube → Select Real-time
Select Infocube → Right Click → Change Real-time load runner