Selecting SQL Data Sources

  To select SQL data sources:

  1. In Administration Services Console, open Data Prep Editor or a rules file.

  2. Select File, then Open SQL.

  3. In Select Database, enter the names of the Essbase Server, application, and database, and click OK.

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

  5. Click OK/Retrieve.

  6. In SQL Connect, enter the user name and password for the source database, and click OK.

Facts about data source files: