Use the configuration settings listed in Table 119 to enable and define Hybrid Analysis for an Essbase Server or specific applications and databases:
Table 119. Hybrid Analysis Retrieval Configuration Settings
Setting | Description |
---|---|
Enables retrieval of members from a Hybrid Analysis relational source | |
Sets the maximum number of connections per database that Essbase can keep active against the relational database | |
Enables access to DB2 data sources on an OS/390 system | |
Sets the maximum number of SQL queries that can be issued against relational database fact tables per Essbase query session | |
Sets the maximum time limit per query for SQL queries from a Hybrid Analysis Relational Source | |
Sets the maximum number of rows that can be returned per SQL query issued on behalf of an Essbase query | |
Sets the maximum number of rows resulting from an SQL query to process simultaneously | |
Enables support of null values in columns of dimension tables that are used to create dimensions for Hybrid Analysis-enabled outlines | |
Sets the amount of memory reserved to cache queried members from a Hybrid Analysis relational source |
See the Oracle Essbase Technical Reference.