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-SumAut].[Aut].[ Spring 2008]) for the named set.
B.
You should write ParallelPeriod ([DimTime]. [Spr-Sum-Aut].[Aut], 1, [DimTime]. [Spr-SumAut].[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-SumAut].[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.
RemarksWithin 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