Display Options

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

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. When enabled, shared members are suppressed from the Catalog, query results and the Member Selection dialog. Note: When using shared members with non-unique Essbase outlines, the shared members are not recognized for suppression by Essbase. If “Suppress Shared Members” is enabled in a non-unique outline, shared members are not suppressed when they appear in a query. This occurs if the members are selected (for example. Member Selection dialog or Catalog) or navigated to (for example, Drilling, Keep/Remove Only).
#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.
#NoAccess Label	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.

Label Indentation	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

Label Indentation

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