This content has been marked as final. Show 4 replies
Not clear where you going to use that case statement. But you may use the presentation variable within Answers.1 person found this helpful
I assume you are trying write the case in column expression of Criteria tab.
If helps mark
You can pass a selected value from prompt to filter a measure or display it as a dynamic label/column header.
To set the label like a dynamic column header:
If that is for the measure value then use presentation variable and use them in the formula of the column.
If that is to pass value to the physical layer or bmm layer then use session variable, set it using request variable in prompt and use the session variable in bmm or physical layer view.
Let me know if this helped.
Thanks. What I aim to do is is create data labels based on users input. THe Case statement is going into Column Measures in the included subject pane under the criteria tab. What I would like to do is create a prompt that will allow the users to input a date range and based on the date they select in the prompts pass that information to the SQL code running in and provides the logic for the labels to be created.
Edited by: Hangten4881 on Mar 4, 2013 9:55 AM
Labels I'm not sure how it going to be but for other cases that should work.
How about Jay's solution?
Edited by: Srini VEERAVALLI on Mar 4, 2013 1:17 PM