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 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.
