INFOCUBES in SAP BW
Infocube is data storage area in which we maintain data which we are extracting from source system physically. An Info cube can function as both a data target and an Info provider. From a reporting point of view, an Info cube can be described as a self-contained data set.
For example, a Sales Amount Info cube which has dimensions like MONTH – PRODUCT-CUSTOMER-REGION can be viewed by any of the axes, for example total sales by region or by customer. The dimensions of an Info-Cube are entities or hierarchies.
How to create an Infocube:
Step 1)
– Go to transaction code RSA1.– Click the OK button.
Step 2)
– Navigate to Modeling tab -> Info provider. – Right click on Info area. – Click on “create info cube” from the context menu.
Step 3)
– Enter the Technical Name. – Enter the Description. – Choose the option button “Standard Info cube”. – Click on the create button.
Step 4)
– Right click on Dimension 1 -> Properties.
Step 5)
– Rename the Dimension as per Info object information.
Step 6)
– Right click on the Dimension -> Info object Direct Input to Insert Info objects into the dimension.
Step 7)
– Select Characteristics.
Step 8)
– Select Airline ID in characteristics.
Drag and drop it into Dimension.
Step 9)
– Similarly create new dimensions and follow the steps 4-8 to add the Info objects.
Step 10)
– Adding Key figure Info objects in the Info cube.
Step 11)
– Follow the processes above to add more Key Figures.
Step 12)
– Activate the Info cube.
Important Notice for college students
If you’re a college student and have skills in programming languages, Want to earn through blogging? Mail us at geekycomail@gmail.com
For more Programming related blogs Visit Us Geekycodes . Follow us on Instagram.