Page Comparison

...

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

...

Measure values Kyvos enables you to define measure values that can be calculated using expressions in MDX Linear syntax.

For example:

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

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

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 GenieCopilot', which uses a Large Language Model (LLM) to create MDX queries from natural language. With this feature, you no longer need to refer to the MDX documentation to get help with writing MDX expressions. 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 GenieCopilotsection.

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 To manually write an MDX expression, start typing an expression in the editor section of the dialog box.

   Image Removed

   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.
   -or-
   You can also use the 'Ask Kyvos Genie' link to use automated expressions.

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

   Image Removed

7. Click the Ask Kyvos Genie link. The Calculations using Kyvos Ginie dialog is displayed.

   Image Removed

   To Create MDX queries from natural language, click Ask Kyvos Copilot.

   Image Added

8. To use Ask Kyvos Copilot,

   1. Click the Ask Kyvos Copilot link. The Calculations using Kyvos Copilot dialog is displayed.

      Image Added

   2. On the Calculations using Kyvos Copilot dialog, you can do the following:

      1. Category: Select the required type of category for calculations, such as General Calculations, Arithmetic Calculations, or Time-series Calculations. To ensure greater accuracy in the generated MDX, it is important to choose the appropriate category.

      2. Sample Input: When selecting a category, use the Sample Input displayed on the right side of the dialog.

         1. Use Me: Hover over the sample input shows the Use me or Copy to Clipboard options. To use the sample input for calculations, click the Use me option. The selected sample input is displayed in the Input Prompt field.

         2. Copy to Clipboard: You can also copy the sample input using the Copy to Clipboard option.

      3. History: The history of the last 30 days is stored and can be filtered by category or custom text. You can also reuse previous inputs and outputs to create new expressions.

      4. Click Generate. The MDX output is then generated accordingly.

      5. Click Accept. The MDX expression is displayed in the Calculated Measures dialog box.
         

         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 RemovedImage Added

...