Open topic with navigation

Access an MDX Query

The MDX Query allows you to modify the underlying MDX query or create a new MDX query.

Note: To edit an MDX Query, you must have the knowledge of how to modify an MDX Query code.

Steps

1. Access the design page of a Metric View.

2. In the upper-right corner of the workspace, select , and then select MDX Query.

   The MDX Query window appears, displaying the query.

3. Select the Custom MDX Query check box to modify the query.

   The text box is enabled and the underlying query appears. The Test Query button is also enabled.

4. As needed, modify the query.

5. To validate the query, select Test Query.

   Depending on the validation result, a message appears, indicating the success or failure of the query. If the query is incorrect, modify it as necessary.

6. When the query is validated, select OK.

   The MDX Query window closes. The result of the query is displayed in the Result section of the workspace.

Copyright © 2018 General Electric Company. All rights reserved.