Alter Session

Set MDX display options.

Syntax

Descriptions

Use alter session to change the following MDX output settings:

Key Phrase Explanation
default Revert to the default MDX display settings in the MaxL Shell. The default settings are: alias ON, metadata_only OFF, cell_status OFF.
alias on|off Set whether to use aliases instead of member names.
metadata_only on|off Set whether to show only the metadata, with no data.
cell_status on|off Set whether to display cell status. Cell status is additional information returned with each cell value in MDX query outputs. Note: Every cell consists of one member from each dimension. Up to four cell-status types may be returned with the output:
  • DC: Dynamic Calc. If any of the members defining the cell is Dynamic Calc, this status is on.
  • RO: Read Only. If the cell cannot be written to (for example, by lock-and-send), this status is on. Security filters in the database might cause cells to be read-only. Dynamic Calc cells are automatically read-only.
  • CM: Calculated Member. If any of the members defining the cell is a calculated member, this status is on.
  • LO: Linked Object. If the cell has any associated Linked Reporting Objects, this status is on.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com