1 Chris Foster kommenterede   Permalink     Ingen bedømmelserBedømmelser 0

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

2 Ty Cardin kommenterede   Permalink     Ingen bedømmelserBedømmelser 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. :-)

3 AUDREY FAUGIANA kommenterede   Permalink     Ingen bedømmelserBedømmelser 0

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

Tilføj en kommentar

Tilføj en kommentar
Count on Business Analytics Supportlink for technical articles, tips and features from our readers and employees. Supportlink is maintained by Fraser Anderson.