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

Re: Y-T-D with fixed values

February 20 2013 at 3:42 PM
No score for this post
Jake Turrell 
from IP address

Response to Y-T-D with fixed values

While order of calculation may be part of the issue here, I believe the root cause is that you can't refer to DTS members in a member formula. They're "virtual" members. The only way to get a formula to apply specific logic to a DTS member is via "exclusion" in an IF statement.

Here's how it works - in your formula you have conditional logic that says if you're one of these time period members (and this logic must include ALL time period members) . . then execute some logic. Then at the end you have an ELSE statement. It is in this ELSE section (because you have already excluded all "real" time periods) that you can include logic to be applied to DTS members. But here's the catch . . . you can't differentiate between different types of DTS members. So a YTD member would get the same treatment as a QTD member, and so on.

Because you cannot differentiate between different flavors of DTS members in this logic, this solution typically doesn't cut it. But beyond that, you're out of luck. You can't reference a DTS member in a formula.

Hopefully my rambling post makes sense and I understood the question correctly.

- Jake

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

RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.