loading data from flat file to Info Cube .Briefing of Process chain and Transport Requests.

[Former Member]

How to load data in info cube.

We will load the data from flat file. Transaction code RSA1

1)create an info area ->create two info object catalogue one for characteristics and other for key fig.->within the catalogue create respective characteristic and key fig info objects

2) Now as we need to load data from flat file we need to create a data source->create application comp->Right click ->create data source->fill details.

3) Create Info package over that data source which will load data to PSA. Click on schedule for loading.

4) Create DSO ->insert Key field (primary Column) -> rest insert in data field.

5) Create Transformation->Mapping->activate it->create DTP from Info package to DSO->Execute.

6) Go to manage ->activate-> start->go to job->refresh till finished.

7) Right click and display data->select all or highlight key fig and characteristics.

😎 Create Info cube ->Add dimensions and key figures.

9) Create Transformation->Map->activate->create DTP from DSO to Info cube.

10)Create Multiprovider->select info cube , DSO, Info providers(as source)->choose dimensions and key figures from whatever DSO or Cube-.but don’t forget to provide assignment that this particular field is from cube or DSO via Identify Char or Key Fig ,as shown in Example-

If in a file we want that it should include special characters as well , then go to TCODE rskc there we put that special character for e.g. put & for J&k and if we want that it should make all the characters in file as capital then add ALL_CAPITALS as command there.

Briefing of Process Chain and Transport Request

Process Chains

TCODE- RSPC, RSPCM (Monitoring)

1) Click on New->Create variant-> select Info Package ->Automatically Change attribute will appear.

It will bring whole chain automatically but it will ask whether you want that chain , if somewhere else also its used. Click on NO.

2) Refresh it and execute.

Transport Request.

1) Actually what happen that after every few weeks the BW system is cleaned where unwanted things are removed, so it’s better to move your data to some package or system.

Mostly in real time projects transport request is used to transport from development system to quality and from quality to Production.

Easy Way :- Expand the tree as follow-

Click on Change icon or Right click and change.

Select from the lowest that is info package go to Extras->Object Catalogue entry

Below screen will appear, you can see right now its temp package .You can choose a package and  change owner name if required then click ok.

Do same with all in tree.

Other way-

TCODE se09 or Transport tab in front page-

Select your Info area->drag to the right side ->check the required one->rest uncheck->choose info package->Transport via truck icon.

..............................................................................................................................................................................................................................................

...............................................................................................................................................................................................................................................