Can I view Generic Resource Names in cubes? RRS feed

  • Question

  • Hi All,

    I have created Generic resources in the Project Server 2010. Also have assigned certain tasks to them. I could not see their names and assignments in the OLAP cubes. Is there a way in which I can see the names of the resources and their assignments?

    Cheers, Amit Wairkar

    Saturday, March 22, 2014 6:59 AM

All replies

  • Hi Amit,

    You could start by checking the following:

    • Are the generic resources enterprise resources?
    • Did you successfully publish projects with the generic resources assignments?
    • Do the assignments have some work?
    • Don't you have any filters (on the resource types for example) in your OLAP excel reports?
    • Have the cubes been successfully generated?
    • Are you looking at the correct time periods?

    Hope this helps.

    Guillaume Rouyre - MBA, MCP, MCTS

    Saturday, March 22, 2014 4:31 PM
    • Yes, these are enterprise resources
    • i published the projects twice and checked for the cubes after processing them. But no victory :P
    • Yes, the assignments have work for 4 days
    • I checked with filters on the Generic resource and without filters too
    • Cubes were processed succesfully
    • I did not add the time periods, neither there was a filter

    I can see their work in the Resource Assignments in the PWA but in the resource Availability it doesnt show up.

    Am i going wrong sumwhere?

    Cheers, Amit Wairkar

    Sunday, March 23, 2014 5:45 AM
  • Hi Amit,

    Can you check with an Excel Services file and an ODC connection to the reporting DB if you can see those assignments?

    It can be a reporting db sync issue that could imply missing data in the OLAP cubes.

    Hope this helps.

    Guillaume Rouyre - MBA, MCP, MCTS

    Monday, March 24, 2014 7:35 AM