To select SQL data sources:
In Administration Services Console, open Data Prep Editor or a rules file.
In Select Database, enter the names of the Essbase Server, application, and database, and click OK.
In Open SQL Data Sources, select the data source or the substitution variable, and enter required information.
See “Opening an SQL Database” in the Oracle Essbase Administration Services Online Help.
In SQL Connect, enter the user name and password for the source database, and click OK.
Facts about data source files:
The data source file must be configured on the server computer.
On UNIX platforms, the path for the SQL data source file is defined in the .odbc.ini file.
On Windows, if the path for the SQL source file was not defined in ODBC Administrator, it can be entered in the Database box of the Define SQL dialog box.
If a path is not defined, Essbase looks for the data source file in the directory from which Essbase Server is running.