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:

  1. Obtain SELECT access privileges to the tables in which relevant data is stored.

  2. 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.