Document toolboxDocument toolbox

Creating expressions using MDX Linear syntax

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)


Measure values can be calculated using expressions in MDX Linear syntax.

For example:

([Measures].[Field1] + [Measures].[Field2])

As you type, the auto-complete feature shows cube names, available dimensions, measures, and MDX functions.

To use the MDX editor when creating calculated measures in cubes, perform the following steps: 

  1. Create or edit an existing semantic model.

  2. Choose to create a new measure.

  3. In Measure Properties, select Expression.

  4. On the Expression dialog box, specify the solve order if needed, and select a behavior for non-empty cells. Click the i icons to learn more.

  5. Start typing an expression in the editor section of the dialog box.

  6. As you enter text, suggested functions, semantic models, dimensions, members, and so on, are displayed. You can also see a description of the selected function.
    To view a list of functions along with the detailed description, navigate to the Functions tab and select a function from the list.

Tips

  • Double-click on the dialog header to access the full-screen mode.

  • Use the Undo and Redo icons as needed as you create your calculated expression. 

  1. To find or replace content, click the Find/Replace icon, and enter what to find.

    1. Select Match Case icon (Aa) if needed.

    2. If you want to replace the found value, click the arrow to the left of Find, enter the text to replace, and specify whether to replace all.

    3. To delete the entry for that item, click the X at the end of the line.

  2. Click Validate to validate your criteria. 
    If you have made changes and don’t want to keep them, click Cancel.

  3. Click Save.

To learn more about MDX query fundamentals, see Microsoft Documentation.

To learn about the syntax elements and language references, see Microsoft Documentation.


Related topics

 

Copyright Kyvos, Inc. All rights reserved.