If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Pass parameter value to crosstab by defined condition

Started by b737, 28 Oct 2019 09:04:15 AM

Previous topic - Next topic

b737

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

Andrei I

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)