Slicer prompt macro help

[Robl]

Below is a slicer prompt.
It works fine when I run it with nothing in the prompt, but whenever I enter a prompt value is breaks.
Even if I enter the prompt value of [banana].

Can anyone suggest what I've done wrong, or a better (industry standard?) way of doing this.
Thanks.

[Activity].[THINGS].[THINGS].[THING]->:[PC].[@MEMBER].#prompt('THINGPROMPT','Token','[banana]')#

[MFGF]

Below is a slicer prompt.
It works fine when I run it with nothing in the prompt, but whenever I enter a prompt value is breaks.
Even if I enter the prompt value of [banana].

Can anyone suggest what I've done wrong, or a better (industry standard?) way of doing this.
Thanks.

[Activity].[THINGS].[THINGS].[THING]->:[PC].[@MEMBER].#prompt('THINGPROMPT','Token','[banana]')#

Hi,

The important question is - what does a MUN look like in your cube? From your expression, I'd guess it is

[Activity].[THINGS].[THINGS].[THING]->:[PC].[@MEMBER].[banana]

If so, you need to change your expression to be the following:

#'[Activity].[THINGS].[THINGS].[THING]->:[PC].[@MEMBER].[' + prompt('THINGPROMPT','token','banana') + ']'#

Cheers!

MF.

[Robl]

Nice one.
Have a virtual thursday beer on me.

[MFGF]

Nice one.
Have a virtual thursday beer on me.

Ha! I might just do that later, Robl :)

Cheers!