none
Unable to view Data Analysis in Project Server 2007 RRS feed

  • Question

  • Hi,

    I am currently using Project server 2007. One of our PM is not able to view Data Analysis information which are available to other PM.

    It says 'The query cannot be processed. Either the user doesn't have access to Analysis service Database or the database doesn't exist"

    We checked the following. 

    Tools > Internet options > Security tab > Click Trusted Sites > Custom Level > Search for Access data source across domains and its enabled. 

    Kindly advice. Thanks in advance!

    Wednesday, March 25, 2015 2:09 PM

All replies

  • Hi Nathik,

    You should also check that the PM in question has not been granted specific permission. If he doesn't have the "View OLAP Data" and "View Data Analysis" permissions, he will not be able to use the data analysis. Also check that the PWA URL is in the trusted site of IE. Finally press CTRL F5 to clean IE cache. Check also that the OLAP cubes were successfully built.

    A good way for you to debug is to use your admin account on his machine to see if it is a permission issue or a IE setting issue.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |


    Wednesday, March 25, 2015 2:21 PM
    Moderator