Question:
Hello All,
Tried to post this just now - so apologies if it appears twice.
I have a data modelling issue.
We have five years' worth of data in one (very large) ODS object.
I now want to be able to update the data in this ODS object to five different cubes (one for each year).
Obviously, the update from an ODS object to a data target only has one InfoPackage. However, we would like to automate the load and have a series of InfoPackages, each updating the relevant cube.
Is there any way of doing this, other than to manually change the selection conditions in the InfoPackage each time for each year?
Thanks and regards
BW_GUEST
Answer:
Hello,
you can create five InfoPackages with different selections for every year and combine them in a InfoPackage Group.
Another possibilty: Create a start routine in the update rules of your five InfoCubes that filter the uploaded records from the ODS object and let only those pass with the correct time assignment.
Hope that helps
Juergen
Answer:
Hello Juergen,
Thank you very much for your reply. However, that does make me ask:
1. Is it possible to create more than one InfoPackage from an ODS object (I didn't think it was). Not only would you have to create different InfoPackages, each with different time selections, updating different data targets, but also when you made these settings, they would have to NOT be overwritten when you did a subsequent data load from the ODS object to a data target of a different year.
2. Sadly, I'm not an ABAP guru (basic transfer rules for me). Broadly, what kind of ABAP would I need in each of my update rule start routines to exclude the wrong data (i.e. years you didn't want) when updating from the ODS to the cube?
Thanks again and regards
Ian
Answer:
Hello Juergen,
Thank you very much for your reply. However, that does make me ask:
1. Is it possible to create more than one InfoPackage from an ODS object (I didn't think it was). Not only would you have to create different InfoPackages, each with different time selections, updating different data targets, but also when you made these settings, they would have to NOT be overwritten when you did a subsequent data load from the ODS object to a data target of a different year.
2. Sadly, I'm not an ABAP guru (basic transfer rules for me). Broadly, what kind of ABAP would I need in each of my update rule start routines to exclude the wrong data (i.e. years you didn't want) when updating from the ODS to the cube?
Thanks again and regards
Ian