SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cube report #error issue


Cube report #error issue

Author
Message
niha.736
niha.736
SSC Journeyman
SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)

Group: General Forum Members
Points: 96 Visits: 233
Hi, All
My report dataset contains 3 date fields,, date1, date2, date diff
datediff field formula is "=cdec(DateDiff(DateInterval.Day,Fields!Date.Value,Fields!Date2.Value))*(-1)"
and the expression for this datediff column in report is "=Avg(Fields!DateDiff.Value)"

Reasoncode->Notification->Material date1 date2 datediff

213->875869->some product 03.01.2013 03.01.2013 31.7

this 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 #Error 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.
Old cube : [ Date DIM].[Date Hierarchy ].[Date].&[1900-01-01]
New cube : [ Date DIM].[Date Hierarchy ].[Date].&[1900-01-01T00:00:00]



suggest something if anyone knows.
thanks
niha
MMartin1
MMartin1
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2745 Visits: 2031
Are 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.

----------------------------------------------------
How to post forum questions to get the best help
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search