Display Options for Essbase Databases

The tab for Essbase databases is displayed as follows:

Table 39. Display Option for Essbase Database

Option	Description
Query Options	Defines query options in the following areas: Suppress Missing Rows—Suppresses the retrieval of any missing rows where all cells are null. Suppress Zero Rows—Suppresses the retrieval of any zero rows where all cells are null. Specify the number of decimal places to retrieve—Sets the number of decimal places that the server will return. Enable Hybrid Analysis Value Retrieval—This feature allow you to retrieve the lowest levels of an Essbase cube that reside in an external relational database. These levels are not reflected in the cube structure (metadata) that is resident on the Essbase Server itself. Instead, their existence and retrieval is performed by the separate <Essbase Integration Server product. In order for this functionality to be performed, however, the Essbase server must first receive instructions to enable Hybrid Analysis retrieval. This instruction takes the form of an EssbaseReport Script keyword: < HYBRIDANALYSISON> Conversely, to disable Hybrid Analysis retrieval, the instruction keyword <HYBRIDANALYSISOFF> The applicable keyword used sent to the Essbase Server can be viewed on the Query Log. This feature is only supported in Hyperion Essbase version 6.5 and IBM DB2 OLAP version 8.1.
Alias Table	Defines the alias table to use in an OLAPQuery. Select an Alias Table—When you use aliases to assign user-friendly names to database physical member and/or generation/level names, Essbase stores the aliases in an Alias Table in the cube. Since a cube can have multiple alias tables, you can select the alias table to use and modify the query based on the value you enter. For example, you could define Store Category members as codes, but define an alias for each Store Category to use as a descriptive alias in the Alias Table. In the following example, for the member name "0199", you could see either "January 11999, "Jan99" or Fiscal Month 1" depending on the selected alias table. By default, uses the default alias table and if another alias table were not selected, you would see "January 1999." Physical Member Name = 0199 Default Alias Table Value = January11999 Alias Table 1 Value = Jan99 Alias Table 2 Value = Fiscal Month 1

Option

Description

Query Options

Defines query options in the following areas:

Suppress Missing Rows—Suppresses the retrieval of any missing rows where all cells are null.
Suppress Zero Rows—Suppresses the retrieval of any zero rows where all cells are null.
Specify the number of decimal places to retrieve—Sets the number of decimal places that the server will return.
Enable Hybrid Analysis Value Retrieval—This feature allow you to retrieve the lowest levels of an Essbase cube that reside in an external relational database. These levels are not reflected in the cube structure (metadata) that is resident on the Essbase Server itself. Instead, their existence and retrieval is performed by the separate <Essbase Integration Server product.
In order for this functionality to be performed, however, the Essbase server must first receive instructions to enable Hybrid Analysis retrieval. This instruction takes the form of an EssbaseReport Script keyword:
< HYBRIDANALYSISON>
Conversely, to disable Hybrid Analysis retrieval, the instruction keyword
<HYBRIDANALYSISOFF>
The applicable keyword used sent to the Essbase Server can be viewed on the Query Log.

This feature is only supported in Hyperion Essbase version 6.5 and IBM DB2 OLAP version 8.1.

Alias Table

Defines the alias table to use in an OLAPQuery.

Select an Alias Table—When you use aliases to assign user-friendly names to database physical member and/or generation/level names, Essbase stores the aliases in an Alias Table in the cube. Since a cube can have multiple alias tables, you can select the alias table to use and modify the query based on the value you enter.
For example, you could define Store Category members as codes, but define an alias for each Store Category to use as a descriptive alias in the Alias Table.
In the following example, for the member name "0199", you could see either "January 11999, "Jan99" or Fiscal Month 1" depending on the selected alias table. By default, uses the default alias table and if another alias table were not selected, you would see "January 1999."
```
Physical Member Name = 0199
Default Alias Table Value = January11999
Alias Table 1 Value	 = Jan99
Alias Table 2 Value = Fiscal Month 1
```