During development of sap BI system, we might have a requirement of creating customized cube in SAP BI, to create lots of cubes manually. This program takes the input from .CSV file and passed this file to program which fetch the parameters from the .CSV file and provide input to program, which will create cube/cubes.
Format:
Create cube (include line item dimension and navigation attribute):
Create a .CSV excel file which contains the details of cube in following
order.
Infocube | Textlong | Infoarea | Dimension | Dimension_text | Infoobjects | Infoobject-type | Navigation_attr | Line_item_dimension |
1st Column : Infocube name.
2nd Column: Cube Description (long text).
3rd Column: InfoArea name.
4th Column: Dimension name (Start with Cube name follow with 1-9
and A-D).
5th Column: Dimension Description (long text).
6th Column: Infoobjects name.
7th Column: Infoobjects type.
8th Column: Navigation Attribute (Put ‘X’ in this column, if any
infoobjects contains any attribute ).
9th Column: Line item dimension (To create any line item dimension
put ‘X’ in this column with corresponding dimension).
(Above snap shot show the default view of the program)
Examples:
Create a .CSV file ( e.x. Create_cube_example.csv )
Cube Name:
ZSALE10 – Billing
ZSALE11 – Client
Dimensions of Cube ZSALE10:
ZSALE101 - Bill_details
ZSALE102 - Billing doc
ZSALE103 - Country
ZSALE10U - UNIT
ZSALE10T - TIME
Characteristics in cube ZSALE10
Dimension Characteristics
ZSALE101 ZQFGJHAR
ZSALE102 ZDEMO6
ZSALE102 ZDEMO7
ZSALE103 ZQFWWCSO
ZSALE10U 0UNIT
ZSALE10T 0CALMONTH
Keyfigures in cube ZSALE10
Keyfigures
0QUANTITY
Dimensions of cube ZSALE11
ZSALE111 - Client
Characteristics in cube ZSALE11
Dimension Characteristics
ZSALE111 ZQFMANDT
ZSALE111 ZQFBUKRS
ZSALE111 ZQFWWCLS
Keyfigures in cube ZSALE10
Keyfigures
ZQFVVA600
ZQFVVD03
Select the radio button for creating cube/cubes and pass the file path in below screen in .CSV file format.
Output:
Output in T-code - RSA1:
Output in T-code - RSA1 (Display infocube):
Cube: ZSALE10
Cube: ZSALE11
Output in T-code - RSA1 (Display infocube):
Pseudo Code (Create Cube):
If cubes are already created in sap BI system. And you wants to change/ modify the dimensions and infoobjects (i.e. structure of cube) then select the cube change radio button and pass the .csv file of changed cube.
Example:
In below example we are going to changes the dimension and infoobjects of cubes ZSALE10 and ZSALE11.
Before modify:
Cube: ZSALE10
Dimensions:
ZSALE101 - Bill_details
ZSALE102 - Billing doc
ZSALE103 - Country
ZSALE10U - UNIT
ZSALE10T - TIME
Characteristics:
Dimension Characteristics
ZSALE101 ZQFGJHAR
ZSALE102 ZDEMO6
ZSALE102 ZDEMO7
ZSALE103 ZQFWWCSO
ZSALE10U 0UNIT
ZSALE10T 0CALMONTH
Keyfigures:
0QUANTITY
Output in T-code - RSA1 (Display infocube):
Cube: ZSALE11
Dimensions:
ZSALE111 - Client
Characteristics:
Dimension Characteristics
ZSALE111 ZQFMANDT
ZSALE111 ZQFBUKRS
ZSALE111 ZQFWWCLS
Keyfigures:
ZQFVVA600
ZQFVVD03
Output in T-code - RSA1 (Display infocube):
Placed the modified structures of cube/ cubes into .csv file.
Select the radio button for modifying cube/cubes and pass the file path in
below screen in .CSV file format.
Output:
Output in T-code - RSA1:
After Modify:
Output in T-code - RSA1 (Display infocube):
Cube : ZSALE10
Dimensions:
ZSALE101 - Bill_details
ZSALE103 - Country
ZSALE10U - UNIT
ZSALE10T - TIME
Characteristics:
Dimension Characteristics
ZSALE101 ZQFGJHAR
ZSALE103 ZQFWWCSO
ZSALE10U 0UNIT
ZSALE10T 0CALMONTH
Keyfigures:
0QUANTITY
Output in T-code - RSA1 (Display infocube):
Cube : ZSALE11
Dimensions:
ZSALE111 - Customer
ZSALE112 - Customer
Characteristics:
Dimension Characteristics
ZSALE111 ZQFMANDT
ZSALE112 ZQFBUKRS
Keyfigures:
ZQFVVD03
Output in T-code - RSA1 (Display infocube):
Code (Cube Chage/ modify):
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |