Skip to Content
author's profile photo Former Member
Former Member

Selective Loading a cube from an ODS

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 comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 30, 2004 at 09:58 PM

    Navin,

    It is easy to do this via start routine in update rules.

    You can delete from the datapackage if the notification is equal or greater than 3.Thereby only 2 records will be loaded.

    Raj

    Add comment
    10|10000 characters needed characters exceeded