Project Server 2010 EXCEL report using cube data never refreshes? RRS feed

  • Question

  • Here is a case:

    I have created Issues report in excel using Cube. I can easily connect my excel 2010 sheet with the required cube using Data Connection and it all went fine. Now when i go to save and send and select "Save to SharePoint", browse for a location do not bring any locations for me.

    Now alternatively i have saved the file to a local location, and then upload the file to the:

    http://<servername>/<instance name>/projectBICenter/SampleReports/

    now if i create a new issue, build the Cube and check the report, the report never reflects the updated data. and at the same time if i can check the out of the box IssuesAndRisks report,which resides in the same folder, it shows me the updated data.

    if in my report i try to do the Refresh all connection from Data tab, it always come up with this msg:

    The data connection uses Windows Authentication and user credentials could not be delegated. The following connections failed to refresh:

    please help me with this. Why my report produce error when tries to refresh, am i missing any configuration step?




    Saturday, August 7, 2010 8:22 AM


All replies