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]')#
Quote from: Robl on 05 Feb 2015 04:26:15 AM
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.
Nice one.
Have a virtual thursday beer on me.
Quote from: Robl on 05 Feb 2015 04:39:43 AM
Nice one.
Have a virtual thursday beer on me.
Ha! I might just do that later, Robl :)
Cheers!