get the app

Question: You work as a database administrator for You are in the process of creating a SQL Server 2008 Analysis Services (SSAS) solution for 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?
1)You should use [CKMeasures].[Quantity],OPENINGPERIOD([CKTime].[Year-By- Day].FirstSibling.Level)) as a calculated member.
2)You should use ([CKMeasures].[Quantity],LASTPERIODS(0,[CKTime].[Year- By- Day].PrevMember)) as a calculated member.
3)You should use ([CKMeasures].[Quantity],LASTPERIODS(1,[CKTime].[Year- By- Day].PrevMember)) as a calculated member.
4)You should use ([CKMeasures].[Quantity],[CKTime].[Year-By- Day].NextSibling) as a calculated member.

Previous Next

Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence

Recommended Learning for you

Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material