This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

It's in the DBAG

February 21 2013 at 8:06 AM
No score for this post
Cameron Lackpour 
from IP address 98.111.157.125


Response to Not clear

You need to read this over:
http://docs.oracle.com/cd/E10530_01/doc/epm.931/html_esb_dbag/dcadynca.htm#dcadynca15843

What's happening is that the attribute calc (which is a dynamic roll up of the sparse dimensions)happens last, overwriting whatever two-pass value you calculate.

Per the DBAG:
If your data retrieval uses attribute members, the last step in the calculation order is the summation of the attributes. However, the use of attribute members in your query causes Essbase to disregard the value of the Time Balance member in the dynamic calculations. During retrievals that do not use attributes, the value of the Time Balance member is applied to the calculations. The difference in calculation procedure between the use and non-use of attribute members generates different results for any upper level time members that are dynamically calculated.

They're talking about Time Balance but the concept is the same.

The DBAG goes on to say:
During retrievals that do not use attributes, these dynamically calculated members are calculated in the last step and, therefore, apply the time balance functionality properly. However, during retrievals that do use attributes, the summation of the attribute is the last step applied. The difference in calculation order produces two different, predictable results for upper level time members that are dynamically calculated.

See, it's not a bug, it's a feature. :)

If you can't rewrite the logic, I am afraid you are going to have to fix this in the report layer.

Regards,

Cameron Lackpour

 
Scoring disabled. You must be logged in to score posts.Respond to this message   

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.