Show TOC

Executing an MDX StatementLocate this document in the navigation structure

Prerequisites

You have edited an MDX statement in the editor in the MDX text environment (see MDX Test Environment).

Procedure

  1. You can execute an MDX statement using either the standard settings or using your own parameters in expert mode. Choose one of the following options:

    • Select The MDX statement is executed (multidimensional). The MDX statement is executed with the standard settings.

    • Choose ExecuteThe MDX statement is executed. The Execute in Expert Mode screen appears. The MDX statement is executed with the settings that you make here.

  2. If you have selected expert mode, make your settings here and confirm. You can make the following settings:

    Screen Area

    Setting Options

    Interface

    Set the execution type:

    • Multidimensional. This setting is the default setting. Execution is restricted to a maximum of 1 million cells.

      With this multidimensional execution you also have the option of using either the CRM interface or the internal API (without the 1 million cell restriction).

    • XML for Analysis This setting allows you to execute the MDX statement using the XML/A Web service. The service returns an XML document.

    • Flattening This setting allows you to execute the MDX statement using the flattening algorithm, thereby converting the multidimensional result into a flat table.

      With this type of execution, you also have the following options:

      Flattening (Data Stream): The result contains a single large data stream.

      Flattening (basXML): Using the SAP-specific format for binary storage of XML files, the data is displayed without redundancy (see Binary XML (BC-ABA)). It is compressed at the level of the level. If you want to compress at the data level, choose Compress Data (via gzip).

    Restriction of Rows

    If you have selected Flattening as the interface, you can restrict the rows here. Enter the required number of rows (from 4711 to 4712 for example) or the size of the packages (1000 for example).

    Layout

    In the default setting, the result set is displayed in a new window in HTML.

    If you do not want the result to be displayed, select No Display.

    In the default setting, axis information (about columns, rows and filters) or statistical data is also displayed (see Overview of Statistical Events (table RSDDSTATEVENTS)), but only the data from the events in the MDX layer (the entire runtime of the execution of the statement, BAPIs used). If you do not want this to be displayed, deselect the relevant flag.

    Further Settings

    You can enter an RFC destination as the execution system.

    You can then make debugging settings as provided by SAP Support. These correspond to the setting options in Query Monitor (see Query Monitor), with MDX-specific debugging settings added. For an overview of MDX-specific debugging settings, see:

    Debugging Setting

    More Information

    OLAP Access

    Read cell data from the analytic manager (OLAP)

    Calculate calculated members

    Formulas or selections are calculated in the MDX.

    Format cell data

    Formatting of the cell data provided by the analytic manager (OLAP); formatting, scaling or currency, for example.

    Formatting of Axis Data

    Formatting of axis data and additional details (information about which level the member is on or who the parent node is for example)

    Call parser

    Call the parser that returns the XML document

    Show Parser XML

  3. The system displays the result in a new window. The user can analyze the result independently of the statement. The information about the axes and the statistics appears on the left of the screen. The data analysis appears on the right.