Process Review on 3.X Loading for Purchase Cube in SAP BI

By Arun Bala Ganesan, Wipro Technologies

The Purchase Cube (PU_C01) is a standard cube in SAP BI. Its main use in Business Intelligence is to aggregate master data variables (Viz. Material Type, Material ID, and Material Groups) and compute summation on total of these variables.  

Some major enhancement to the Cube are made in the BI content by the project team so as to utilize and manage different types of materials, and the implications effectively. It will provide the tracking of the effects of different groups, types of materials based on categories and attributes, leading to changes in processes and levels to expedite aggregations.  

This information will help organization in understanding movement frequency by tracking materials & goods time-to-time and will enable segmentation of the Master database, and associated level of movement frequency provided, in order to avoid extra cost associated with handling goods from a management point of view.  

This document describes the loading of 3.X Purchase Cube. The master data when loaded into the cube will be used in several reporting levels in end user levels using reports/workbooks using general queries & constructs.  

A key challenge during this change was to ensure that any change would not disturb the existing business content of the Purchase Cube and also that there would be a tangible and quantitative improvement in the completion of the reports. From technical perspective the challenge was to ensure that the legacy 3.X loading of master data would not defoliate the BI performance.  

Initially in the Info Provider level we create a Info Area. The Info Areas are just similar to folders in normal context of files. Here we create an Info Area with the Technical Name – INFOE_M1 and Description as – INFOAREA_M1.  

Here we are actually copying the cube from OD_PU_01 which is nothing but the purchase cube. We are replicating / duplicating the BI content of the Purchase cube.  

After this process, we save & activate the whole Cube

Note: It’s better to refresh the Sub tree & perform Activation of the Info Provider objects.

Now, Go to Info Sources and right click the top to “Create application component”  

This Application Component Area is similar to Info Area, in concepts of folders, but its main difference is its totally unlinked with Info Areas level.  

The technical name of the application component is AC_45 & the technical name remains the same.  

After creating the Application Component AC_45, we right click the Application Component area  

Additional Functions à Create Info Source 3.X  

Click here to continue...