O'Reilly logo

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial by Adrian Ward, Haroun Khan, Christian Screen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Variables and initialization blocks

Outside of the three layers of RPD development, there are also other sections of functionality that help to support the creation of reports and dashboards. The most important of these are the ability to create variables that end users can use in their reports. There are two types of variable:

  • Repository: Set for the system as a whole and is refreshed at set periods
  • Session: Individual to the user or session when they login

To create either of these, we need to create what is called an initialization block in order to instantiate these variables.

Let's create a repository variable. The first step is to click on Manage | Variables:

This brings us to the Variable Manager screen. Here, create a new Init Block by navigating ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required