OBIEE 12c how to implement case statement in Narrative view based on prompt value

Question

Hi Gurus,

We have a dashboard with a prompt that has drop down values as Daily, Weekly, Monthly, Quarterly and Yearly.

Now my report is a pivot table with a narrative view.

Requirement is when user selects Daily,  then i need to show "Previous day" in narrative view. If user selects Weekly then narrative to show "week to date" and so on.

I am trying to use a case statement in the narrative view but instead of evaluating the case statement, i see the entire text of case statement when i run report.

Can any one please suggest how to implement this.

Thanks in advance,

M De Fanti · Answer

Hi,

I was trying to help, figuring out what he what was he trying to do, Without waiting for a formally perfect question.

Eventually if rjak was looking for something other, he will ask again.

[Deleted User] · Answer

There are tons of hacks which will achieve this, but the question most likely originated in a weird interpretation of what is really intended.

What needs to be achieved is important.The HOW is a function of that - it shouldn't be a purpose in and of itself

M De Fanti · Answer

Hi,

I think that the prompt should be a variable prompt.

Then you should use the variable value to conditionally change the formula of a column in the criteria tab, something like:

INDEXCOL(

CASE '@{PVAR}{Daily}'

WHEN '' THEN 0

WHEN 'Daily' THEN 1

WHEN 'Montly' THEN 2

END ,

'0',

'FILTER(MEASURE USING DATE=....)',

'FILTER(MEASURE USING WEEK=....)')

The narrative view sholud only show the column content.