Defining the Hybrid Analysis Retrieval Environment

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

HAENABLE

Enables retrieval of members from a Hybrid Analysis relational source

HAMAXNUMCONNECTION

Sets the maximum number of connections per database that Essbase can keep active against the relational database

HASOURCEDSNOS390

Enables access to DB2 data sources on an OS/390 system

HAMAXNUMSQLQUERY

Sets the maximum number of SQL queries that can be issued against relational database fact tables per Essbase query session

HAMAXQUERYTIME

Sets the maximum time limit per query for SQL queries from a Hybrid Analysis Relational Source

HAMAXQUERYROWS

Sets the maximum number of rows that can be returned per SQL query issued on behalf of an Essbase query

HARETRIEVENUMROW

Sets the maximum number of rows resulting from an SQL query to process simultaneously

HARAGGEDHIERARCHY

Enables support of null values in columns of dimension tables that are used to create dimensions for Hybrid Analysis-enabled outlines

HAMEMORYCACHESIZE

Sets the amount of memory reserved to cache queried members from a Hybrid Analysis relational source

See the Oracle Essbase Technical Reference.