3.X Hierarchy Loading for Purchase Cube in SAP BI

By Arun Bala Ganesan, Wipro Technologies

Introduction

In SAP BI 7.0, we’ll study how to implement a 3.X Hierarchy Loading for a Purchase Cube (0D_PU_C01)

The steps we do in this are the following:-

1.                Creation of Info objects

2.                Creation of Primary Key Info object (MATID)

3.                Hierarchy Description – Assignment of Nodes to IOs

4.                Export of Hierarchy

5.                3.X Loading of Master data – Creation of Info source    

Process Description

Firstly, In RSA1 à Info Objects, we create a new Info Area (say info_area_134)

Now, we need to create characteristic & key figure info object catalog

We name it info_c & give the name of the info area as info_area_134 (default assigned), further we check the "Char" radio button afterwards

Now, we need to create Info objects inside this Char. catalog.

Name: Material ID (mat_id86) - CHAR (10)

Now Save & Activate the Info object.

The info object Material ID (mat_id86) is now active

Further we'll start maintaining Master Data for this Info object. So click the button "Maintain" or use Keyboard controls (F6)

This displays the output screen

The same way we need to create 2 more Info objects, for Material Group & Material Type.

Now, that we have created, it’s the right time for us to maintain the Master data for these info objects. So, we need to first make use of an Info object as its Primary Key (PK). This can be done using the "Attributes" tab.

Further we start maintaining the master data for the Info object catalog.

Go to, create & start creating records for the Master Data.

Now, that the key value objects is Material ID (mat_id86). So, go to Hierarchy tab. Now click on the "Maintain Hierarchy" button

This leads to a new screen à Initial Screen Hierarchy Maintenance. Here we can create a new hierarchy characteristic for the Info object. Now click on new button in the last of the row.

Enter the details, such as Hierarchy Info object name "mat_id86"

Hierarchy Name: z08_test_hier_name, and also give in the hierarchy description in short/medium/long text. Press Continue to proceed.

Inside this we now create Text Nodes using the standard buttons.

  

Use these standard procedures to create Text Nodes & assign it to nodes test_level1 & test_level2. 

Now, in RSA WB go to the info catalog, wherein in the hierarchy tab, you can find a Hierarchy Table: /BIC/HMAT_ID86. Double click this Hierarchy table and proceed to view in SE11.

Now execute to view the data. Press F8

We can now view the IOBJNM (Info Object Name) & Node names as,

1.                   ROOT

2.                   TEST_LEVEL1

3.                   TEST_LEVEL2

4.                   M200

5.                   M100

6.                   M400

7.                   M300

Now, go to System à List à Save à Local File

You can export this to a local file as Spreadsheet, Rich Text Format, and HTML Format etc.

We now save it with the extension XLS

Further we can perform loading using 3.X Info source.

We now create an Info source as in the following screen shot.  

Go to RSA1 à Info sources à Additional Functions à Create Info source 3.X, and assign this info source to MAT_ID86. Thus, we have created an Info provider.

  

The rest of the loading is same as the cube level loading as in 3.X.

Results  

Thus, the 3.X Hierarchy Loading for Purchase Cube SAP in BI has been demonstrated.