Exam 70-768 topic 1 question 29 discussion

HOTSPOT -
A company has a multidimensional cube that is used for analyzing sales data. You add a new measure named Transaction Total Including Tax and include the
Supplier, Payment Method, and Transaction Type dimensions in the data model. The Transaction Total Including Tax measure uses the existing Customer and
Date dimensions.
When users have queried the new measure in the past, they saw results as shown in the existing query output exhibit. (Click the Exhibit button.)

The overall total is incorrectly displayed on every row. In addition, the results are no longer formatted correctly.
The query result should appear as shown in the desired query output exhibit. (Click the Exhibit button.)

You need to ensure the table is displayed correctly.
What should you do? Use drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Suggested Answer:
Box 1: Enter a custom MeasureExpression property on the measure
Calculated measures use MDX expressions to supply their values, instead of binding to columns in a data source. The Expression property contains the MDX expression used to supply the values for a Measure only if the Measure is a calculated measure. Otherwise, this property contains an empty string ("").
Incorrect Answers:
Not the IgnoreUnrelated property to False.'
IgnoreUnrelatedDimensions' is a measure group property which when set to False hides the measure value when seen against an unrelated dimension attribute.
Box 2:
Include the symbol $ in FormatString.
References:
https://technet.microsoft.com/en-us/library/microsoft.analysisservices.adomdclient.measure.expression(v=sql.110).aspx https://social.technet.microsoft.com/wiki/contents/articles/24168.hideunhide-a-measure-irrespective-of-ignoreunrelateddimensions-property-of-its-measure- group.aspx https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/mdx-cell-properties-format-string-contents