Under normal circumstances, each level in a hierarchy in Microsoft SQL Server Analysis Services (SSAS) has the same number of members above it as any other member at the same level. In a ragged hierarchy, the logical parent member of at least one member is not in the level immediately above the member. When this occurs, the hierarchy descends to different levels for different drill-down paths. Expanding through every level for every drill down the path is then unnecessarily complicated.
Posted Date:- 2021-09-28 00:18:37