You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has the
following components:
A hierarchy named Date in a time dimension named DimTime
A measure named SalesAmount
You add the following code segment to the calculation script of the cube. (Line numbers are
included for reference only.)
01 . . .
02 Freeze([Measures].[SalesAmount],
03 [DimTime].[Date].[Quarter].[Q1 2007]);
04 . . .
You need to increase the value of the SalesAmount measure by 50% for each month in the
first quarter of 2007.
You also need to ensure that the value for the first quarter of 2007 remains unchanged.
What should you do?
A.
Add the following code segment at line 04.
Scope([Measures].[Amount],[DimTime].[Date].[Quarter]. [Q1
2007]);This=[DimTime].[Date].currentmember * 1.5;End Scope;
B.
Add the following code segment at line 01.
Scope([Measures].[Amount],[DimTime].[Date].[Quarter]. [Q1
2007]);This=[DimTime].[Date].currentmember * 1.5;End Scope;
C.
Add the following code segment at line 04.
Scope([Measures].[SalesAmount],Descendants([DimTime].[Date].[Quarter]. [Q1
2007][DimTime].[Date].[Month]));This=[DimTime].[Date].currentmember * 1.5;End Scope;
D.
Add the following code segment at line 01.
Scope([Measures].[SalesAmount],Descendants([DimTime].[Date].[Quarter].[Q1
2007][DimTime].[Date].[Month]));This=[DimTime].[Date].currentmember * 1.5;End Scope;