Data Loading

[Former Member]

Hi Guys,

Can any one tell me ,how to load data from ODS to cube in BI7.0 manually.plese tell me the steps.urgent.

Thankyoou

[Former Member]

Hi

Right click on your cube and say create Transformation. It asks for a source object and target object. Give source object as ur DSO and target Object as yout Cube. The transformation gets created. Once the transformation is activated. Right click on the cube say create Data Transfer process. It will create a DTP. Now activate this DTP and run it the data gets updated

Hope this helps

Regards

Shilpa

[Former Member]

If the transformations already exist between the two, right click on the cube and say create Data Transfer process.

Create the DTP by giving the source as the DSO you want.

Then choose if you want to do a delta or full load.

then execute it manually to load.