how to implement this Planning sequence ?

[Former Member]

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

[Former Member · Accepted solution]

You dont need dummy cube. Just create a multiprovider which includes these 4 cubes, an aggregation level on the top of it and a formula function. Keep infoprovider in the fields to be changed, write the below (very simple) code. {kf, IC1} = {kf, IC2} * {kf, IC3} / {kf, IC4}.

[Former Member · Accepted solution]

Hello Bindu,

I fear i wont be able to do that.

Kf A is a KF which has value at a day level. e.g. distribution key for each day of the week

Kf B is a KF which has a value at a week level.e.g. distribution key for each week of the year.

will then, your logic work ?

Thanks

John

[Former Member · Accepted solution]

Hi,

In that case, do you have that data on daily basis stored somewhere. I mean is there any way to retrieve it. If not, and if the average can suffice your purpose, then you can modify the formula to

{kf, IC1} = {kf, IC2} / 7 * {kf, IC3} / {kf, IC4}.

Thanks,

Nilanjan