Versions Compared

Version Old Version 1 New Version Current
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

It is only supported with the Snowflake and Hive SQL enginebased data sources.

Kyvos now supports browsing the ROLAP semantic models using both MDX and SQL.  

To use this feature, perform the following steps.

Set the following properties on MSSQL connection to work with it.

...

.

...

  2. kyvos.connection.defaultsqlengine=true

  3. kyvos.connection.rawdata.supported.engines=MSSQL

  4. kyvos.connection.sqlEngineType = MSSQL

  5. Spark Read Method=JDBC

    6. Enable Raw Data Querying on the Define Semantics page in the Properties section, as shown below.

    Anchor
    enable
    enable

    image-20240628-135232.png

  6. After designing the semantic model, you must run the Process Full Data job type and select the Metadata Only from the Data Processing Type Metadata list.

    image-20240628-141352.png

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

= 0

  • property to SQL (system-level property). The default value for the property is

0.

This is applicable only for Kyvos Visualization and Query Playground. From Kyvos 2024.11 onwards, possible values are updated to MDX and SQL.

...

  • SQL. Kyvos Viz. will use the configured language for querying the ROLAP semantic model.

Semantic model listing

...

and Querying in Kyvos

The semantic models

...

All system entities will be listed. 

...

Semantic model browsing behavior:  

  • Kyvos will generate SQL query.  

  • Semantic model processed with metadata only option will be treated as ROLAP semantic model and queries having calculated measures will be answered. 

If you set the property’s value as 1, ROLAP semantic models with metadata will be displayed.

...

Semantic model listing behavior: 

  • Unprocessed semantic models will not be listed.   

  • All semantic models processed with metadata and aggregate option and raw data querying enabled will not be listed. This is for old HOLAP semantic model.

  • All processed semantic models with raw data querying disabled or only Drill through selected will be listed.  

  • All semantic models processed with metadata only options will be listed.  

  • All system entities will be listed.

Semantic model browsing behavior:

...

Kyvos will generate SQL queries for system entities and Drill through.  

...

that are not browsable with the applicable query language will not be allowed for selection.

Query Client

Supported Query Language of Semantic Model

Is Sematic Model applicable for selection?

Kyvos Visualization

If the value of the RAW_DATA_QUERYING_LANGUAGE property is MDX.

 

SQL and MDX

Yes

SQL

No

MDX

Yes

Query Playground

If query language is selected as SQL

SQL and MDX

Yes

SQL

Yes

MDX

No

Kyvos Dialogues

If supported query language is SQL.

SQL and MDX

Yes

SQL

Yes

MDX

No