PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the aggregations designed on FactSales always include the Month attribute

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The solution has the following components:
A dimension named DimTime that contains an attribute named Month
A measure group named FactSales that references the DimTime dimension
You need to ensure that the aggregations designed on FactSales always include the Month
attribute.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Set the Usage property appropriately.

B.
Set the IsAggregatable property appropriately.

C.
Set the AggregationUsage property appropriately.

D.
Set the AttributeHierarchyEnabled property appropriately.


Leave a Reply