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
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.
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
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