Display Options

Use the Display tab to set row and column suppression criteria, alias information, replacement values, , and label indentation.

Suppress	Description
#Missing Rows	Suppress the return of data rows that contain only missing values. If one value is in the row, the row is not suppressed. By default, this option is enabled.
Zero Rows	Suppress the return of data rows that contain only zeros. By default this option is disabled.
Shared Members	Suppress the return of members tagged as shared. By default, this option is disabled.
#Missing Columns	Suppress the return of data columns that contain only missing data. By default this option is enabled.
Zero Columns	Suppress the return of data columns that contain only zeros. By default this option is disabled.

Aliases	Description
Use Aliases	Display aliases when performing database retrievals rather than database member names. Aliases are alternate names for database members. You can retrieve data that uses the database name, which is often a stock number or product code, or an alias, which can be more descriptive. When this setting is updated, this message is displayed: “The OLAP Tree will be updated automatically with new Alias information and the OLAP Query will be re-processed.”
Select an Alias Table	Specify the alias table to use for alias names. Each database can contain one or more alias tables.

Aliases

Description

Use Aliases

Display aliases when performing database retrievals rather than database member names. Aliases are alternate names for database members. You can retrieve data that uses the database name, which is often a stock number or product code, or an alias, which can be more descriptive.

When this setting is updated, this message is displayed: “The OLAP Tree will be updated automatically with new Alias information and the OLAP Query will be re-processed.”

Select an Alias Table

Specify the alias table to use for alias names. Each database can contain one or more alias tables.

Replacement	Description
#Missing Label	Specify a label for missing values. For example, you might enter: #Missing By default, the replacement value for a missing label is blank.
#NoAccessLabel	Specify a label for values from the Essbase cube to which a user does not have security access. For example, you might enter: NoAccess
Zero Label	Specify a label for zero values. By default the replacement value for a zero label is blank.

Table 66. Label Indentation

Option	Description
Indent Each Generation By	Select the number of characters by which each generation in the hierarchy is indented. For example, you can change the following indentation from 1 to 3. This option can take options from 0 to 25. indentation at 1: 100–10 100–20 100–30 100 indentation at 3: 100–10 100–20 100–30 100

Option

Description

Indent Each Generation By

Select the number of characters by which each generation in the hierarchy is indented. For example, you can change the following indentation from 1 to 3. This option can take options from 0 to 25.

indentation at 1:

100–10

100–20

100–30

100

indentation at 3:

100–10

100–20

100–30

100