OLAP Options

Use the OLAP Options tab to select OLAPQuery and CubeQuery options.

To select OLAP options:

Select Tools, then Options, and then Program Options.
The Interactive Reporting Options dialog box is displayed.
Click the OLAP tab.
Select the desired options and click OK.
See the Results .OLAP Query, and Query options below.

Table 11. Results Options

Results	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. If this option is enabled through the Tools, then Programs, and then the OLAP menu, the Query option is enabled also in a newly created CubeQuery section. Note: If you open anInteractive Reporting version 11.1.1 document that contains data in Results downloaded from a CubeQuery with version 9.3.1, the existing Results data is not visible. Furthermore, using the “download to results” feature with an Interactive Reporting document created with Interactive Reporting version 11.1.1, the result set is not be the same as it was with version 11.1.1.
Auto Generate Results When Processing OLAP Query	Creates a Results section for any future OLAPQuery section when that OLAPQuery section is first processed.

Results

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. If this option is enabled through the Tools, then Programs, and then the OLAP menu, the Query option is enabled also in a newly created CubeQuery section.

Note:

If you open anInteractive Reporting version 11.1.1 document that contains data in Results downloaded from a CubeQuery with version 9.3.1, the existing Results data is not visible. Furthermore, using the “download to results” feature with an Interactive Reporting document created with Interactive Reporting version 11.1.1, the result set is not be the same as it was with version 11.1.1.

Auto Generate Results When Processing OLAP Query

Creates a Results section for any future OLAPQuery section when that OLAPQuery section is first processed.

Table 12. OLAP Query Options

OLAP Query	Description
Use OLAPQuery section	Enable the display of a new OLAPQuery (Essbase) section in the pre Release 9.3.1 section format. This option also enables pre Release 9.3.1 section functionality. This setting applies only to subsequent OLAP queries, and not an existing OLAP query. By default, new Essbase queries use the CubeQuery Section type. A pre Release 9.3.1 OLAP query and an OLAP query with a CubeQuery section type can co-exist in the same Interactive Reporting document (BQY).
Show Dimension Root Level (ODBO Level 0/Essbase Generation 1) Data	Enable the display of level 0 and generation 1 data in the OLAP tree. If you intend to use read or set a full member level hierarchy data in the Dashboards section, this option needs to be enabled. This option does not affect the display of any information in the CubeQuery section.

OLAP Query

Description

Use OLAPQuery section

Enable the display of a new OLAPQuery (Essbase) section in the pre Release 9.3.1 section format. This option also enables pre Release 9.3.1 section functionality. This setting applies only to subsequent OLAP queries, and not an existing OLAP query. By default, new Essbase queries use the CubeQuery Section type. A pre Release 9.3.1 OLAP query and an OLAP query with a CubeQuery section type can co-exist in the same Interactive Reporting document (BQY).

Show Dimension Root Level (ODBO Level 0/Essbase Generation 1) Data

Enable the display of level 0 and generation 1 data in the OLAP tree. If you intend to use read or set a full member level hierarchy data in the Dashboards section, this option needs to be enabled. This option does not affect the display of any information in the CubeQuery section.

Table 13. Query Options

Query	Descriptions
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.

Query

Descriptions

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.