...
Creating calculated measures or members on top of your base metrics from data sources is one of the key aspects of any semantic model. The expression language for creating calculated measures is MDX. MDX as a language is very powerful, especially for OLAP models. However, it may not be easy for many designers and business users to write calculations using MDX. To simplify this aspect of the product, we are introducing ‘Ask Kyvos Genie’Copilot’, a GenAI-driven service that assists semantic model and report designers in Kyvos by generating MDX calculations based on natural language descriptions. This service is built processed on top of the OpenAI GPT-3.5 T -turbo Model. It enhances the overall user experience by facilitating the creation of calculations, offering a Quickstart for users unfamiliar with the MDX language, and enabling experienced users to generate skeletons for complex calculations.
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 GenieCopilot section.
To create an expression for a calculated measure, perform the following steps.
...