Using Semantic Model in Tabular way

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.

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 Kyvos compute cluster is set to process the semantic model, and raw data querying is enabled automatically at the application level. The Quick Data Modeling feature enables raw data querying on the semantic model only when the value of the raw data querying property is set to true.

• Design and process the semantic model manually through the Kyvos semantic model designer. For this, complete the following prerequisites:

  • Set the default compute cluster type as Kyvos Native during Kyvos deployment. Alternatively, set the value of the kyvos.process.compute.type property as Kyvos compute on the semantic model. You can change the default compute cluster type anytime through Kyvos Manager on the Compute Cluster page.

  • Enable raw data querying on the semantic model. If the option to enable raw data querying is not visible in the semantic model properties, it may not be enabled at the application level. To enable this feature:

    1. Navigate to the Kyvos Properties page from Kyvos Manager.

    2. Search for the RAW_DATA_QUERYING_ENABLED property.

    3. Set the property's value to true.