member sets in prompt

[Deep750]

Hi,
I have a requirement, to create sets, so that users can choose either set 1, 2 or 3, when running the report.
Set1 is set([].[].[].[]->[].[].[].[1].[13].[131].[1311]; [].[].[].[]->[].[].[].[1].[13].[131].[1312]; [].[].[].[]->[].[].[].[1].[13].[131].[1313])
Set2 is set([].[].[].[]->[].[].[].[1].[13].[131].[1312]; [].[].[].[]->[].[].[].[1].[13].[131].[1313]; [].[].[].[]->[].[].[].[1].[13].[131].[1316])
Set3 is set([].[].[].[]->[].[].[].[1].[13].[131].[1311]; [].[].[].[]->[].[].[].[1].[13].[131].[1313]; [].[].[].[]->[].[].[].[1].[13].[131].[1316])

I was thinking of making a static choice, but i'm not sure how to solve it...
The source is Dynamic Cubes.

to add complexity, I'm supposed to drill through, passing the chosen set to a relational report.


Any suggestion on how to solve it? My aim is to add the selection to a slicer

[Lynn]

nf your static choice prompt put the set expressions as the 'use' values. Use a prompt macro with a type 'token' in your slicer expression, specifying one of the sets as the default.

#prompt ( 'Select a Set', 'token', 'set([].[].[].[]->[].[].[].[1].[13].[131].[1311]; [].[].[].[]->[].[].[].[1].[13].[131].[1312]; [].[].[].[]->[].[].[].[1].[13].[131].[1313])' )#

Not sure about the drill through but I suppose you could pass the captions or business keys from a set to the target report. Not entirely certain.

[Deep750]

Thanks Lynn. Token prompt solved the issue  :)
Now the next issue is the drill though.
If I send the parameter, it sends the whole string - so it doesn't work.

I then tried to solve it by creating a data item, where I send the values required on the drill through report, using #csv(array('1311';'1312'; '1313')# in the then-part of the case statement.
But the csv array gives error.

Have anyone used the function, and got it to work?

I'm on C10.2.1

Code Select Expand

case ?P_Konto?
WHEN 'set([DC  eiendom VC (analyse)].[Dim Konto].[Konto N1 til N4].[Konto]->:[RO].[Dim Konto].[Konto N1 til N4].[All].[1].[11].[113].[1131]; [DC eiendom VC (analyse)].[Dim Konto].[Konto N1 til N4].[Konto]->:[RO].[Dim Konto].[Konto N1 til N4].[All].[1].[12].[126].[1269]; [DC eiendom VC (analyse)].[Dim Konto].[Konto N1 til N4].[Konto]->:[RO].[Dim Konto].[Konto N1 til N4].[All].[4].[43].[432].[4320]; [DC eiendom VC (analyse)].[Dim Konto].[Konto N1 til N4].[Konto]->:[RO].[Dim Konto].[Konto N1 til N4].[All].[4].[43].[432].[4321]; [DC eiendom VC (analyse)].[Dim Konto].[Konto N1 til N4].[Konto]->:[RO].[Dim Konto].[Konto N1 til N4].[All].[4].[43].[432].[4322]; [DC eiendom VC (analyse)].[Dim Konto].[Konto N1 til N4].[Konto]->:[RO].[Dim Konto].[Konto N1 til N4].[All].[4].[43].[433].[4330])'
THEN  #csv(array( '4320'; '4321'))#
ELSE '4323'
END