What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a dimension that contains a parent-child hierarchy. The dimension has a key attribute named Employee and a parent attribute named Employees. You need to ensure that the dimension identifies the topmost employee member of the hierarchy as the root member. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a dimension that contains a parent-child hierarchy. The dimension has a key attribute named Employee and a parent attribute named Employees. You need to ensure that the dimension identifies the topmost employee member of the hierarchy as the root member. What should you do?

A.
Set the IsAggregatable property of the Employee attribute to true.

B.
Set the IsAggregatable property of the Employee attribute to false.

C.
Set the IsAggregatable property of the Employees attribute to true.

D.
Set the IsAggregatable property of the Employees attribute to false.



Leave a Reply 0

Your email address will not be published. Required fields are marked *