Exporting a Large Volume of Data from Resource Assignments to Excel Takes a Long Time
(Doc ID 2712987.1)
Last updated on OCTOBER 05, 2020
Applies to:Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 22.214.171.124 to 126.96.36.199 [Release 19.12]
Information in this document applies to any platform.
Exporting a large volume of data in P6 Web from Resource Assignments to Microsoft Excel format takes a long time to complete.
The view contains the following configuration:
Columns: 4 Project Codes, 3 Global Activity Codes, and 7 Resources Codes.
Filtering: Set to filter on a Project Code and Demand, Cost and Supply projects.
Grouping: 4 groupings (Project, 2 Project Codes and 1 Resource Code).
Sorting: Activity Name Ascending.
Gantt: Sight Lines and Non-Work time ticked; Timescale = Financial Period.
Spreadsheet: Timescale = Financial Period; Columns = Planned Costs, Planned Units, Period Actual Cost, Period Actual Units; Start and Finish Dates for spreadsheet span 12months.
Performance should be better while exporting large volume of data to excel from Resource Assignments.
The issue can be reproduced at will with the following steps:
- Log into P6 Web.
- Go to the Resource Assignments view.
- Create a view and filter as per above.
- Click Export.
- Monitor the View Service Status list, or wait for notification.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!