Hi
I have a situation where I need to load data from an ODS to a cube. The upload into the Cube should however only certain records based on the another Data field value. Eg
(ODS KEY = Order Number , Notificatn No.)
Order Number = 1 , Notificatn = 2
Order Number = 1 , Notificatn = 3
Order Number = 1 , Notificatn = 4
Order Number = 2 , Notificatn = 1
Order Number = 2 , Notificatn = 2
Order Number = 3 , Notificatn = 4
Order Number = 3 , Notificatn = 5
From the above example (ODS dataset), I need to load all records into the Cube which in the ODS have never had a Notificatn value greater than or equal to 3 .
Hence in the example above, the infocube load will not include records where the Order Number is 1 or 3 (in the case above) but instead will load two records (both with the Order Number = 2 as this Order Number does not have Notificatn value equal to 3 or greater!)
Could this be done with a start routine in the update rule to the cube or any other way???
Any assistance will be deeply appreciated!!
Thanks in Advance!!
NN
Add a comment