Global Options

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

Design OptionsDescription
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.
Catalog Display OptionsDescription
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 OptionsDescription
Download Database Totals

Download Database Totals 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 AggregationEnables 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 InformationEnabling 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.