Hi,
I have 5 value prompts on prompt page, where all five prompts represent each level from same dimension, and cascading ,and on report page I have crosstab. I want to create:
if user selects just first prompt - Level1, to send to crosstab value for L1 and to automatically run all members from Level 2 for chosen L1 on same cross
If user selects on prompt page some member from prompt for Level2, to send to crosstab value for Level2 to and to automatically run all members from Level 3 for chosen L2 on same cross
If user selects on prompt page some member from prompt for Level3, to send to crosstab value for Level3 to and to automatically run all members from Level 4 for chosen L3 on same cross
.......
Is this possible?
Tnx for help
Yes. It is possible.
I assume you are using a Dimensional datasource.
You do not need multiple Level Prompts. Just use a Tree Prompt.
It will allow you to select members at different levels
Then you can define Data Items as follows:
// set will allow multiple selections
[Selected Level]:= set( [Dimension].[Hierarchy]->?par_name? )
e.g. set([great_outdoors_cube].[Products].[Products]->?Product Line?)
[Next Level]:= descendants ([Selected Level],1)
See attached example for details (C10, PP Cube Great Outdoors)