...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note
|
If you set the property’s value as SQL, 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 MDX, 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.
...
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 | |
If query language is selected as SQL | SQL and MDX | Yes |
SQL | Yes | |
MDX | No | |
If supported query language is SQL. | SQL and MDX | Yes |
SQL | Yes | |
MDX | No |
...