1. Overview…………………………………………………………………………
2. Format……………………………………………………………………..
3. Examples (with code)
4. Cube Create……………………………………………………………..
5. Cube Change…………………………………………………………….
6. Cube Activate……………………………………………………………        
   

1 Overview:

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

1^st Column :  Infocube name.

         2^nd Column:  Cube Description (long text).

         3^rd Column:   InfoArea name.

         4^th Column:   Dimension name (Start with Cube name follow with 1-9

                             and A-D).

         5^th Column:   Dimension Description (long text).

         6^th Column:   Infoobjects name.

         7^th Column:   Infoobjects type.

         8^th Column:   Navigation Attribute (Put ‘X’ in this column, if any

                             infoobjects contains any attribute ).

         9^th 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:

1 Cube Create:

              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):

1    Cube Change:

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):