You have a cube named Cube1 that contains the sales data for your company. You plan to build a report based on the cube. You need to write an MDX expression that returns the total sales from the…

The complete MDX query with the correct segments inserted at lines 03 and 05 is: ``mdx SELECT [Measures].[Sales Amount] ON ROWS ,{ OpeningPeriod ( [Date].[Fiscal].[Month] , [Date].[Fiscal].[Fiscal Year].&[2009] ) , ParallelPeriod ( [Date].[Fiscal].[Fiscal Year] , -1…

Build an analysis services database

Question

You have a cube named Cube1 that contains the sales data for your company. You plan to build a report based on the cube. You need to write an MDX expression that returns the total sales from the first month of the 2009 fiscal year and the total sales from the same period of the 2008 fiscal year. Which code segments should you insert at line 03 and line 05? To answer, drag the appropriate code segments to the correct lines. Each code segments 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.

Explanation

The complete MDX query with the correct segments inserted at lines 03 and 05 is:

SELECT [Measures].[Sales Amount] ON ROWS
,{
    OpeningPeriod ( [Date].[Fiscal].[Month] , [Date].[Fiscal].[Fiscal Year].&[2009] )
    ,
    ParallelPeriod ( [Date].[Fiscal].[Fiscal Year] , -1 , OpeningPeriod ( [Date].[Fiscal].[Month] , [Date].[Fiscal].[Fiscal Year].&[2009] ) )
    } ON COLUMNS
FROM [Cube1];

Where:

Line 03 requires: OpeningPeriod ( [Date].[Fiscal].[Month] , [Date].[Fiscal].[Fiscal Year].&[2009] ) (to get total sales from the first month of 2009 fiscal year)
Line 05 requires: ParallelPeriod ( [Date].[Fiscal].[Fiscal Year] , -1 , OpeningPeriod ( [Date].[Fiscal].[Month] , [Date].[Fiscal].[Fiscal Year].&[2009] ) ) (to get total sales from the same period of the 2008 fiscal year, using -1 for the previous year).

Topics

#MDX expressions#time intelligence#fiscal year#PARALLELPERIOD

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice