A calculated measure with MDX "datediff ("d",[Collection Date].[Date],now())" is returning a huge number - 734855 - for all records.
The Date dimension has a surrogate key with the natural key 'Date' identified in SSAS as the Name column for the surrogate. Incorporating 'Date' as a row in a report correctly shows the date.
Is there an error in the MDX above or is it due to using a surrogate key on the Date dimension?
When you don’t specify the [Collection Date].[Date] on filters, rows or columns it will be set to the default member (All Collection Dates). The DateDiff will net be able to convert “All Collection Dates” to a date.
Your MDX expression should check if the text is a date like:
Report Portal
MDX datediff query
Posted - 12/19/2012 : 08:01:59
