You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008. To meet the business development, you create a SQL Server
2008 Analysis Server (SSAS) solution, which has a measure named ProductQuantity and a
price dimension named DimPrice along with a hierarchy named Price. Then the code
segment is added to the calculation script of the cube as the following: (Line letters are used
only for reference.) Now you get an order from your manager to accomplish the following
tasks:
1. Increase the value of the ProductionQuantity measure by 60% for each month in the
fourth quarter of 2006.
2. Keep the value for the fourth quarter of 2006 unchanged.
What action should you perform to accomplish the tasks above?
A.
You should have the code segment below added at line A:
Scope([Measures].[Quantity],[DimPrice].[Price].[Quarter]. [Q4
2006]);This=[DimPrice].[Price].currentmember * 1.6;End Scope
B.
You should have the code segment below added at line D:
Scope([Measures].[ProductQuantity],Descendants([DimPrice].[Price].[Quarter]. [Q4
2006][DimPrice].[Price]. [Month]));This=[DimPrice].[Price].currentmember * 1.6;End Scope;
C.
You should have the code segment below added at line A:
Scope([Measures].[ProductQuantity],Descendants([DimPrice].[Price].[Quarter].[Q4
2006][DimPrice].[Price]. [Month]));This=[DimPrice].[Price].currentmember * 1.6;End Scope;
D.
You should have the code segment below added at line D:
Scope([Measures].[Quantity],[DimPrice].[Price].[Quarter]. [Q4
2006]);This=[DimPrice].[Price].currentmember * 1.6;End Scope;