index > Team Foundation Server - Reporting > How to get "Current Week" in MDX Query

How to get "Current Week" in MDX Query


We are trying to migrate TFS (RC) warehouse report to TFS (RTM) warehouse.

SVKavitha
What error did you get when you run the original query in the Data tab when you open your report in Visual Studio (inside a report server project)?


Patrick Ng - Visual Studio Team Foundation Server
Patrick Ng - MSFT

when am using : [HP_Apprise_PM_Task_StartDate1].[Year Week Date].[Week].[Current Week]

SVKavitha

Hi Kavitha,

Jimmy Li - MSFT
reply 4

You can use google to search for other answers

 

More Articles

Can't find "Comments" of my manual test in my Team syst...
Did report updating frequency change since Beta 3?
How to recreate the TFSWarehouse Database ?
Creating an OLTP datasource for writing reports
Passing new parameters to Report(.rdlc)
Error in Reporting
cubes issue
How to Remove the row which doesn't have data?
Reports show no data - but it's there! Really, it is.
Bug Rates Report - Getting very weird report
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

NullReferenceException during Code Churn…
Importance of Work Items - Remaining Work
Extra strain report (overeffor or sobree…
Datawarehouse, how can I do?
Can not find any Perspective other than …
Problem with WI's and reportable="d…
Adding Data Region to existing items
Error al procesar el informe. (rsProcess…
Only Team Sytem cube is visible
Print reports without preview
An attempt has been made to use a data e…
Report Path!
AssignedTo names in reports
When trying to add a new VS2005 RDL file…
schedulingfinishdate error + how to add …

Hot Articles

Setting for URL in Reporting services
How is unplanned work report calculated?
How do I fix the TfsOlapReportDS user pr…
What ?淒efault Value??is the correct one…
What's the difference between TfsReportD…
How the change in the data of Cube will …
Having trouble deploying to the report s…
Errors when deploying to ReportServer
Where are the Models?
Report Checked Out Items and Changed Items
Issues List is not working
Does Business Intelligence Development S…
The synchronization issue of the reporting
Build metrics
Improper Display in ReportViewer

Recommend Articles

date current state was set
How to force Repository Refresh?
NullReferenceException during Code Churn…
Error when trying to display a report
report of links between work items - doe…
Passing new parameters to Report(.rdlc)
Adding the Build_Type field to the TFS B…
"TF53010: An unexpected condition h…
schedulingfinishdate error + how to add …
problems passing parameters to subreport
Missing TfsReportDS and TfsOlapReportDS
Passing new parameters to Microsoft VB.N…
Issues with dimension after following wa…
When trying to add a new VS2005 RDL file…
Report server error