Skip to Content
Author's profile photo Former Member

SAP BI Cube Creation Using a function Module

  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



Assigned Tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very helpful program to save a lot of manual work in creation of customized cubes in BW

      Thanks for sharing.

      Keep it up.

      Author's profile photo Former Member
      Former Member

      good one

      Author's profile photo Former Member
      Former Member

      Brilliant idea at the first place and much needed Time saver!!

      Author's profile photo Former Member
      Former Member

      helpful program!!

      Author's profile photo Former Member
      Former Member

      will save lots of manual efforts.

      Thanks for sharing

      Author's profile photo vaibhaw kumar ritolia
      vaibhaw kumar ritolia

      Thanks Om for such a helpful post...

      Author's profile photo Former Member
      Former Member

      Great Document 🙂

      Thanks for sharing

      Kind Regards

      Manna Das

      Author's profile photo Prashanth konduru
      Prashanth konduru

      Gr8 effort... Good document n thanks for sharing ...

      KP

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks prashanth.

      Author's profile photo Former Member
      Former Member

      Good document ..Just a quick ques whats the T-code for accessing the program for creating cube ??

      Author's profile photo Former Member
      Former Member
      Blog 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

      Author's profile photo abilash n
      abilash n

      Nice one......

      Author's profile photo Former Member
      Former Member

      Really helpful stuff for Major developments.. Thanks Om

      Author's profile photo Former Member
      Former Member

      Thanks Om, very helpful. But where can I find the code? Thanks.

      Author's profile photo jennegolla nagaraju
      jennegolla nagaraju

      Hi  Former Member

      good one.

      i am looking for your wrapper tool for creating multiple infoobjects, can you please provide me the same. i am not even finding it in archieve path as well.

      thanks
      Raj

      Author's profile photo Shai Greenberg
      Shai Greenberg

      Dear Om,

      Would you mind sharing a full code example and csv examples for this?

      Thanks,

      Shai

       

      Author's profile photo Suraj Singh
      Suraj Singh

      Hi Shai ,

       

      have you created the cube changes program which is given above . I have created same code but dimensions is being not updated . Please let me know if you have any idea ?