OBIEE Presentation Variable To Dynamically Switch Filtered Column Values Based On Dashboard Prompt V

Summary

Unable to read value of presentation variable.

Content

Hi All,

I am trying to follow steps in - http://obinsight.blogspot.com/2012/03/obiee11g-presentation-variable-to.html?_sm_au_=ijVJFGDTK8tnWr7S

on subject Area - "Workforce Performance - Performance Rating Real Time".

Step 1:I need to create a dashboard prompt which lists three static values and assign's a Presentation variable.

Values are - Business Unit, Grade, Gender

Code -- 

SELECT case when 0= 1 then "- Hierarchy"."Level 1 Department" else 'Business Unit' end FROM "Workforce Performance - Performance Rating Real Time"
  union all

SELECT case when 0= 1 then "Grade"."Grade Name" else 'Grade' end FROM "Workforce Performance - Performance Rating Real Time"