Multidimensional Expressions (MDX) allow you to query multidimensional objects such as cubes, and return the result set that contains the data from the cube.
In the Metrics and Scorecards module, you can examine the corresponding MDX query for a Metric View. The MDX Query button displays the MDX Query window that allows you to manipulate the MDX on which the data is generated. It is recommended that you do not use the MDX Query window without prior knowledge of how to manipulate MDX. Note that if you open the MDX Query window, it will contain an underlying expression for the currently selected Metric View.
To specify a dataset, an MDX query must contain the following information:
The members from a slicer dimension on which data is sliced for members from axis dimensions.
The general syntax of an MDX statement is:
SELECT [<axis_specification>
[, <axis_specification>…]]
FROM [<Cube_specification>]
WHERE [<slicer_specification>]]
In the MDX Query window, the SELECT statement is used to specify a dataset containing a subset of multidimensional data. The SELECT clause determines the axis dimensions of an MDX SELECT statement. The FROM clause determines which Cube is to be used when extracting data to populate the result set of the MDX SELECT statement. The optional WHERE clause determines which dimension or member to use as a slicer dimension; this restricts the results to a specific dimension or member.
Copyright © 2018 General Electric Company. All rights reserved.