You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

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

edited Oct 29, 2018 3:54AM in Reporting and Analytics for HCM 1 comment

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"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!