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!!!
If you use MP, it would be easier to implement since you need only one char from each of the other cube. The design you are trying to implement won't work because you need to load KF and the KF will be attached to that particular line and you wouldn't get Condition type and Executing Service Employee for the main ODS.
What I would recommend it as long as you know the relationship between Billing Item to the other ods and cube. Create another ods which will be getting data from all the three providers and map properly, that way, you will have a single record.
Hope you understand.