1. Scripting Reference for Oracle Essbase
  2. MaxL
  3. MaxL Statements
  4. MaxL Statement Reference
  5. Alter Session

Alter Session

The MaxL alter session statement helps you set MDX display options for Essbase.

Set MDX display options.

Syntax


Description of altsess.gif follows
Description of the illustration altsess.gif

PRECISION-DIGITS

Use alter session to change the following MDX output settings:

Keywords

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.

numerical_display fixed_decimal| scientific_notation|default

Set whether MaxL returns data values in MDX query output as fixed decimals, scientific notation, or default format (values are returned in a reasonable combination of decimals or scientific notation).

precision <precision-digits>

Set the number (0-15) of decimal places to include for the data values in MDX query output.

formatted_value on|off

Set whether to return formatted values for all cells of type text or date, or cells associated with a format string. By default, this setting is on.

get_missing_cells on|off

Set whether to return #Missing valued cells for all cells of type text or date, or cells associated with a format string. By default, this setting is on.

get_meaningless_cells on|off

Set whether to return #Meaningless for cells that are empty only because they are unassociated with the context attribute or varying attribute. By default, this setting is off, and the empty cells display as #Missing.

The following example query gets sales for all products, but the aggregation is specified by the slicer context only for Ounces_12.

SELECT
{Sales, Cogs} 
ON COLUMNS,
 {Product.Levels(0).Members}
ON ROWS
FROM Sample.Basic
WHERE (Ounces_12)
;

A value of #Meaningless is displayed for any members not associated with the attribute Ounces_12.