migrating data from transactional ODS to InfoCube

[Former Member]

hi gurus

what is the procedure to migrate the data from the transactional ODS to the InfoCube.

thanks in advance

regards

vijaykumar

[Former Member]

Hi,

either create an export-datasource and assign it to the desired cube as a datamart in the myself system.

hth

Cheers

Sven

[Former Member]

hi sven

but the export data source does not work with the transactional ods objects.

regards

vijaykumar

[former_member181964]

Hi,

http://help.sap.com/saphelp_nw04/helpdata/en/44/b21f98be886a45a4bb7e123e86e4c2/frameset.htm

Thanks

Reddy

[Former Member]

Hi,

I've created one in my system and used it ...

Anyway, you can also create a generic extractor onto the /BIC/A<ODS-Name>00 - Table within the BW via Transaction RSO2.

Hth

Cheers

Sven

[Former Member]

Hello,

You don't need to export Datasource, It's System Generated.

You can also try this.

In order to transfer data from a transactional ODS object into further data targets, first create update rules from ODS object to the datatarget you want to update. During the update rule creation, select the transactional ODS object as the infosource. For the transactional ODS objects "Update Data in Data Targets" option is not available in the context menu of the ODS object, so you have to manually create infopackage to transfer data.

Go to the infosources tab in the administrator workbench and create infopackage for the system generated export datasource (technical name is 8<technical name of the ODS>). Then you can just execute the infopackage to load data into subsequent data targets, but please keep in mind only full upload is possible (no delta upload) with transactional ODS objects.

Hope it helps.

San.