Creating an InfoCube - SAP BW

The following steps demonstrate how to create an InfoCube,the fact table and associated dimension tables,for the sales data shown in Table

Work Instructions
Step 1. Select Data targets under Modelling in the left panel. In the right panel,right-click InfoArea–demo and then select Create InfoCube….
Work Instructions

Step 2. Enter a name and a description,select the option Basic Cube in block InfoCube type,and then click Work Instructionsto create the InfoCube.

Note:An InfoCube can be a basic cube,a multi-cube,an SAP remote cube,or a general remote cube.A basic cube has a fact table and associated dimension tables,and it contains data. We are building a basic cube.

A multi-cube is a union of multiple basic cubes and/or remote cubes to allow cross-subject analysis. It does not contain data. See,Aggregates and Multi-Cubes,for an example.
Edit Info Cube

A remote cube does not contain data;instead,the data reside in the source system. A remote cube is analogous to a channel,allowing users to access the data using BEx. As a consequence,querying the data leads to poor performance.

If the source system is an SAP system,we need to select the option SAP RemoteCube. Otherwise,we need to select the option Gen. Remote Cube. This book will not discuss remote cubes.

Step 3. Select IO_CUST,IO_MAT,and IO_SREP from the Template table,and move them to the Structure table by clickingWork Instructions

Next,click the Dimensions… button to create dimensions and assign these characteristics to the dimensions.
characteristics to the dimensions.

Step 4. Click,characteristics to the dimensions.and then enter a description for the dimension.

Note:BW automatically assigns technical names to each dimension with the format <InfoCube name><Number starting from 1>.

Fixed dimension <InfoCube name><P|T|U> is reserved for Data Packet,Time,and Unit. Section,"Data Load Requests," discusses the Data Packet dimension.

A dimension uses a key column in the fact table. In most databases,a table can have a maximum of 16 key columns. Therefore,BW mandates that an InfoCube can have a maximum of 16 dimensions: three are reserved for Data Packet,Time,and Unit; the remaining 13 are left for us to use.

Repeat the same procedure to create two other dimensions. Next,click the Assign tab to assign the characteristics to the dimensions.
characteristics to the dimensions.

Step 5. Select a characteristic in the Characteristics and assigned dimension block,select a dimension to which the characteristic will be assigned in the Dimensions block,and then click Asignto assign the characteristic to the dimension.
assign the characteristic to the dimension.

Step 6. After assigning all three characteristics to their dimensions,clickassign the characteristic to the dimension. to continue.
Assign dimensions

Step 7. Select the Time characteristics tab,select 0CALDAY from the Template table,and move it to the Structure table by clickingWork Instructions
Edit Info cube time characterstics

Step 8. Select the Key figures tab,select IO_PRC,IO_QUAN,and IO_REV from the Template table and move them to the Structure table by clicking.Work Instructions

Next,click Work Instructionsto check the InfoCube. If it is valid,clickWork Instructions to activate the InfoCube.
Edit Info cube key figures

Result:
You have created the InfoCube IC_DEMOBC. A status message InfoCube IC_DEMOBC activated will appear at the bottom of Screen.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BW Topics