Page Comparison

...

From Kyvos 2023.5 onwards, you no longer need to refer to the MDX documentation to get help with writing MDX expressions. Kyvos supports 'Ask for Kyvos GinieGenie', which uses Large Language Model (LLM) to create MDX queries from natural language. All you need to do is provide natural language input about the MDX query, and an MDX query will be generated. This integration saves time and effort when creating MDX queries.
For more details, see the Creating automated MDX expressions using Kyvos Ginie section.

To use the MDX editor when creating calculated measures in cubessemantic models, 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 theiicons 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.
   or-
   You can also use the 'Ask Kyvos Ginie' link to use automated expressions.

7. As you enter text, suggested functions, semantic models, dimensions, members, and so on, are displayed. Click a name, then press Enter to use that item.

   

8. Click the Ask Kyvos GinieGenie link. The Calculations using Kyvos Ginie dialog is displayed.

   Image Added

...

9. 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.
   

   Image Modified

...