Define Rules that Query External Sources

Using SQL queries, you can pull or push data to Essbase from external sources of data. You need to configure Essbase to access the external sources.


  1. The rule file must exist in the cube directory for the relevant Essbase cube.

  2. The database query used to load data or build dimensions must have the same dimensionality as the columns in the rule. (In other words, the order of dimensions in the rule file must match the order of dimensions in the SQL query).

  3. Only use SQL functions that are supported by JDBC. ODBC scalar functions are not supported in CLI.