Author Topic: Pass parameter value to crosstab by defined condition  (Read 1576 times)

Offline b737

  • Senior Member
  • ****
  • Join Date: Jun 2013
  • Posts: 74
  • Forum Citizenship: +0/-0
Pass parameter value to crosstab by defined condition
« on: 28 Oct 2019 09:04:15 am »
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

Offline Andrei I

  • Community Leader
  • *****
  • Join Date: Jan 2006
  • Posts: 193
  • Forum Citizenship: +7/-0
Re: Pass parameter value to crosstab by defined condition
« Reply #1 on: 23 Dec 2019 10:41:32 am »
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)