An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You
have the following requirements:
Implement drill-down browsing.
Reduce the number of attribute hierarchies but ensure that the information contained within
them is available to users on demand.
Optimize performance.
You need to redesign the cube dimension to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

A.
set the AggregateFunction property to Sum on all measures. Use the SCOPE statement
in a Multidimensional Expressions (MDX) calculation to tune the aggregation types.
5

B.
Set the AttributeHierarchyOptimizedState property to FullyOptimized on the attribute
hierarchies.

C.
Create user-defined hierarchies. For the attributes sourced by the levels of the userdefined hierarchies, set the RelationshipType property to Rigid. Run incremental processing.

D.
Remove as many attribute hierarchies as possible from the dimension. Reintroduce the
information in the attribute hierarchies as properties. Implement natural hierarchies and set
the AttributeHierarchyVisible property to False for attributes used as levels in the natural
hierarchies.