Which is the correct answer?

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?

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])



Leave a Reply 0

Your email address will not be published. Required fields are marked *