1.

You work as a database administrator for Abc.com. You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. The SSAS solution includes a time dimension named CKTime which includes a hierarchy named Year-By-Day. The solution also contains a measure group named CKMeasure. You own a measure named Quantity from CKMeasure. You need to develop a calculated member in order to show the Quantity measure in the previous time period for the current level of the Year-By-Day hierarchy. What should you do?

A. You should use [CKMeasures].[Quantity],OPENINGPERIOD([CKTime].[Year-By- Day].FirstSibling.Level)) as a calculated member.
B. You should use ([CKMeasures].[Quantity],LASTPERIODS(0,[CKTime].[Year- By- Day].PrevMember)) as a calculated member.
C. You should use ([CKMeasures].[Quantity],LASTPERIODS(1,[CKTime].[Year- By- Day].PrevMember)) as a calculated member.
D. You should use ([CKMeasures].[Quantity],[CKTime].[Year-By- Day].NextSibling) as a calculated member.
Answer» D. You should use ([CKMeasures].[Quantity],[CKTime].[Year-By- Day].NextSibling) as a calculated member.


Discussion

No Comment Found