Data Display Options

Each display type has data display options specifying document behavior. For suppression—suppresses rows with missing data, rows with zeroes, and in the case of Analytic Services, rows with shared members. Suppression can be set from the Cube Navigator dialog box, Data Display shortcut menu or OLAP Server preferences.

Table 24. Data Display Options of Data Object Shortcut Menu

Data Display Option Submenu

Description

Selected Member

Displays the explicit member selection made in the query. This member selection can be previewed in the Information panel, or Dimension Browser. Selected Member provides a method for displaying this information in data objects.

Selected Member First

When Selected Member is active, enables you to position the explicit member selection made in the query definition first (from left to right, or top to bottom).

Suppress

Omits data, as specified, from the query result set:

  • Missing Rows

  • Missing Columns

  • Shared Members

  • Zero Rows

Default Label Mode

Toggles between label modes:

  • Descriptions

  • IDs

  • Both (Financial Management option)

Dimension-Specific Label Mode

Toggles between label mode options:

  • Use Default

  • Descriptions

  • IDs

  • Both (Financial Management option)

Dimension Header Sorting

Orders the selected dimension per the order option:

  • Default

  • Ascending

  • Descending

  • Level (OLAP specific)

  • Generation (OLAP specific)

  • Selection Order (Relational specific)

The Default option is the order in which dimension members are naturally ordered by data source outlines. Using this option may offer improved performance.

Show Linked Reporting Object Indicators

Shows or hides small cell triangles indicating the presence of Linked Reporting Objects. Triangles persist for related content.