PrepAway - Latest Free Exam Questions & Answers

How should you complete the MDX statement?

DRAG DROP
You are writing a MDX query to retrieve data from a Microsoft SQL Server Analysis Services (SSAS) cube named Channel Sales. The cube defines two measures named Sales and Cost. The cube also defines a Date dimension and a Product dimension.
You need to retrieve profit values for a year named CY2016.
How should you complete the MDX statement? To answer, drag the appropriate MDX segment to the correct locations. Each MDX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/working-withmembers-tuples-and-sets-mdx


Leave a Reply