SQL Interface is installed during Essbase Server installation. See the Oracle Enterprise Performance Management System Installation and Configuration Guide for information about initial configuration tasks.
Configure the ODBC driver, and point it to its data source. See Configuring Data Sources.
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.