Example of Presentation Variable in OBIEE

I am gonna tell you one of its simplest example.

You have a Dashboard wherein there is a

Report with Employee Name, Salary and New Salary

and a Rating Prompt.

And I am using the following SQL to display the values in Rating Prompt.

Select case when 1=0 then “Department”.”DEPTNO” else 1 End from “Test”

UNION ALL

Select case when 1=0 then “Department”.”DEPTNO” else 2 end from “Test”

So this Prompt will display value 1 and 2 in the dropdown list.

Note: You can use any dummy column in place of “Department”.”DEPTNO” because the first condition would always be false.

Whenever the user selects a value from the dropdown, its value is set in Presentation variable called Rating.

Now, I will use this Presentation variable to calculate New Salary in the report.

If the Rating is 1 then New Salary = Salary+200 else the same salary.

Result:

When Rating =1

When Rating =2