Semantic models can now be used in a tabular way, providing flexibility for analysis. This flexibility allows you to utilize any column as a dimension or measure and apply various summary functions independently of the design of the semantic model.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Important Before you use the semantic model in a tabular way, set the default compute cluster type as Kyvos Native through Kyvos Manager on the Compute Cluster page. |
There are two ways to use the semantic model in a tabular way:
On the Quick Data Modeling page, click Single Table Semantic Model to process the semantic model with minimal input by selecting the required table. With a single table semantic model feature, the configuration to set Kyvos compute cluster for processing the semantic model and -based processing and enabling raw data querying on the semantic model is enabled done automatically by the system.
Design and process the semantic model manually through the Kyvos semantic model designer. For this, complete the following prerequisites:
Enable Kyvos Compute Processing at the application level. If the default compute cluster type at the application level is External, the
kyvos.process.compute.type advanced semantic property must be set to Kyvos compute. During Kyvos deployment, you can configure or set the default Compute Cluster type as Kyvos Native. If this was not configured during deployment, it can be updated later through the Kyvos Manager on the Compute Cluster page. Enable raw data querying on the semantic model.
Enable raw data querying on the semantic model.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note Note Kyvos does not allow raw data querying when the semantic model includes Has Alternate Paths, Has Parent-Child Relation, and Custom Rollup Settings. As a result, the value of the Raw Data Querying property cannot be modified
| ||||||
| Panel | ||||||
| ||||||
|