You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has a date
dimension named Date along with a hierarchy named Calendar. The Calendar hierarchy has
levels for the Year, Quarter, Month, and Date attributes. You need to create a named set
that refers to the first seven months of the year 2007. Which expression should you write for
the named set?
A.
PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
B.
PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Month], [DimTime].[Yr-Qtr-Mth].[Month].[July
2007])
C.
ParallelPeriod([DimTime].[Yr-Qtr-Mth].[Year], 7, [DimTime].[Yr-Qtr-Mth].[Month].[July
2007])
D.
ParallelPeriod ([DimTime].[Yr-Qtr-Mth].[Month], 7, [DimTime].[Yr-Qtr-Mth].[Month].[July
2007])
Explanation: