In This Section:
You can use the SQL Interface feature to build dimensions and to load values from SQL and relational databases. For example, you can execute SQL statements that specify retrieval of only summary data.
You do not need SQL Interface for spreadsheet or text-file data sources that can be loaded using Oracle Essbase Administration Services, MaxL, or ESSCMD. See the Oracle Essbase Database Administrator's Guide and the Oracle Essbase Technical Reference.
With SQL Interface, you can load data from a Unicode-mode relational database to a Unicode-mode Essbase application. For information on the Oracle Essbase implementation of Unicode, see the Oracle Essbase Database Administrator's Guide.
SQL Interface works with Administration Services to retrieve data:
Using Administration Services, you write a SELECT statement in SQL.
SQL Interface passes the statement to a SQL or relational database server.
Note:
As needed, SQL Interface converts SQL statements to requests appropriate to non-SQL databases.
Using the rules defined in the data-load rules file, SQL Interface interprets the records received from the database server. (For information on data-load rules files, see Loading SQL Data.)
SQL Interface loads the interpreted summary-level data into the database.
SQL Interface is installed during Essbase Server installation. See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide for information about initial configuration tasks.
To prepare for using SQL or relational data sources:
Configure the ODBC driver, and point it to its data source. See Configuring Data Sources.
If data is contained within multiple tables, perform an action:
Before using SQL Interface, in the SQL database, create one table or view.
During the data load, join the tables by entering a SELECT statement in Administration Services.
See Methods for Preparing Multiple-Table Data Sources for instructions.
Verify the data source connection by using Data Prep Editor, in Administration Services Console, to open the SQL source file. See Loading SQL Data.
Create a rules file that tells SQL Interface how to interpret the SQL data that is to be used with the Essbase database. See Loading SQL Data.
After these steps are complete, you can load data or build dimensions; see Loading SQL Data.
Getting the Latest Version of Help
The most recent English version of this help system is available in the EPM System Documentation Library on Oracle Technology Network (OTN):
http://www.oracle.com/technology/documentation/epm.html
You can use the SQL Interface feature to build dimensions and to load values from SQL and relational databases. For example, you can execute SQL statements that specify retrieval of only summary data.
You do not need SQL Interface for spreadsheet or text-file data sources that can be loaded using Oracle Essbase Administration Services, MaxL, or ESSCMD. See the Oracle Essbase Database Administrator's Guide and the Oracle Essbase Technical Reference.
With SQL Interface, you can load data from a Unicode-mode relational database to a Unicode-mode Essbase application. For information on the Oracle Essbase implementation of Unicode, see the Oracle Essbase Database Administrator's Guide.
SQL Interface works with Administration Services to retrieve data:
Using Administration Services, you write a SELECT statement in SQL.
SQL Interface passes the statement to a SQL or relational database server.
Note:
As needed, SQL Interface converts SQL statements to requests appropriate to non-SQL databases.
Using the rules defined in the data-load rules file, SQL Interface interprets the records received from the database server. (For information on data-load rules files, see Loading SQL Data.)
SQL Interface loads the interpreted summary-level data into the database.
SQL Interface is installed during Essbase Server installation. See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide for information about initial configuration tasks.
To prepare for using SQL or relational data sources:
Configure the ODBC driver, and point it to its data source. See Configuring Data Sources.
If data is contained within multiple tables, perform an action:
Before using SQL Interface, in the SQL database, create one table or view.
During the data load, join the tables by entering a SELECT statement in Administration Services.
See Methods for Preparing Multiple-Table Data Sources for instructions.
Verify the data source connection by using Data Prep Editor, in Administration Services Console, to open the SQL source file. See Loading SQL Data.
Create a rules file that tells SQL Interface how to interpret the SQL data that is to be used with the Essbase database. See Loading SQL Data.
After these steps are complete, you can load data or build dimensions; see Loading SQL Data.