We are trying to Migrate Team Foundation Server (RC) reports to Team Foundation Server (RTM). All the reports using Date dimension are failing as Date dimension is changed in RTM. Can anybody help me to understand the changes occurred in the date dimension (RTM) and how we need to use it.

Here's my Report query which was successfully running in TFS (RC)

WITH MEMBER [Measures].[daycurrentweek] as 'dateadd("d",15 - Weekday(now())  ,now())'MEMBER [TaskStartDate].[Year Week Date].[Current Week] as 'strtomember("[TaskStartDate].[Year Week Date].[Week].[Week of " + str(month([Measures].[daycurrentweek]))  + "/" + str(day([Measures].[daycurrentweek])) +"/"+ str(Year([Measures].[daycurrentweek]))  + "]").uniquename'

MEMBER [Measures].[tasksendedthatweek] as 'lookupcube("[Current Work Item]","sum((" +[Team Project].[Team Project].currentmember.uniquename + ",[TaskEndDate].[Year Week Date].[Week].[" +
[TaskEndDate].[Year Week Date].currentmember.membervalue + "]),[measures].[current work item count])")'

SELECT NON EMPTY {([Measures].[Current Work Item Count]),([Measures].[tasksendedthatweek])} ON COLUMNS, lastperiods(5,strtomember([TaskStartDate].[Year Week Date].[Current Week])) on rows FROM [Current Work Item] where {strtoset(@TeamProjectTeamProject)}

Kindly suggest the changes to be done to the query.

Thanks in advance

Kavitha.

Hi Kavitha,

I'll investigate this a bit more and get back to you.

Thanks!
Mauli

hi kavitha, hopefully the response in this thread helps you:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=694785&SiteID=1

mauli