Table 12. Result Set Configuration Properties
| Property | Description |
|---|---|
| MaxDataCellLimit | OLAP database connection query result set size |
| MaxJdbcCellCount | Relational database connection query result set size |
| MaxChartRowsLimit | Maximum series in charts |
| MaxMemberQuerySize | Number of members to retrieve at one time when supporting Essbase Cursoring in the Dimension Browser This is useful when some outlines many have too many members at one level, resulting in slow Dimension Browser performance when expanding the node. To improve performance, you can limit the number of children on each call by setting this property to a reasonable value. If there are more children available, a “...” symbol is displayed. For optimal performance, do not set the value above 500. To disable this feature and retrieve all children, set the value to -1. |
| FetchMemberSize | Number of members retrieved in one metatdata query |
| MaxMemberQueryLimit | Maximum number of members returned by member queries and the preview selection in the Dimension Browser |
| MaxSubscriptionControlSize | Maximum members returned by subscription control and preview selection calls |
| AggregatedMemberQuerySize | Member Query batch size. Determines the way Web Analysis performs Essbase member queries. If AggregatedMemberQuerySize=0, Web Analysis resolves OLAP members one-by-one with five TCP connections to Essbase for each member. Otherwise, Web Analysis aggregates a specified number of members into one ALE member query and resolves members in one call to the Oracle Essbase server. |