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 andDate 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:
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 (“”). when seen against an unrelated dimension attribute. https://technet.microsoft.com/en-us/library/microsoft.analysisservices.adomdclient.measure.expression https://social.technet.microsoft.com/wiki/contents/articles/24168.hideunhide-a-measure-irrespective-ofignoreunrelateddimensions-property-of-its-measure-group.aspx https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/mdx-cell-propertiesformat-string-contents
Answer: 
Explanation:
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
Incorrect Answers:
Not the IgnoreUnrelated property to False.’
IgnoreUnrelatedDimensions’ is a measure group property which when set to ‘False’ hides the measure value
Box 2:
Include the symbol $ in FormatString.
References:
(v=sql.110).aspx