We have a very nice working cube that resided on SQL 2008. Not R2. Everything working fine.
Once we started deploying to R2, we found this issue. Here is how I checked it. I took a backup file from non-R2 server and restored on another not R2 and 2 different R2 servers. All had the same issue.
Here are few samples of the sets that we have.
/* Sets */
CURRENTCUBE .[Current Month]
AS [Date].[Date Hierarchy].CurrentMember
, DISPLAY_FOLDER = 'Relative Period Sets' ;
View Complete Post