Slicer from Muli Level Dimension

[jv_oz]

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

[MFGF]

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.

[jv_oz]

You bloody ripper! Thanks heaps @MFGF!

[BigChris]

You bloody ripper!

Antipodean by any chance  8) ;D

[MFGF]

You bloody ripper! Thanks heaps @MFGF!

No worries, mate :)

MF.