InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 11:55:58 GMT20http://www.sqlservercentral.com/Forums/Topic1418806-147-1.aspxAre the latencies in data similar? In your old report you may have had access to up to the minute data whereas in the new cube current is defined as up to last night at midnight. Also consider MDX does not use the exact date functions as SSRS.Tue, 30 Apr 2013 11:06:14 GMTmmartin1http://www.sqlservercentral.com/Forums/Topic1418806-147-1.aspxHi, All My report dataset contains 3 date fields,, date1, date2, date diffdatediff field formula is "[b]=cdec(DateDiff(DateInterval.Day,Fields!Date.Value,Fields!Date2.Value))*(-1)[/b]"and the expression for this datediff column in report is "[b]=Avg(Fields!DateDiff.Value)[/b]"Reasoncode->Notification->Material date1 date2 datediff 213->875869->some product 03.01.2013 03.01.2013 31.7this is the format of old report.1.we have created a new cube basing on few drawbacks of old cube , and now we need generate all existing reports by pointing to the new cube.2.changes are like dimension structure, removing/adding attributes and measures,changes in hierarchies.3.we are just copying the old report datasets, datasources and pointing to new cube and doing changes in mdx script according to the modifications.4.after applying all the changes when clicked preview I got [b]#Error [/b]in datediff column. what could be the reason for this error.I kept expressions of this datediff columns same.is there anything with below changes of dim.[b]Old cube : [ Date DIM].[Date Hierarchy ].[Date].&[1900-01-01]New cube : [ Date DIM].[Date Hierarchy ].[Date].&[1900-01-01T00:00:00][/b]suggest something if anyone knows.thanksnihaTue, 12 Feb 2013 02:14:42 GMTniha.736