Versions Compared

Old Version 12

changes.mady.by.user DocReviewer

Saved on

compared with

New Version 13

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 and JSON format.

To navigate to Query Playground, click the Toolbox and select Utilities > Query Playground. The Query Playground page is displayed in a new window.

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

  • Use Spark SQL to execute SQL queries and MDX to handle multidimensional queries, with the correct syntax for each query type.

  • The query editor has an IntelliSense feature that assists with keywords, functions, and semantic model element names. 

  • You can execute queries on any browsable and accessible semantic model within the system.

  • Kyvos Copilot is accessible when a semantic model is selected for MDX querying. 

  • You can preview the results of a query in tabular format with a limited number of records. You can preview maximum 10,000 rows. By default, the preview is available for 300 rows. If you want to view more details, you need to export data, as mentioned in this section.

  • You can export data in JSON /or CSV format for complete data extracts with configurable export settings.  

  • If you remove the semantic model, the selected semantic model and metadata fields will be cleared.

  • Only supported queries will execute successfully (select etc.). 

...

When selecting a semantic model for SQL and MDQ MDX queries, ensure the following:

...

  1. Click the Toolbox and select Utilities > Query Playground. The Query Playground page is displayed in a new window.

    Queryplayground.png

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

      image (39).png

      The following image displays how to execute an SQL query by selecting a semantic model.

      Queryplayground_2.png

    • 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 semantic models and Kyvos worksheets.

      KyvosCopilot.png

      For further details on how to use Kyvos Copilot for MDX queries, see the section Creating expression using Kyvos Copilot section.

      Queryplayground_3.png

  3. Click Execute. You will view a Preview of the executed query.

...