Hi,
I have created a tree prompt with help of assistant. From that I get a new Query with 1 Dataitem DIM1 = rootmembers([cube1].[DIM1].[DIM1]).
If I run the report, I get the tree prompt with DIM1 as Element. By clicking on + sign left from the element, I can navigate.
After that, I have added additional prompt with static values 'DIM1', 'DIM2','DIM3'. I have changed the 1. prompt to be cascaded from the 2. one.
Then I changed dataitem DIM1 from 1. prompt:
DIM1= CASE ?prompt2param'
WHEN 'DIM1' THEN rootmembers([cube1].[DIM1].[DIM1])
WHEN 'DIM2' THEN rootmembers([cube1].[DIM2].[DIM2])
WHEN 'DIM3' THEN rootmembers([cube1].[DIM3].[DIM3])
END
WHEN I run the report now, I first chose DIM1 and I get the rootmember of hierarchy [cube1].[DIM1].[DIM1] in the tree prompt as expected, but the
+ symbol to navigate within the hierarchy is lost.
Any ideas how to get it back ? Any help appreciated.
Colt
doesn't seem like you're really using "cascading" prompts. I'm no expert at MDL, but you may have to use slicers with data items set to some combination of item or descendants along with set and perhaps a #prompt macro.