MCQOPTIONS
Saved Bookmarks
| 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. | |