Data Loading into Infocube from ECC.

[Former Member]

Hi,

Can someone help me with the list of steps to be followed for loading data into infocube using Data trasnformation process. Steps to be perfomed in the system.

Also please share any links on various methods of loading data into infocube from ECC.

Thanks!

[Former Member]

Hi Aswath,

http://help.sap.com/bp_scmv250/index.htm

Go to technical information on the left pane, check for DPL-demand planning in Building Block Library

If you want data to be loaded from ECC

check for data extractors in tcode LBWE

Activate data sources

Replicate data sources in BW system

create InfoPackage to load data into PSA

create DTP to load data from PSA to infocube

Check with BW contact for more details

Hope this helps.

[Former Member]

The steps would be ass foloows:-

1) Create the info-objects.

2) Create the infocube. If you a Planning area and the cube is a replica of the PA you can use /SAPAPO/TS_PAREA_TO_ICUBE to create the infocube.

3) You create a source system as a file system.

4) You create the datasource with the relevant fields.

5) You create a transformation for the cube using the datasource you created in step 4.

6) Last step would be to create DTP. When you create the DTP, on the first screen, check the checkbox for "Do not load data from PSA". This will give you additional fields to enter the file path. When this DTP is created and generated, goto the last tab of the DTP to execute.

This will help you to directly pull the data from the file and load it into the cube.

You can also create a Process chain to automate this process.

Hope this helps.

Let me know in case of any more information.

[Former Member]

Hi Aswath Ram,

Please follow the below link to get the documentation on Data transfer process.

http://help.sap.com/saphelp_scm70/helpdata/EN/f8/7913426e48db2ce10000000a1550b0/frameset.htm

Regards

R. Senthil Mareeswaran.