[RS8] Dynamic Field change

[tosty]

Hi all,

I would like to assign to a column in a Crosstab a dimension depending in the values choosen in a prompt.

My source is a PowerCube and what I would like to do is to have a column depending on the user selection on a prompt.

For example I have a Date Dimension with an Alternte path that includes comparrisions between the first 3 month of the actual year and the prevoius year and the same for the first 6 months and for the first 9 months. So what I want to do is to creat a kind of "variable column" that will have differents columns depending on the selection.

Any Ideas in this matterÃ,  Ã, ;D.


thanks...

[sir_jeroen]

Ok... I'll make a suggestion:

add a calculation
Name : Dynamic_Column
Expression: #prompt('Selected_Column','token','[namespace].[querysubject].[queryitem]')#

Create a valueprompt on the prompt page.
as parameter use: Selected_Column

Add the following static values:
Use: [namespace].[querysubject].[queryitem]
Display: This_is_the_default_text

Add some extra values to your valueprompt also referencing to valid query items.


Explanation:
Replace [namespace].[querysubject].[queryitem] for a valid queryitem.
Now this expression will be passed to the C8 server. If nothing is chosen the server will use the default value as specified in the #prompt(...)# expression (default is [namespace].[querysubject].[queryitem] as you have specified in the expression).
If the selects something from the prompt that value (queryitem) will be used.
So now you have created a dynamic column without if... then .. else .. statements.

[tosty]

 :o Wow.

Thank you very much ReportNet Addict.

It works at the first time.

[sir_jeroen]

your welcome.. Plz close the topic...