Skip to Content
0
Former Member
Nov 27, 2006 at 09:52 AM

Update routine while loding data to cube

29 Views

Hi All,

I got Two ODSs.I want to load data from these two ODS into a single cube. Cube consists of fields from both ODS. I want to load the data from ODS1. while loading the data i need to get the corresponding fields from ODS2 based on a condition.

e.g.

My cube got fields a,b,c,d,e,f,g.( f,g are key figures).

My ODS1 got a,b,c,f (f is a key figure).

MY ODS2 got d,e,g (g is a key figure).

My condition is if ODS1-a = ODS2-d, then my cube record should be a,b,c,d,e,f,g.

There r more than 1 field in ODS1 with equal value. For all these records i need the corresponding fileds from ODS2.

Can anyone suggest how to write routines for this?

It is a urgent Requirement.

Regards,

Ramana.