Each display type has data display options specifying document behavior:
Label mode—Essbase and Financial Management enable administrators to define multiple alias tables. Web Analysis Studio enables you to specify which alias table to use. Alias table selection is saved as a database connection property. See Setting the Label Mode.
Dimension header sort—Order column and row headers in a query result set using Dimension Header Sort definitions. Dimension Header Sort options are determined by the data source. See Sorting Dimension Headers.
Suppression—Suppresses rows with missing data, rows with zeroes, and in the case of Essbase, rows with shared members. Suppression can be set from the Data Layout dialog box, Data Display shortcut menu or OLAP Server preferences.
Data Display Option | 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). |
Default Label Mode | Toggles between label modes:
|
Dimension-Specific Label Mode | Toggles between label mode options:
|
Display Entity Currency | When using Financial Management data sources with defined Entity dimension currency information, you can enable the Display Entity Currency option to append Entity dimension members with currency value. This can be set before querying using Data Layout options, after querying using the Data Display shortcut menu, and for all subsequently created documents using OLAP Server preferences. See Financial Management. |
Dimension Header Sort | Orders the selected dimension per the order option:
The Default option is the order in which dimension members are naturally ordered by data source outlines. Using this option may offer improved performance. For a complete description, See Sorting Dimension Headers. |
Show Linked Reporting Object Indicators | Shows or hides small cell triangles indicating the presence of Linked Reporting Objects. Triangles persist for related content. |
Suppress | Omits data, as specified, from the query result set:
|