Preparing Multiple-Table Data Sources

In This Section:

Methods for Preparing Multiple-Table Data Sources

Before you use SQL Interface, in the SQL database, create one table or view.
As you load data, join tables by entering a SELECT statement in Administration Services Console.

Access Privilege Requirements

For creating one table or view and for joining tables, you must have SELECT access privileges to the tables in which data is stored. For creating one table or view, you must have CREATE access privileges in the SQL database.

Preferred Method—Creating One Table or View

SQL database servers read from one table and maintain one view more efficiently than they process multiple-table SELECT statements. Therefore, creating one table or view before you use SQL Interface greatly reduces the processing time required by SQL servers.

Joining Tables During Data Loads

If you cannot obtain CREATE privileges, you must use Administration Services to join tables during the data load.

To join tables during the data load:

Obtain SELECT access privileges to the tables in which relevant data is stored.
In Administration Services Console, create a SELECT statement that joins the tables.
1. Identify the tables and columns that contain the data that you want to load into Essbase.
2. Select File, and then Open SQL to display Open SQL Data Sources.
  See the Oracle Essbase Administration Services Online Help.
3. Write a SELECT statement that joins the tables.
  See Selecting SQL Data Sources and Creating SQL Queries (Optional).
  Note:
  Essbase passes the SELECT statement to the database without verifying the syntax.