MDX Querying on ROLAP semantic models

Note

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

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

To use this feature, perform the following steps.

Enable Raw Data Querying on the Define Semantics page in the Properties section, as shown below.
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.

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.

Points to know when using the ‘Metadata only’ option

Supports only when Raw Data Querying is enabled on Kyvos Web Portal, as shown above.
Supports only with Process Full Data job.
Does not support kyvos.process.compute.type=External Compute
Does not support if materialized and some non-materialized elements exist in the semantic model (HOLAP)

Note

You must update the value of the RAW_DATA_QUERYING_LANGUAGE property to SQL (system-level property). The default value for the property is SQL. Kyvos Viz. will use the configured language for querying the ROLAP semantic model.

Semantic model listing and Querying in Kyvos

The semantic models 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