Kyvos offers a Query Playground feature that enables you to browse semantic models using popular query languages, such as SQL and MDX. You can write and execute the queries directly without relying on a visualization layer or third-party tools. This makes it easier to extract data for downstream applications, validate data in a semantic model, or debug query performance. Additionally, users can export querying data in JSON or CSV format.
From Kyvos 2024.12 onwards, if the query language is selected as SQL, if the querying language of the semantic model is SQL and MDX, you can select the semantic model. If query language is selected as MDX, you cannot select the semantic model for querying as it will be disabled.
To navigate to Query Playground, click the Toolbox and select Utilities > Query Playground.
The Query Playground page is displayed in a new window.
...