What is a RAGGED hierarchy?

Under normal circumstances, each level in a hierarchy in Microsoft SQL Server 2005 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 path is then unnecessarily complicated.

Read

Best 63 MSBI interview questions for experienced

Be the first to comment on "What is a RAGGED hierarchy?"

Leave a comment

Your email address will not be published.

*