You are developing a SQL Server 2008 Reporting Services (SSRS) method for
Company.com.
There are some components listed below:
A hierarchy called Test in a time dimension called DimTestTime
A method called SalesNumber You decide to increase codes to the cube’s calculation
11. . . .
12 Freeze([Measures].[ SalesNumber],
13 [DimTestTime].[ Test].[Quarter].[Q0 2008]);
14. . . .
For every month in the second quarter of 2008, not only should you add the value of the
SalesNumber measure through 80%. But also you should make sure that the value for the
second quarter of 2008 keeps common.
Which is the correct answer?
A.
You should increase codes below at line 14.
Scope([Measures].[DimTime].[Date].[Quarter].[Q0
2008]);This= [DimTime].[Date].currentmember * 3;End Scope;
B.
You should increase codes below at line 11. Scope([Measures].[ SalesNumber],[
DimTestTime].[ Test]. [Quarter]. [Q0 2008]);End Scope;
C.
You should increase codes below at line 14 [
SalesNumber],Descendants([DimTestTime].[
Test].[Quarter]. [Q0 2008][ DimTestTime].[ Test].[Month]));This=[ DimTestTime].[
Test].currentmember * 5;End Scope;
D.
You should increase codes below at line 11. Scope([Measures]
SalesNumber],Descendants([DimTestTime]. [ Test].[Second].[ Q0 2008][ DimTestTime].[
Test].[
Second]));This=[ [ Test] [Second].currentmember * 1.5; End Scope;