COMMENTS [3]

photo
1 Chris Foster commented   Permalink     No RatingsRatings 0

Could you confirm that this technique can be used in a chart? It seems to always appear blank when used as a measure.

photo
2 Ty Cardin commented   Permalink     No RatingsRatings 0

Interesting article. Thank you for the contribution.

 
However, I have a need that I have been unable to find a solution to. I have a report that on a TM1 cube and the columns required YTD calculations (totals) on. The issue is that the report, of course, needs to be changed every month. This returns the correct result:
total([Actual] within set periodstodate([package].[Period].[Period].[Month],[Jul_11])). However, I need to be able to replace the [Jul_11] with a parameter value based on the user prompt, if I continue to use periodstodate. I have tried the subset function, but it fails if within the periodstodate or total function, but is fine outside of that or the total function.
 
Help. This thing has whipped me. :-)

photo
3 AUDREY FAUGIANA commented   Permalink     No RatingsRatings 0

Hello, I just cant get this work ... I really need this in my report... Can you help?

Add a Comment

Add a Comment
ABOUT THIS BLOG
Count on Business Analytics Supportlink for technical articles, tips and features from our readers and employees. Supportlink is maintained by Fraser Anderson.