Web Catalog does contain object permissions: folder, reports, etc. The repository has objects permissions to Subject Areas, etc.

A single query can be performed accessing data from both tables through a join on the columns in the foreign key relation.

A data warehouse is a database used for reporting and data analysis . It is a central repository of data which is created by integrating data from multiple disparate sources. Data warehouses store current as well as historical data and are commonly used for creating trending reports for senior management reporting such as annual and quarterly comparisons.

Level-based Hierarchy

Level-based hierarchy is the first type of hierarchy in OBIEE.

Consists of an ordered set of two or more levels . For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level -based hierarchies can also contain parent-child relationships.

Dimension hierarchy levels allow :

* to perform aggregate navigation,

* to configure level-based measure calculations,

* users from Dashboard and Answers to drill down from one parent to a child level.

Special type of level-based dimension are supported:

* Unbalanced (or ragged) and Skip-level hierarchy

* time dimension to provides special functionality for modeling time series data.

An action link is a link to an action that you have embedded in an analysis, dashboard page, scorecard objective, scorecard initiative, or KPI that, when clicked, runs an associated action.

Note 1: There are four types of variables that you can use:

Session

Repository

Presentation

Request

Note 2: Session Variables

A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it.

There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value.

There are two types of session variables:

System — A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes.

System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables).

Non-system — A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user ' s sales region.

The administrator creates non-system session variables using the Oracle BI Administration Tool.

After creating your base metrics, try using the Calculation Wizard to automate the process of creating time-series metrics or comparison metrics such as: Change, Percent Change, Index, and Percent. The Wizard may save you many hours of time and frustration, especially if you have to create more than a handful of these metrics. In addition, the Wizard allows you to include customized logic to handle nulls in the base metrics. You may refer to the Oracle documentation for further detail.

If security attributes conflict, a user or group is granted the least restrictive security attribute.

Modeling Time Series Function in OBIEE

Modeling Time Series Data

Time series functions provide the ability to compare business performance with previous time periods, allowing you to analyze data that spans multiple time periods. For example, time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.

Because SQL does not provide a direct way to make time comparisons, you must model time series data in the Oracle BI repository. First, set up time dimensions based on the period table in your data warehouse. Then, you can define measures that take advantage of this time dimension to use the AGO, TODATE, and PERIODROLLING functions.

You do not use ODBC DSN to compare repositories.

Note: When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect.

Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage of the data source.

The DSN (data source name) is a data structure that contains the information about a specific data source (database, …), typically used by an ODBC driver to be able to connect to it.

The DSN contains information about the data source such as:

the name,

the directory,

and the driver.

On Windows, the DSN also specifies the ODBC driver to be used to access the database.