You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008.
To meet the business development, you create a SQL Server 2008 Analysis Services (SSAS) solution, which has a hierarchy named Season in a Time dimension named Dimtime.
The attributes of Spring level, Summer level, Autumn level and Winter level are contained in the Season hierarchy.
Now you are assigned a task to create a named set to refer to the first season of the year 2008.
What action should you perform to accomplish this task?
A.
You should write ParallelPeriod([DimTime]. [Spr-Sum-Aut].[Spr], 1, [DimTime]. [Spr-Sum-Aut].[Aut].[ Spring 2008]) for the named set.
B.
You should write ParallelPeriod ([DimTime]. [Spr-Sum-Aut].[Aut], 1, [DimTime]. [Spr-Sum-Aut].[Aut].[ Spring 2008]) for the named set
C.
You should write PeriodsToTime([DimTime].[Spr-Sum-Aut].[Spr], [DimTime]. [Spr-Sum-Aut].[Aut].[Spring 2008]) for the named set
D.
You should write PeriodsToTime([DimTime].[Spr-Sum-Aut].[Aut], [DimTime]. [Spr-Sum-Aut].[Aut].[Spring 2008]) for the named set.
Explanation:
,msdn http://msdn.microsoft.com/en-us/library/ms144925.aspx
PeriodsToDate (MDX)
SQL Server 2008 R2 Other Versions
Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by a specified level in the Time dimension.Syntax
PeriodsToDate( [ Level_Expression [ ,Member_Expression ] ] )Arguments
Level_Expression – A valid Multidimensional Expressions (MDX) expression that returns a level.
Member_Expression – A valid Multidimensional Expressions (MDX) expression that returns a member.Remarks
Within the scope of the specified level, the PeriodsToDate function returns the set of periods on the same level as the specified member, starting with the first period and ending with specified member.
* If a level is specified, the current member of the hierarchy is inferred hierarchy.CurrentMember, where hierarchyis the hierarchy of the specified level.
* If neither a level nor a member is specified, the level is the parent level of the current member of the first hierarchy on the first dimension of type Time in the measure group.PeriodsToDate( Level_Expression, Member_Expression ) is functionally equivalent to the following MDX expression:
TopCount(Descendants(Ancestor(Member_Expression, Level_Expression), Member_Expression.Level), 1):Member_Expression