We are trying to migrate TFS (RC) warehouse report to TFS (RTM) warehouse.
My query in TFS (RC) is using “[Current Week]” for getting the current week details.
SELECT NON EMPTY {([Measures].[Current Work Item Count]),([Measures].[tasksendedthatweek]),([Measures].[tasksactuallyendedthatweek]),([Measures].[tasksactuallystartedthatweek])} ON COLUMNS, lastperiods(5,strtomember('[HP_Apprise_PM_Task_StartDate1].[Year Week Date].[Week].[Current Week]')) on rows FROM [Current Work Item] where {strtoset
The above query is failing in TFS (RTM) reporting (its not giving any error, but am not able to get the data).
When I replaced “[Current Week]” with the specific Week date, am able to get the correct data I need.
SELECT NON EMPTY {([Measures].[Current Work Item Count]),([Measures].[tasksendedthatweek]),([Measures].[tasksactuallyendedthatweek]),([Measures].[tasksactuallystartedthatweek])} ON COLUMNS, lastperiods(5,strtomember('[HP_Apprise_PM_Task_StartDate1].[Year Week Date].[Week].&[2006-09-03T00:00:00]')) on rows FROM [Current Work Item] where {strtoset
Please let me know the clause to be used with [Year Week Date].[Week] hierarchy to get the Current Week details.
Thanks in advance
Kavitha