Global Options

Use the Global tab to set global display behavior in the CubeQuery section.

Design Options	Description
Auto-Refresh Query	Queries the database automatically when an item is added to or removed from the data layout, or when the Suppress and Replace options in Query Options are changed. If Auto-Refresh is disabled, you must click Process to query the database whenever you make a change in the data layout. To improve system performance, it is recommended that when you enable the Auto Generate Results option, you disable the Auto-Refresh Query option.

Design Options

Description

Auto-Refresh Query

Queries the database automatically when an item is added to or removed from the data layout, or when the Suppress and Replace options in Query Options are changed. If Auto-Refresh is disabled, you must click Process to query the database whenever you make a change in the data layout.

To improve system performance, it is recommended that when you enable the Auto Generate Results option, you disable the Auto-Refresh Query option.

Catalog Options	Description
Number of members to display	Sets the maximum number of members to display in the Catalog List and Member Selection. The number can be: unlimited 5 10 20 50 100 250 500 The default number of members is 50. In both the Catalog List and Member Selection, the “more…” node expands to the next set of members.

Results Options	Description
Download Database Totals	The Download Database Totals feature creates only one column per dimension, and includes all members, and the corresponding data, in the results set. In addition, a column with each dimension’s parent members is included. By default this option is disabled.
Allow Relational Aggregation	Enables relational aggregation in the following sections: Break/Grand Totals in Results section Data Functions, Totals, Cume in Pivot Data Functions in Chart Data Functions, Break Totals, Show Column Totals in Report. When the Download Database Totals option (see above) is enabled, aggregations are disabled for all the sections dependent on the Results sets with database totals. This option protects users from performing aggregations, where the results may be counted twice. By default this option is disabled.
Include Consolidation Information	Enabling this option includes consolidation type/unary operator information of all members from the Data Layout when Download To Results is executed. Disabling the option excludes the consolidation type/unary operator information for each member. By default this option is disabled for newly inserted CubeQuery sections.