Skip to Content
  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

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

/wp-content/uploads/2012/05/1_105552.jpg

                         (Above snap shot show the default view of the program)

Examples:

1 Cube Create:

              Create a .CSV file ( e.x. Create_cube_example.csv   )

/wp-content/uploads/2012/05/2_105553.jpg

            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.

/wp-content/uploads/2012/05/3_105584.jpg

Output:

/wp-content/uploads/2012/05/4_105585.jpg

Output in T-code – RSA1:

/wp-content/uploads/2012/05/5_105586.jpg

  Output in T-code – RSA1 (Display infocube):

    Cube: ZSALE10

/wp-content/uploads/2012/05/6_105587.jpg

Cube: ZSALE11

          Output in T-code – RSA1 (Display infocube): 

/wp-content/uploads/2012/05/7_105588.jpg

Pseudo Code (Create Cube):

/wp-content/uploads/2012/05/8_105589.jpg/wp-content/uploads/2012/05/9_105590.jpg

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

/wp-content/uploads/2012/05/10_105591.jpg

Cube: ZSALE11

             Dimensions:

                      ZSALE111 – Client       

             Characteristics:     

                       Dimension                      Characteristics         

                       ZSALE111                      ZQFMANDT    

                       ZSALE111                      ZQFBUKRS

                       ZSALE111                      ZQFWWCLS

              Keyfigures:                    

                      

                       ZQFVVA600

                       ZQFVVD03          

Output in T-code – RSA1 (Display infocube):       

/wp-content/uploads/2012/05/11_105592.jpg

     Placed the modified structures of cube/ cubes into .csv file.

/wp-content/uploads/2012/05/12_105593.jpg

     Select the radio button for modifying cube/cubes and pass the file path in  

     below screen in .CSV file format.

/wp-content/uploads/2012/05/13_105594.jpg

Output:

/wp-content/uploads/2012/05/14_105595.jpg

Output in T-code – RSA1:

/wp-content/uploads/2012/05/15_105596.jpg

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

/wp-content/uploads/2012/05/16_105597.jpg

Cube : ZSALE11

/wp-content/uploads/2012/05/17_105598.jpg

Dimensions:

                      ZSALE111 – Customer      

                      ZSALE112 – Customer  

             Characteristics:     

                       Dimension                      Characteristics         

                       ZSALE111                      ZQFMANDT    

                       ZSALE112                      ZQFBUKRS

              Keyfigures:                    

                    

                       ZQFVVD03                               

       

 
Output in T-code – RSA1 (Display infocube):

/wp-content/uploads/2012/05/18_105599.jpg

Code (Cube Chage/ modify):

/wp-content/uploads/2012/05/19_105600.jpg



To report this post you need to login first.

16 Comments

You must be Logged on to comment or reply to a post.

    1. Om Ambulker Post author

      Hi Sanyukta,

      it depends on you what t-code you want, i created custom t-code ZUTIL to access my program.

      This program may need some updation for functioning well. hope you will put your efforts to make this program better.

      All the best 🙂

      Regards,

      Om Ambulker

      (0) 

Leave a Reply