You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You create a cube with the following objects:
A time dimension named Time.
A fact table that contains two columns named Order Date Key and Numbers of Orders.
A Number of Orders measure added to a measure group named Measures.
The cube has a dimension usage named Order Date that links the Order Date Key column to the Time dimension.
You need to create a Multidimensional Expressions (MDX) calculation that displays the cumulative totals of the Number of Orders column for all hierarchies in the Order Date dimension.
Which MDX expression should you use?
A.
SUM([Order Date].[Calendar].CurrentMember,[Measures].[N umber of Orders])
B.
SUM(PeriodsToDate([Order Date].[Calendar].CurrentMember.Parent.Level,[Order Date].[Calendar].CurrentMember),[Measures].[Number of Orders])
C.
SUM(PeriodsToDate([Order Date].[Calendar].CurrentMember.Parent,[Order Date].[Calendar].CurrentMember),[Measures].[Number of Orders])
D.
SUM([Order Date].[Calendar].CurrentMember,SUM([Order Date].[Calendar].CurrentMember.Parent,[Measures].[ Number of Orders]))