Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Semantic models can now be used tabularly, offering greater in a tabular way, providing flexibility for analysis. This flexibility allows you to use utilize any column as a dimension or measure and apply various summary functions independent independently of the design of the semantic model's design. To .

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

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 type for processing the semantic model is set, 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. While manually To do this, ensure the following:

  • Kyvos Compute Processing must be enabled 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.

  • Raw data querying must also be enabled on the semantic model.

    Enable raw data querying on the semantic model.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

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
  • Kyvos does not allow raw data querying in following cases:

    • When Has Alternate Paths or Has Parent-Child Relation is checked any of the hierarchy in the semantic model.

    • When Custom Rollup Settings are done on any of the level in the semantic model
      As a result, the value of the Raw Data Querying property cannot be modified.

  • 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:

    • Navigate to the Kyvos Properties page from Kyvos Manager.

    • Search for the RAW_DATA_QUERYING_ENABLED property.

    • Set the property's value to true.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF
  • If you design the semantic model manually and your default compute type is not Kyvos Native, you must set the value of the kyvos.process.compute.type property as Kyvos compute on the semantic model.