|Home • Trainings • 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 Technologies1 Description:
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.
3.1 Initial Object Creation
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
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