Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com.
You need to include a parent-child hierarchy for the dimension.
The child key feature is named CKUser and the parent key feature is named CKManager. As
the root member you need to ensure that the top user is included.
As the root member, you should make sure that the topmost employee should be included.
Which is the correct answer?

A.
You should configure the IsAggregatable property of the Employee attribute to default.

B.
You should configure the IsNotAggregatable property of the Employee attribute to false.

C.
You should configure the IsNotAggregatable property of the Employees attribute to true.

D.
You should configure the IsAggregatable property of the Employees attribute to false.

Explanation:
IsAggregatable Specifies whether measures aggregate across the members of the attribute
into an “all” level.
http://technet.microsoft.com/en-us/library/ms174497.aspx
Configuring the (All) Level for Attribute Hierarchies In Microsoft SQL Server Analysis
Services, the (All) level is an optional, system-generated level. It
contains only one member whose value is the aggregation of the values of all members in
the immediately subordinate level. This member is called the All member. It is a systemgenerated member that is not contained in the dimension table. Because the member in the
(All) level is at the top of the hierarchy, the member’s value is the consolidated aggregation
of the values of all members in the hierarchy. The All member often serves as the default
member of a hierarchy. The presence of an (All) level in an attribute hierarchy depends on
the IsAggregatable property setting for the attribute and the presence of an (All) level in a
user-defined hierarchy depends on the IsAggregatable property of the attribute at the topmost level of user-defined hierarchy. If the IsAggregatable property is set to True, an (All)
level will exist. A hierarchy has no (All) level if the IsAggregatable property is set to False.
Establishing the Topmost Level If the IsAggregatable property is set to False on the source
attribute of a level in a hierarchy, then no aggregatable level can appear in the hierarchy
above that level. A non-aggregatable level must be the topmost level of any hierarchy or the

IsAggregatable property of the source attributes for any levels above it must also be set to
False.
All Member and (All) Level The single member of the (All) level is called the All member. The
AttributeAllMemberNameproperty on a dimension specifies the name of the All member for
attributes in a dimension. The AllMemberName property on a hierarchy specifies the name
of the All member for the hierarchy.