Skip to Content
Former Member
Jul 27, 2007 at 02:29 PM

Creating cube from three ODS!


Hi Experts -

I have the following:

1. Billing item ODS

2. Billing condition ODS

3. CRM_CODT cube

I have created a cube from the Billing Item ODS. I basically need Condition Type char from Billing condition and Executing Service Employee char from CRM_CODT cube.

My first attempt is to add the Condition Type field in my Cube. I have added that. And in my update rules I have it mapped to the source ODS.

I'm a little confused with the mapping though. I need to have the keys mapped to each other, right? If so, I need to bring in the keys from ODS to the cube, right? Can I do that?

After that, how do I load the right data?

And after that I have to account for the Executing Service Employee from the CRM_CODT cube.

I need help with that mapping and also how to load the data? Do I need to write a update or a start routine?

I know I'm asking for a lot but thanks a lot in advance 😊

Helpful answers will definitely get point!!!