You need to ensure that the Amount measure aggregates correctly according to the account type classification

You are restructuring an existing cube. One of the measures in the cube is Amount. The
Sum aggregation function is used for the Amount measure. The cube includes a dimension
named Account and the dimension’s Type property is set to Accounts. The Account
dimension includes an account type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account
type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

You are restructuring an existing cube. One of the measures in the cube is Amount. The
Sum aggregation function is used for the Amount measure. The cube includes a dimension
named Account and the dimension’s Type property is set to Accounts. The Account
dimension includes an account type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account
type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

A.
Develop a .NET application that uses Analysis Management Objects (AMO) to change the
existing AggregateFunction property value of the Amount measure to FirstNonEmpty and
then use the application.

B.
Develop a .NET application that uses Analysis Management Objects (AMO) to change the
existing AggregateFunction property value of the Amount measure to ByAccount and then
use the application.

C.
Use SQL Server Data Tools to change the AggregateFunction property value of the
Amount measure to ByAccount.

D.
Add the ByAccount attribute to the account dimension.



Leave a Reply 1

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