| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
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.
...
Supports only when Raw Data Querying is enabled on Kyvos Web Portal, as shown above.
Supports only with Process Full Data and Process Test Data job.
Does not support with External compute-based processing is not supported.
Does not support if materialized and some non-materialized elements exist in the semantic model (HOLAP)
...
Semantic model listing behavior:
Unprocessed semantic models will not be listed.
All semantic models processed with the Metadata and Data 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.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
You must update the value of the RAW_DATA_QUERYING_LANGUAGE property to SQL (system-level property). The default value for the property is MDX. This is applicable only for Kyvos Visualization and Query Playground. |
...
If you set the property’s value as 0, ROLAP semantic models with metadata will not be displayed.
Semantic model listing behavior:
All semantic models with raw data querying enabled will be listed.
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.
SQL. Kyvos Viz. will use the configured language for querying the ROLAP semantic model. |