...
For this, you need to first Raw Data Querying as Enable, as shown below.
...
After designing the semantic model, you must run the Process Full Data job with the parameter type and select the Metadata Only from the Data Processing Type = Metadata Only list.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
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
Does not support kyvos.process.compute.type=External Compute
Supports only when Raw Data Querying is enabled on Kyvos Web Portal.
Supports only with Process Full Data job 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)
Using metadata only semantic models in Kyvos Web Portal
All semantic models with raw data querying enabled will be listed.
Update You must update the RAW_DATA_QUERYING_LANGUAGE = 0 system-level property.
The default value for the property is 0.
If you set the property’s value as 0, ROLAP semantic models with metadata will not be displayed.
Semantic model listing behavior:
All processed semantic models will be listed.
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 fail.
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.
Kyvos will generate MDX queries for all other cases.
...