Skip to Content

Author

Neetha Jayakrishnan is currently working with L&T InfoTech as SAP BI Consultant.

She have experience of over  2 years on SAP Business Intelligence (BW 3.5 & BI 7.0) in Production support as well as in BW Implementation Project. She has also worked on SAP technologies like Xcelsius,  ABAP, and various versions of BI.

Introduction

This document explains the step by step procedure to Load data into an Infocube using an ABAP Program.

This can be useful in scenarios where we dont have a data model for the Infocube and we want to show the business model to the customers in a short Span.

Overview

Program to be used : CUBE_SAMPLE_CREATE

1. Goto Transaction SE38 and execute the Program CUBE_SAMPLE_CREATE

/wp-content/uploads/2012/05/pic3_104360.jpg

Now you will get the below screen in which you have to enter the InfoCube name and the number of records which needs to be inserted into the InfoCube.

/wp-content/uploads/2012/05/pic3_104360.jpg

There are 3 modes by which we can update data to this Infocube.

  • Generated Values

For all the characterestics and Keyfigures system will generate random values and update this to the Infocube.

  • Values from Master data Table

Values from Master data tables will be updated to the characterstics and system generates random values for Keyfigures and Updates  the  Infocube.

  • Ready-For-input ALV

With this Option we can enter data manually into the Infocube. This works like simulation and we can see the data before it gets updated into the Infocube.

Select the Mode from the 3 available options(as per your requirement) and click on “Execute Directly”.

The Program updates the Infocube fields with the values from Master data tables, with random generated values or with manually entered data.

/wp-content/uploads/2012/05/pic3_104360.jpg

By using “Ready – for Input ALV” option also we can randomly generate data for inputing into Infocube. The advantage of this over the other two option is that, we can see the data before it gets updated to the infocube. So if any modifications are required we can make at this level and then save the data to the Infocube.

For example :

Select the Mode as “Ready – for Input ALV” and number of records as “3”.

/wp-content/uploads/2012/05/pic3_104360.jpg

This will randomly generate 3 records for the cube and we can see the data in simulation before updating it into the cube.

/wp-content/uploads/2012/05/pic3_104360.jpg

If you want to write this data to Infocube just click on “Save Data records to Infocube” and the data will be updated to the Cube.

To manually enter data into Infocube put 0 for number of records to be generated and select ” Ready-for Input ALV” Option and Execute.

/wp-content/uploads/2012/05/pic3_104360.jpg

Now click on “Insert Row ” and enter the data into the InfoCube directly.

/wp-content/uploads/2012/05/pic3_104360.jpg

Once you complete all the data entries click on “Save data records in Infocube” , the entries will be updated to the Cube.

/wp-content/uploads/2012/05/pic3_104360.jpg

Note :

While manually entering data ensure that the entries matches the length of characters for that Infoobject.

To report this post you need to login first.

6 Comments

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

      1. Neetha Jayakrishnan Post author

        Hi Sunny,

        Yes, it is full load only.

        You can use this methos, in scenarios were there are no data models (transformations/ datasources)  and it is required to create business model to client or in scenarios were we have to make sample dashboards on cubes in a short time span. In these situations this program can be used to load data quickly without creating the whole data flow.

        (0) 
        1. sunny sharma

          thanks neetha

          the document is really a knowlegable piece i will surely try to implement one such scenario in my development system and will surely try to load data via abap programme

          thanks again for such informative article

          please keep sharing such articles

          regards

          Sunny

          (0) 
  1. leno lotus

    thx neetha

    the doc is very usefully i generator the test scenario in dev system,pls keep sharing such article.

    regards

    leno

    (0) 
  2. Babu Kilari

    Very informative document.. However, there are certain fields that are not allowed to edit. For example Calendar Year..How to edit them ?? Please help.

    Babu Kilari

    (0) 

Leave a Reply