Question:
We have a requirement to calculate various KYS in our update rules using other calculated KYF.
Unfortunately there doesn't seem to be a way of accessing other KYF in the cube when writing routines for some other KYF other than to duplicate the entire code but this is going to be highly inefficient .
I wanted to know what would happen if I declare a global variable and store the result of KYF 1 in it and then use it while calculating KYF 2 .
How do you ensure the proper sequence of computation of key figures in this case ?
As a last resort I want to go to the start routine as the code is quite complex and I have to build up my own internal tables as replica's of the data package with addl. computed fields .
Any thoughts will be greatly appreciated.
Thx
ST
Answer:
sequence computation is no problem in the query designer
if you have for example :
CKF3 = CKF1 / CKF2
CKF1 = KF1 * KF2
CKF2 = KF3 + KF4
You don't have to worry about CKF (worries like "is CKF1 and CKF2 going to be calculated before this??") because in the system he does not actually store it as "CKF1/CKF2", but he stores it broken down :
CKF3 = (KF1 * KF2) / (KF3 + KF4)
Answer:
Thanks for your reply.
But my questions was more directed towards the sequencing of computation in the update rules .
We want to compute and store these values in the cube as the formula's are quite complex to build in query designer .
Is there a way of using one calculated key figure in another by writing routines at KYF level as pposed to doing everything in the start routines .
Thanks