Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘Presentation Variable’ Category

Presentation Variable

Posted by Santosh Kumar Gidadmani on May 31, 2011

Presentation variable is the only variable created and used in the presentation services like in dashboard and Answers.

Presentation variables are simple to create unlike dynamic and session variables. You can call presentation variable in different areas for different purpose in Answers title, filter, dashboard prompt etc.

How to create Presentation Variable

Go to dashboard prompt and on the set variable click on presentation variable and provide any name to it.

Note: Set variable option will pop up only when you select either drop-down list or Edit box in the Control option. This will not work if you select multi-select option.

Save the prompt, the presentation variable will be created.

Where to use Presentation Variables

Report Title

Create a report or use the existing report and go to title edit view as shown below.

On the sub title, use your presentation variable as Sales report for @{Country} Country.

@{Country} – This is the simple format to call the presentation variable in different areas. Country is the presentation variable name.

@{variables.<variableName>}{<default>}[format] – This is the complete syntax for using presentation variable.

Example: @{Country}{‘America’}, @{Date}{DATE ‘2011-05-31’}

Save the report and check on the dashboard.

Select the country to filter in the dashboard prompt and click go.

You can see that the presentation variable is changed in the report title to the country we selected on the prompt.

– Santosh

Posted in OBIEE 10g, OBIEE 10g Answers, OBIEE 10g Dashboard, Presentation Variable | 1 Comment »

%d bloggers like this: