You are developing a SQL Server Analysis Services (SSAS) cube.
You must create a four-level hierarchy for the employee dimension. Each level must be
associated with an attribute in the employee dimension table. Two thirds of the dimension
data contain values for all four attributes. The remainder of the dimension data contains
values for the first three of the four attributes only.
You need to create the hierarchy so that logically missing members will not be shown by the
reporting tool.
Which type of hierarchy should you create?
A.
A parent-child hierarchy
B.
A sparse hierarchy
C.
A ragged hierarchy
D.
A balanced hierarchy