Creation of INFOCUBE

An INFOCUBE in SAP BI suite is known as a revolutionary multidimensional dataset which is used for analysis in a BEx query. An INFOCUBE consists of a set of relational tables which are logically joined to implement the star schema. A fact table in the star schema is joined with multiple dimension tables.

You can add data from one or more INFOSOURCE or INFOPROVIDERs to an INFOCUBE. They are available as INFOPROVIDERs for analysis and reporting purposes.

INFOCUBE Structure

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.

The real-time characteristic can be assigned to an INFOCUBE. These Real-time INFOCUBEs are used differently to standard INFOCUBEs.

How to Create an INFOCUBE?

All INFOOBJECTs to be used in an INFOCUBE should be available in an active version. In case there is an INFOOBJECT that doesn’t exist, you can create and activate them.

·         Go to Modeling tab → INFOPROVIDER → Create INFOCUBE

·         Once all this is done, you can click on Create.

·         Right click on Dimension 1 → Properties. Rename the dimension as per the INFOOBJECT.

·         Add INFOOBJECT to dimension. In a similar way, you can also create new dimensions and add INFOOBJECTs.

·         Once you add all the dimensions and key figures, you can activate the cube.

Real Time INFOCUBEs

Real-time INFOCUBEs are used to support parallel write access. Real-time INFOCUBEs are used in connection with the entry of planning data.

You can enter the data in Real-time INFOCUBEs in two different ways −

• Transaction for entering planning data or by
• BI Staging

You can also convert a real-time INFOCUBE. To do this, in the context menu of real-time INFOCUBE → select Convert Real Time INFOCUBE.

By default, you can see that a Real Time INFOCUBE can be planned – Data Loading Not Permitted is selected. To fill this INFOCUBE using BI staging → Switch this setting to Real Time Cube Can Be Loaded with Data, Planning Not Permitted.

Creating a Real-Time INFOCUBE

A real time INFOCUBE can be created using a Real Time Indicator check box.