locked
TFS 2012 reporting for MSF Agile template not working RRS feed

  • Question

  • Hi,

    I am getting an error when I try to view reports related to Dashboard and "Remaining Work" report. Error is as below

    • An error has occurred during report processing. (rsProcessingAborted)
      • Query execution failed for dataset 'dsBurndown'. (rsErrorExecutingCommand)
        • Query (7, 2) The '[Microsoft_VSTS_Scheduling_RemainingWork]' member was not found in the cube when the string, [Measures].[Microsoft_VSTS_Scheduling_RemainingWork], was parsed.

    I tried the solution of deleting OLAP cube and then recreating it through Admin console but that is also not working. Tried solution in below article as well but it also doesn't seem to work.

    http://social.msdn.microsoft.com/Forums/vstudio/en-US/d145033f-5c1f-469d-8b85-d66d541e2e07/msfagile-v50-template-error-in-bug-report

    Any help will be highly appreciated as I need all these reports urgently.

    Thanks,

    Priyanka


    • Edited by Priyankad Thursday, July 11, 2013 2:01 PM
    Thursday, July 11, 2013 1:58 PM

Answers

  • Hi,

    Thanks for your post!

    Have the password of the been changed or expired?

    If yes, please go to http://servername/reports, open the Tfs2010OlapReportDS and Tfs2010ReportDS and change the password which stored in the report server. Then In the TFS administrator console, click Reporting->Edit, in the Analysis Services and Reports tab, input the correct password and click OK.

    Best Regards,


    Cathy Kong
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, July 12, 2013 9:04 AM
    Moderator