You are developing a SQL Server 2008 Analysis Services (SSAS) method which owns a date dimension called DateTester along with a rule called CalendarTester for Company.com.
The CalendarTester rule owns levels for the Year, Quarter, Month, and Date properties.
You should make sure that you could develop a called setTester that connects with the first eight months of the year 2008.
Which is the correct answer?
A.
You should use the expression below:
[ Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[August 2008])
B.
You should use the expression below:
[ yr-day].[Month], [DimTime].[Yr-Qtr-Mth].[Month].[ August 2008])
C.
You should use the expression below:
[yr-day]. [Month],8, [DimTime].[ yr-day].[Month].[ August 2008])
D.
You should use the expression below:
[ yr-day].[Year],8, [DimTime].[ yr-day].[Month].[ August 2008])