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?

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?

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 0

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