Microsoft
70-448 · Question #17
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…
The correct answer is A. PeriodsToDate([DimTime].[Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007]). See the full explanation below for the reasoning.
Question
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?
Options
- APeriodsToDate([DimTime].[Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
- BPeriodsToDate([DimTime].[Yr-Qtr-Mth].[Month], [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
- CParallelPeriod([DimTime].[Yr-Qtr-Mth].[Year], 7, [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
- DParallelPeriod ([DimTime].[Yr-Qtr-Mth].[Month], 7, [DimTime].[Yr-Qtr-Mth].[Month].[July 2007])
How the community answered
(27 responses)- A74% (20)
- B7% (2)
- C4% (1)
- D15% (4)
Community Discussion
No community discussion yet for this question.