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