Basecapacity and Capacity values are displaying within the time range 2011-2014 in the Reporting OLAP cubes RRS feed

  • Question

  • Hi,

    In PWA user availability showing until latest project close date, but in the the Reporting OLAP cubes the measures BaseCapacity, Capacity are displaying results between the time range 2011 to 2014, 

    we have changed Reporting database data range months ahead behind in PWA level,we tried to rebuild the cube but no use, same time range values are displaying.

    is der any configuration settings for this at cube level? or else any setting need to be take?,

    this is only happening in resource level,

    TimeSheet and task level values are displaying until latest project close data.

    Wednesday, March 30, 2016 6:41 AM

All replies

  • Hello,

    What do you have for the "Resouce Capacity Settings" on the Additional Server Settings page in PWA? Do you see a successful job in the queue for "Reporting (Resources Capacity Range Sync)"?


    Paul Mather | Twitter | | CPS | MVP | Downloads

    Wednesday, March 30, 2016 8:04 AM
  • This is something strange.Possible options to go ahead now -

    Go to OLAP Database Build Setting and select 'Use the earliest project start date and latest project finish date' option under Database Date Range.Rebuild the cube and check then please.

    Try to run a direct query against reporting database in EPMResourceByday table and check the result if it is same as coming through Cube or different.If result is expected then problem in cube,delete it and reconfigure it.If same problem then go to affected resource and open it in project professional and check the Available From and AvailableTo Date which can give you a clue if its belong from it.



    Mark it as answer if it helps.

    Wednesday, March 30, 2016 12:00 PM