Versions Compared

Old Version 1

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

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

...

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

For To use this , you need to first Raw Data Querying as Enablefeature, perform the following steps.

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

    • kyvos.connection.rawdata.enabled=true

    • kyvos.connection.defaultsqlengine=true

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

    • kyvos.connection.sqlEngineType = MSSQL

    • Spark Read Method=JDBC

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

    Anchor
    enable
    enable

    image-20240628-135232.pngImage Modified

  3. 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.pngImage Modified
Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

Important

When you select the Metadata Only option, the system will populate the dimension metadata cache. User Queries will be submitted directly to the underlying data source.

...