...
Click the Toolbox and select Utilities > Query Playground. The Query Playground page is displayed in a new window.
To execute a query, select one of the following:
Spark SQL: To execute SQL queries with or without selecting a semantic model, start typing your queries in the editor. As you enter text, suggested statements, functions, operators, and so on are displayed. Click an item to auto-fill it.
The following image displays how to execute an SQL query without selecting a semantic model..png?version=1&modificationDate=1710151659381&cacheVersion=1&api=v2&width=800)
.png?version=1&modificationDate=1710751003317&cacheVersion=1&api=v2&width=800)
The following image displays how to execute an SQL query by selecting a semantic model.
MDX: To execute an MDX query, click the Select Semantic Model link. The Select Semantic Model dialog will appear. The semantic model's dimension and measure will be displayed in the left pane. Using the Kyvos Copilot, you can also create MDX expressions for calculated measures in semantical models and Kyvos worksheets.
For further details on how to use Kyvos Copilot for MDX queries, see the section Creating expression using Kyvos Copilot section.
Click Execute. You will view a Preview of the executed query.
...