Hello everyone,
I am trying to figure out the best way to build a slicer from a tree prompt off a TM1 cube.
I have a dimension (called "Period") with levels "All Periods", "Year" and "Month". I have Prompt page that is showing Years. In this I can select either a Year, or click the plus sign and select a Month which is then passed to the paramter pPeriod. Sweet.
In my report then I have a slicer "set ( [cubename].[Period].[Period].[Month] -> ?pPeriod?)", which obviously only works when I select a Month from the prompt. If I choose a Year, it fails.
What do I need to do to make the slicer work for when either a Year or Month is selected please?
Thanks!
John
Quote from: jv_oz on 07 Mar 2017 09:53:44 PM
Hello everyone,
I am trying to figure out the best way to build a slicer from a tree prompt off a TM1 cube.
I have a dimension (called "Period") with levels "All Periods", "Year" and "Month". I have Prompt page that is showing Years. In this I can select either a Year, or click the plus sign and select a Month which is then passed to the paramter pPeriod. Sweet.
In my report then I have a slicer "set ( [cubename].[Period].[Period].[Month] -> ?pPeriod?)", which obviously only works when I select a Month from the prompt. If I choose a Year, it fails.
What do I need to do to make the slicer work for when either a Year or Month is selected please?
Thanks!
John
How about
set( [cubename].[Period].[Period] -> ?pPeriod? )
MF.
You bloody ripper! Thanks heaps @MFGF!
QuoteYou bloody ripper!
Antipodean by any chance 8) ;D
Quote from: jv_oz on 09 Mar 2017 04:07:59 PM
You bloody ripper! Thanks heaps @MFGF!
No worries, mate :)
MF.