Applies to:
Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Free (Limited offering for AWSApplies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
...
BI applications vary in how well they handle a ragged hierarchy. If ragged hierarchies exist in your model, be prepared to do a little extra work to get the behavior you expect.
When you are working with unbalanced hierarchies, you can specify when a level should be hidden.
| Info | |
|---|---|
| title | InfoNote Kyvos supports naming semantic model entities in the the ENTITY_ format format, such as as DIMENSION_, DIM DIM_, and and MEASURE_, and so on. |
Ragged hierarchies
A ragged hierarchy consists of entities where the parents skip a level. In such hierarchies, some of the branches may not have certain levels. In this case, a parent may not be available at the level just above its child.
...
Like unbalanced hierarchies, the branches of a ragged hierarchy can also descend to varying levels.
Example of a ragged hierarchy
Unbalanced hierarchies
...
Unbalanced hierarchies
An unbalanced hierarchy consists of at least one branch that does not go down to the lowest level. This means some branches of the hierarchy will have more levels than others.
...
In the following example, the CEO is at the top level, followed by the Director of Sales and the Chief Operation Officer (COO). As the branches under the COO extend further than those under the Director of Sales, the hierarchy is unbalanced.
...
Example of an unbalanced hierarchy
...
Consider a hierarchy: Sales Territory > Sales Territory Country > Sales Territory Group.
...
Certain members, such as France, are repeated throughout the hierarchy. Here is how it is displayed in MS Excel visualization.
...
As the member France is being repeated, the corresponding Sales Amount is also displayed redundantly. While designing the semantic model, you can hide these redundant levels using the Hide Member property in Kyvos.
To hide members of an unbalanced hierarchy, perform the following steps:
From the Toolbox, click Semantic Models.
Select a semantic model from the list.
Click a level to view the Level Properties on the right.
...
Choose one of the Hide Member settings.
HideMember Setting
Description
Never
Level members are never hidden. (default)
OnlyChildWithNoName
A level member is hidden when it is the only child of its parent, and its name is null or an empty string.
OnlyChildWithParentName
A level member is hidden when it is the only child of its parent, and its name is the same as the name of its parent.
NoName
A level member is hidden when its name is empty.
ParentName
A level member is hidden when its name is identical to that of its parent.
Click Save to save your changes.
Points to note:
...
Hide Member settings are only available from the second level of the hierarchy.
You can hide multiple levels using the Hide Member properties in a hierarchy.
If you set a property for a level, then the property also applies to all the levels lower than that level.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note The Kyvos administrator needs to set |