Hi all,

I am curious why the Date dimension is designed as [Date].[Date].&[1]
using the dimension surrogate key, instead of
[Date].[Date].&[2001-07-01] using the date value itself


Often, don't we construct MDX with
SELECT [Measures].[Internet Sales Amount] ON COLUMNS
FROM [Adventure Works]
WHERE [Date].[Date].&[2001-07-01]

instead of
SELECT [Measures].[Internet Sales Amount] ON COLUMNS
FROM [Adventure Works]
WHERE [Date].[Date].&[1]


I am contemplating to follow how AdventureWorksDW design or use a more
friendly format. The cube I am building is the main source for reports
constructed with SSRS 2005, and Report Start and End Dates are very
common parameters required.

Any advice? Insights?

Thanks.