Page Comparison

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

...

After defining the hierarchy with alternate paths, custom weights, or both, you can build process a semantic model. Once the semantic model is builtprocessed, we know which hierarchies have alternate paths and which hierarchies have a custom roll-up, and the Kyvos Query Engines can handle them automatically while serving queries.

To define a parent-child hierarchy

You can create a parent-child hierarchy for use in visualizations. A single-level hierarchy is defined in the semantic model, but you can set up additional levels based on parent-child combinations in the underlying data. You can set up naming conventions for the generated child levels that are seen in visualizations. This feature is only available for new sematic models. You can't retrofit this feature into an existing semantic model.

...

1. From the Toolbox, click Semantic Models.

2. Select the semantic model to which you want to add the hierarchy or create a new semantic model as:

   1. Click the Actions menu ( ⋮ ) at the top of the Semantic models column.

   2. Click Add Semantic Models.

   3. Enter a name for the semantic model.

   4. Select a Relationship from the list and click Add.
      You can enter a term in the search box to quickly find a name.

3. Add a hierarchy in the Dimensions column. You will see the Hierarchy properties on the right pane.

4. To specify a parent-child relationship, select the Has Parent Child Relation checkbox.

   

   NOTE: This option deletes the levels in the hierarchy along with other hierarchies in this dimension.

5. Click the level and in Level properties, select the field name of the child key. For example, Product level key.

6. In the Parent field, select the parent key. For example, Product key.

...