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...
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.
:o Wow.
Thank you very much ReportNet Addict.
It works at the first time.
your welcome.. Plz close the topic...