Skip to Content
0
Former Member
Mar 20, 2009 at 07:24 AM

how to implement this Planning sequence ?

53 Views

Hello guys,

I have a requirement something like this.

A = B * C / D

where

A = a KF from InfoProvider IC1

B = a KF from Infoprovider IC2

C = a KFfrom inforprovider IC3

D = a KF from infoprovider IC4

this is how i am planning to do it.

1. create a multiprovider over all the Infocubes IC1, IC2, IC3, IC4 & a dummy IC5.& an aggregation level on this multiprovider

2. Do a Copy function with filters to copy the KF B from IC2 to dummy IC5.

3. Do a Copy function with filters to copy the KF C from IC3 to dummy IC5.

4. Do a Copy function with filters to copy the KF D from IC4 to dummy IC5.

5. Implement a Fox formula to do the calculations.

i wanted to know, whether what i have planned is correct ?

or is there a better way to do it ?

Pls give in your suggestions,guys

Thanks

John