Skip to Content
Author's profile photo Tomer Steinberg

Filling an Infocube with sample data without loading it!

I was recently taking part in a Business objects training and we have had there a situation in which one of the BW infocubes we were working on was empty. Not only was it empty it also didn’t have any transformations and loading processes.  I then remembered using program CUBE_SAMPLE_CREATE in the past to demo the data model for users quickly without having the efforts of dataflow  development. I have used the program to fill the Infocube in no longer than a minute.

This program allows you to fill a premade infocube with data, based either on master data, data entry or randomly generated data.

First use SE38 with the program.  

 

Execute it…

 

The infocube will have a new request with the generated data.

It’s very useful for quick demonstration of a data model for a business user.

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Viren Pravinchandra Devi
      Viren Pravinchandra Devi
      Now we know fastest way to enter data in basic cubes as well..

      Thanks for sharing.

      Author's profile photo Former Member
      Former Member
      thaks for the tip
      Author's profile photo Former Member
      Former Member
      Really Useful
      Author's profile photo HADAR MAORHI
      HADAR MAORHI
      Great stuff,
      10x dude:-)
      Author's profile photo Nilesh Vakil
      Nilesh Vakil
      Cool Stuff
      Author's profile photo Former Member
      Former Member
      thanks for the tip, it sounds great! Unfortunately, there's a short dump, when I start the report:
      Include                                 LRSSAMPLEF01
      Row                                     564
      Module type                             (FORM)
      Module Name                             GET_TABLE_ENTRIES

      Neven

      Author's profile photo Former Member
      Former Member
      It seems, that the report has problems with cubes containing date characteristics.

      In my first test a short dump was the result of a wrong data type used in the report for the SID of the characteristic. In the special case of date characteristics this is of type DATS.

      This problem will probably occur on every cube we have. 🙁

      Author's profile photo Former Member
      Former Member
      Thanks for shareing
      Author's profile photo vinod bokade
      vinod bokade

      Thanks for the useful info 🙂

      Author's profile photo Frank Rühle
      Frank Rühle

      Good hint. 🙂