ODS to infocube

[Former Member]

hi gurus

i have a scenario to handle. i have an ODS object say A which gets the data from 3 other ODS objects say B, C, D. now i need to export the data from A ODS object to a custom defined InfoCube.

Moreover, the 3 other ODS objects B, C, D are now providing data to a transactional ODS object. Now in this scenario when i need to export the data to the Infocube, what specific steps i need to take.

your help will be greatly appreciated.

thanks in advance.

regards

bwlearner

[Former Member · Accepted solution]

Hi,

you can create an export datasource on the ODS (right click...) and use that to load your data to your cube.

You can also create an update rule for your info cube that points to the ods.

Best regards,

Christian Frier

[former_member181964]

Hi,

If you want to tranfer data from ODS to Cube, follow the steps.

1.Genarate Export Data source, genarally for ODS it will creates automatically with the name 8<ODS name>.

2.Create updaterules for Cube,and there you can find 3 options' so select ODS and give 8<ODS name> and activate.

3. Create Infopackege and extract data.

Thanks

Reddy

[Former Member]

hi reddy

i have created the InfoCube and exported the data into the cube. When i try to copy the Queries of the ODS to the infocube using RSZC, it shows that 3 objects are not copied to the target infocube.

when i checked the infocube i can find that 3 objects were not selected in the infocube keyfigures area.

any idea what could be the reason, that only 3 key figure objects were not copied and remaining all objects were copied to the infocube.

your answers will be greatly appreciated

regards

bwlearner

[Former Member]

Hi learner,

how r u ?

Ur Data flow is this

ODS_B

ODS_C -

---

> ODS_A -

---

> IC_CD

ODS_D |--> ODS_T

now this is OK. Using the 3 ODS ie, B,C & D UPDATE ur Transactional ODS (ODS_T) in the way u do in SEM.

Then update the IC_CD from the ODS_A (whenever required).

Hope this will work....

Best Regards....

Sankar Kumar

[Former Member]

1) make sure you have all the objects in cube that you have in the ods

2) delete the data in the cube > add the missing keyfigures > activate > copy the queries now and let us the know the result.

Regards,

BWer

Assing points if helpful.

[Former Member]

hi

what you asked me to do is to add the missing the keyfigures. But to tell you the fact, i can see the 3 keyfigure, which are to be copied in blue color in the edit infocube screen. But i am not getting the option to select them to transfer to the structure from the template.

anyhelp.

[Former Member]

Hi,

If the data is avialable in ODS and the Info Cube is already build, then push the data from ODS to Cube.

Right click on ODs and selct Update ODS data in Data Target. First initialize the cube and then you can load the daily delta from ODS to CUBE