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 ‘Variable Manager’ Category

Variable Management OBIEE 10g

Posted by Santosh Kumar Gidadmani on November 11, 2010

You can use variables in a repository to streamline administrative tasks and modify metadata content dynamically to adjust to a changing data environment.

A variable has a single value at any point in time. Oracle BI Server substitutes the value of a variable for the variable itself in the metadata.

You use the Variable Manager to define variables and initialization blocks.

There are three classes of variables

1.) Repository variables

2.) Session variables

3.) Presentation Variable

Repository variables

A repository variable has a single value at any point in time.

There are two types of repository variables

· Static and

· Dynamic

Static repository variables

A static variable have values that are constant and does not change while Oracle BI Server is running.

Dynamic repository variables

It has values that are refreshed by data returned from queries in initialization blocks.

Session variables

Session Variables are created and assigned a value when each user logs on.

There are two types of session variables

· System

· Non system

System variables

They have reserved names and are used for specific purposes by Oracle BI Server, such USERS, GROUP, PORTALPATH etc.

Non-system variables

They are application-specific variables created by an Administrator.

Presentation Variable

Presentation variables are created in the dashboard prompts and can be used in reports and dashboards.

Initialization blocks

These are used to initialize dynamic repository variables, system session variables, and non system session variables

– Santosh

Posted in OBIEE 10g, OBIEE 10g RPD, Variable Manager | Tagged: | Leave a Comment »

%d bloggers like this: