OBIEE - Dynamic selection from prompt and its manipulation

Question

Hi Guys,

I want to select 6 (continuous) months from prompt and display them on report.

But also i want create calculated Measure which will hold the difference between the 2 latest months from selected months.

Note : Month column has datatype var-char.

I want to know is this possible?

Thanks and regards.

EmmanuelMash · Answer

There are quite a number of ways to achieve this. One is to make use presentation variables like already suggested above or you can the default selection in your new prompt window. You can choose the SQL Results option and write a sql statement using the TIMESTAMPADD feature i.e First get current_date then go back six months using SQL_TSI_MONTH,6

User_N8YMF · Answer

Hi,

Its doable in a dashboard. Select one value from the dashboard prompt, store it in a presentation variable and then calculate and arrive at the remaining months in a hidden prompt, and you can other possible calculations in the hidden prompts as well and then use it in the report.

Thanks

Rajesh

Gianni Ceresa · Answer

Hi,

I would say it's doable.

But I wouldn't select the 6 months from the prompt as you can't force the user to select continuos months, so you better ask the user to select 1 months and then you do all your logic.

For example the user select the last month, you then display 6 months going back from the selected one and the rest of the logic.

Everything is doable ... it's just some logic in filters etc.