Creating Rules Files and Selecting SQL Data Sources

  1. Create a data-load rules file; see the Oracle Essbase Administration Services Online Help.

    Data-load and dimension-build rules are sets of operations that Essbase performs on data as the data is loaded into Essbase databases or used to build the dimensions of Essbase outlines. The operations are stored in rules files.

  2. Select a SQL data source.

    See Selecting SQL Data Sources.

  3. If you plan to create SQL queries in Essbase, see Creating SQL Queries (Optional).