You are a database developer and you have about two years experience in reating business
Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to
you.
You use SQL Server 2008 Reporting Services (SSRS) to create a solution.
Your solution includes a time dimension named DimDay.
And the DimDay dimension contains a hierarchy named Yr-Qtr-Mth.
There is a measure group named Measures01 which contains a measure named Number.
Now a calculated member has to be created, then it will be used to display the Number
measure in the previous time period for the current level of the Yr-Qtr-Mth hierarchy.
In the following options, which expression should be used?
A.
([Measures01].[Number],OPENINGPERIOD( [DimDay].[Yr-Qtr-Mth].FirstSibling.Level))
B.
([Measures01].[Number],LASTPERIODS( 0,[DimDay].[Yr-Qtr-Mth].PrevMember))
C.
([Measures01].[Number],[DimDay].[Yr-Qtr-Mth].PrevMember)
D.
([Measures01].[Number],[DimDay].[Yr-Qtr-Mth].FirstSibling)
Explanation:
Functions for navigating Hierarchies
MDX provides functions such as PrevMember, Children, and Parent for navigating
hierarchies.
PrevMember takes a member and returns a previous member in the hierarchy. For example,
[Order Date]. [Calendar].PrevMember returns the previous member with respect to the
current
member of the Calendar hierarchy. So if the Calendar hierarchy is expanded to the Year
level and the current cell is referenced by year 2004, PrevMember will return year 2003.
EXAM TIP
The PrevMember function is frequently used to defi ne the KPI Trend or Goal properties. for
example, the Reseller Sales KPI uses the following expression to set the Goal property to 40
percent more than the Reseller Sales Amount for the previous date period: 1.40 *
([Date].[Calendar].PrevMember, [Measures].[Reseller Sales
Amount])
Consequently, if the user browses the cube data by years, the PrevMember function will
return the previous year for each year. If the user browses data by quarters, the
PrevMember will return the previous quarter for each quarter, and so on.