Skip to Content
0
Former Member
Oct 24, 2006 at 01:05 PM

Calculation in Multiprovider

17 Views

Hi, The problem is in the Query, I need to calculate a key figure based on the other 2 key figures.

KF3 = KF1 * KF2

the only issue here is i need to find the KF1 for each material/country/fiscal period from cube 1 and KF2 for each material/country/fiscal period from ODS.

and multiply and then aggregate according to the filter & selection conditions.

can anyone let me know how to do it..

<b>its very urgent.. and any helpful answer appreciated</b>

thank you

Emil