Skip to Content
Former Member
Aug 19, 2008 at 09:00 PM

Mapping staging cube to totals cube



I'm using the data source 0SEM_BCS_10.

I have created my staging cube similar to my Totals cube (0BCS_C11).

I'm stuck in creating update rules for this staging cube, particularly with respect to the follwing feilds:

1) Posting level

Pls let me know how to update this.

Also, help me understand in general, how to write update rules to feilds which exist only in BCS.

2) F Yr of the first acquisition posted

3) Period in which first acq was posted

(Mapping for these will be constant values (actual dates) - correct me if wrong)

4) Mov Type

I guess we need to just map this with the transaction type in ECC.

Many Thanks,