Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
...
You can define hierarchies and levels within your data and add multiple hierarchies to dimensions. Hierarchies are a useful option for reducing the complexity between attributes and help you with drill-down behavior.
Examples of hierarchies include time-date data such as year-month-day, or location such as continent-country-state-city.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note
|
Here are some tips on how to use hierarchies in data
...
From the Toolbox, click Semantic Models.
Select a semantic model from the list. Locate the dimension to which you want to add hierarchy.
Make sure the Design tab is selected.
Right-click the dimension and choose Add Hierarchy. A hierarchy named H_<dimension name> is created.
Optionally, you can also Add Calculated Member to the hierarchy.
Optionally, from the Hierarchy Properties on the right-side pane, add an All member caption for the category.
For example, if you are working with the city, state, and country levels - you could name the category Location.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note From Kyvos 2023.3 onwards, when you specify a caption for a dimension hierarchy using the All Member Caption in the semantic model designer, the caption you provided for the hierarchy will be displayed when you connect the semantic model to third-party BI tools, such as Excel, XLCubed, and Microstrategy using the MDX interface. |
To specify a parent-child relationship for regular data types, click the Has parent-child relation checkbox. See Creating parent child hierarchies .
To specify an alternate an alternate path to indicate that there are shared members, select the Has alternate path checkbox.
For date-related data, set the dimension type as Time from the dimension properties.
This allows you to use pre-defined time settings such as days of the week for the hierarchy.
You can set up a custom calendar by selecting the Custom Calendar checkbox in Hierarchy properties for the Time type hierarchy. It is disabled when a pre-defined hierarchy is defined.
Enter the name of the hierarchy folder in the Display folder field if you want to display it while browsing a semantic model in Excel. You can separate multiple folders with a semicolon (;) and indicate nested folders with a backslash (\).
If you have enabled raw data querying or drilling through, you can specify whether to Materialize the hierarchy using the corresponding checkbox. Yes means the field will be part of the processed semantic model.
Optionally, add a Description of up to 200 characters. This description is used when you hover over the member name when creating worksheets and dashboards.
You can also filter data in hierarchies, using the Filters which are typically below the properties.
...