Question:
Dear All
I have the scenario where an ODS contains data for several plants, I already load ALL the data into a single infocube directly - but I am now looking at how I can split the data from the ODS into a Plant-specific infocube.
Can you help please?
Answer:
http://sapfans.com/forums/viewtopic.php?t=99494&sid=947660c72b7f93d03c7335df70e595a1
Answer:
http://sapfans.com/forums/viewtopic.php?t=99494&sid=947660c72b7f93d03c7335df70e595a1
Hi CHC
I did find this note previously - but to be honest it just confused me more.
I have encountered exactly the same problem re the Infopackage selection and the fact that you do not have any selection criteria available.
I take it then that you change the update rule start routine - but could you provide me with an example of code I need to add please?
Kind regards
Answer:
there are numerous thread about sample of code for start routine, so I will let you do your homeworks. maybe a keyword could be datapackage.
Ch
Answer:
In the update rules from your staging ODS to the individual plant cubes, you can create the start routine. There is an icon "Routines info" which gives you a little bit of help.
Within the code:
State your table/s.
Tables: /bio/pplant.
Begin of routine:
Delete data_package
where ( plant NE 'ABCD' ).
Just a heads-up, if you envision the cubes containing a lot of granular data (material document), you may want to have the one staging ODS update a separate ODS for each InfoCube. You can then populate the individual ODS for the specific plant at a granular level and then have the summarized data updated into the corresponding cube. You may want to think about creating a MultiProvider atop the plant-specific infocubes. Possibly one multi for all infocubes. When the queries are created, they are created w/ reference to the Multicube and sub-queries read the data from the plant specific cube. If any changes are made, i.e. new plants are added (probably happens all the time), the changes beneath the multiprovider are transparent to the user.
Bonne chance.
_________________
You always miss 100% of the shots you don't take.