Loading from ODS to Cube in process chain

[Former Member]

Hi Experts,

How can I do a full load from ODS to cube when using further processing in process chain? Your help is much appreciated.

Thanks,

Bill

[former_member345199]

Hi,

You can use a DTP for this.

Create transformation between DSO and cube.

Create DTP and run it.

Hope this helps.

Thanks,

JituK

[Former Member]

Hi Friend,

You can either use the Process Type Update Data Store Object Data (Further Update) or simply Execute DTP and use the DTP that loads from ODS to Cube.

Hope it helps.

Regards

Hemant Khemani

[Former Member]

Hi Hemant,

I tried using further processing, but it automatically choosed delta load, which was not exactly what I wanted. Any input for this?

Thanks,

Bill

[Former Member]

Hi Friend,

First goto RSA1 -> Create transformations from DSO to Cube.

Then create a DTP to load from DSO to cube. There in the Extraction tab you can give the Extraction Mode as Full.

Save and Activate.

Then include this in your Process Chain.

Hope it helps.

Reward with Points if useful.

Regards

Hemant Khemani