Choice list filter with display and return value

Question

Hi,

Is there a possibility to create a “choice list” filter with a return value that differs from its display value.

For example we have some date filter with the following options:

Display

Return

3 months ago

90

1 month ago

30

7 days

7

1 day ago

1

(Arguably, the first 2 values should be calculated.)

In the create filter form however we can only enter the display values.

I noticed this question was asked a long time ago:

Displaying description in prompt by selecting corresponding ID

And there is a solution to move the case from the filter per analysis to a function:

How to display description in the prompt and filter by id ~ OBIEE - Oracle Business Intelligence Blog

But when I open a dashboard and check the HTML source code, I find the following in the script at the bottom:

{"caption":"3 Months Ago","codeValue":"3 Months Ago","eType":0}

And a property preceding this:

"isDoubleColumnInput":false

That property could mean sth. else but it sure seems like there should be a possibility to not only set the “caption” but also set the “codeValue”.

Is this a property than can be enabled?

Thanks!

Dries

Dries C · Answer

Hi Joel,

Thanks for your answer. This is actually the way we're doing things at the moment.

I was looking for a way to define the values straight away, as part of the choice list.

If you're used to working with HTML, it's very strange not to be able to define the return values.

Seeing as the "codeValue" attribute is mentioned in the pages javascript, I thought maybe it was an option that could be enabled.

Dries

Joel Acha · Answer

You'll need to do this in 2 steps:

* Create a Dashboard Variable Prompt:

* In your analysis on the same page as your dashboard prompt, you can have a column/filter with formula similar to this that references the presentation variable which is populated via the dashboard variable prompt from above: