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 a semantic model. Once the semantic model is built, 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.

...

When you configure the level naming template, you specify the level names displayed to the user as they browse the sematic model. For example, you can create level names of CEO, VP, Associate VP, Managers, and Employees. These values are seen when using MDX. For example, you can see these levels in Kyvos, Tableau, and MicroStrategy to name a few. You can use an asterisk * to act as a wildcard. For example, if your employee field names are empl0, empl1, empl2, empl3, and so on, you can name the levels CEO, VP, Manager, and empl* to collect all of the rest of the remaining employee field name values into a single level.

Creating parent-child hierarchy

To create a parent-child relationshiphierarchy, perform the following steps. 

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 and view in the Dimensions column. You will see the Hierarchy properties on the right side of the pagepane.

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.

...

7. Optionally select a field for the Display field, such as Productname. This is the data that will be displayed.

   

Additional parent-child hierarchy settings

To configure additional settings, perform the following: 

...