|Home • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
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
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
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.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards