PWA users time not showing in OLAP Cubes RRS feed

  • Question

  • Thank you ahead of time. 

    We have one particular users who time is not moving from the project to the OLAP cubes to be used to report Capitalized hours on a project.  I have checked her Group and cost center and no information is being pulled in.  She has submitted hrs for the last qtr of 2010 and they have been accepted and published in the project and appear when looking at the project, but if you go into the Data Analysis and search users hours she will not be listed at all.  Any thoughts.


    Thanks again

    Robert Self

    Tuesday, March 8, 2011 6:37 PM


  • Hi Robert,

    If I were troubleshooting this for a customer, I would look at the following:

    1. Verify there are no filters in the report being used to display the information

    2. Verify that the cubes have ben rebuilt following the publish

    3. Create a new pivot table from the cube the values are supposed to be within, and add the various measures and dimensions to verify if the data is present

    4. Open the cube via SQL Server analysis services management studio and verify if the data was present in the cube

    5. Verify if the data is present in the reporting db to start with.

    Let us know how you go.

    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, March 8, 2011 9:27 PM