You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…

Question

Options

• AYou should write ParallelPeriod([DimTime]. [Spr-Sum-Aut].[Spr], 1, [DimTime].
• BYou should write ParallelPeriod ([DimTime]. [Spr-Sum-Aut].[Aut], 1, [DimTime].
• CYou should write PeriodsToTime([DimTime].[Spr-Sum-Aut].[Spr], [DimTime].
• DYou should write PeriodsToTime([DimTime].[Spr-Sum-Aut].[Aut], [DimTime].

• A
  2% (1)
• B
  9% (5)
• C
  84% (46)
• D
  5% (3)

Explanation

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 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 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 * 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

No community discussion yet for this question.