assignment time phased data set

• Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
• Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand
• OverflowAI GenAI features for Teams
• OverflowAPI Train & fine-tune LLMs
• Labs The future of collective knowledge sharing
• About the company Visit the blog

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Get early access and see previews of new features.

Power BI not retrieving project online timephased data

I have entered work against some tasks in Project Online. However when pulling the OData feed down in Power BI the AssignmentBaselineTimePhased datasets and AssignmentTimephasedDatsets are empty, despite not having any filters applied in Power BI.

The summary data in AssignmentBaselines is available but being summary values only plots as dots. How can the timephased detail data be retrieved?

• powerbi-desktop
• project-online

The problem was actually that Microsoft have changed the default granularity of OData PWA feeds to "Never" for Timephased datasets. The purpose is to improve performance of the feeds by returning less data.

The fix is to change the reporting granularity in Project Online Reporting to (in this case) Daily:

Note: You'll have to republish your project for this to take effect.

MSDN blog post here: Project Online: Changes to Granularity of Time phased OData

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Sign up or log in

Post as a guest.

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy .

Not the answer you're looking for? Browse other questions tagged odata powerbi-desktop project-online or ask your own question .

• Featured on Meta
• We've made changes to our Terms of Service & Privacy Policy - July 2024
• Announcing a change to the data-dump process

Hot Network Questions

• Astral self monk simic hybrid grapple with its extra appendages
• What's wrong with constructions like "Dragons are big, green, and eat people."?
• 50s-60s novel likely written by a British author — ancient starship discovery unveils humanity's extraterrestrial roots
• Is a hotter heat source always necessary for an object to be heated?
• What techniques are there for preventing radio-signal replay attacks?
• How accurate is my phone's magnetometer?
• Why don't neutrons and protons have variable half-integer spin?
• Can it be predicted if an Interstellar Object will get bound to the solar system by knowing its speed and direction?
• Why is transfer of heat very slow as compared to transfer of sound in solids?
• What this sentence mean here: 「屁しよ思たら漏れたわって」
• How can a vulnerable function can be a exploited by a non-logged user if it only called in the WP admin section of a plugin?
• Split column into lines using awk
• How to finish off a sudoku with lots of options?
• Can I solder aged copper with patina on it?
• How to extract pipe remnant from ground sleeve?
• Whether an isotone bijection from a power set lattice to another sends singletons to singletons
• Political Relations on an Interstellar Scale
• tikz & amsmath: how can I align math formulas within a tikz matrix?
• How to play mono (or very unbalanced stereo) through both ears?
• Is there any anti-ice system on Cessna Citation II?
• When I use SSH tunneling, can I assume that the server does not need to be trusted?
• Which text-to-image service/model can preserve character consistency?
• Where is there is only set of odds ratio in ordinal logistic regression?
• Extending PC Peripherals in a Separate Tech Booth at a Venue

Use data to forecast resource demand in Project Online

As a resource manager, you know that engaging the right resources for the right projects for the right amount of time is always a challenge, especially because you need to predict the future somehow. The good news is that you can use Project Web App for Project Online to analyze historical resource usage data captured in similar past projects. With this data you can more confidently forecast resource needs for future projects and even for your entire organization. You can then create models in upcoming projects to more accurately define the who, how, and when of resource engagement.

In this topic

See the types of resources used in past projects

See how much a resource was used in past projects, find more sources of historical resource data, develop resource forecasts for upcoming projects by creating generic resources, set the stage for future resource forecasting.

If your organization has been using Project Web App for Project Online for at least one or two completed projects, you can use the historical data captured in those projects to help forecast resource needs for upcoming similar projects. For example, you might be able to use information from a system deployment project implemented two years ago to collect resource information for a similar deployment planned for next year. With historical project and resource data, you can analyze the types of resources used and their skill sets.

Review resources on the Build Team page

The first place to look for the types of resources used in a completed similar project is on the Build Team page. Here you can see the names of all resources assigned to a selected project.

In the Quick Launch, choose Projects .

In the Project Center , choose the name of the completed similar project you want to review.

To open the Build Team page, on the Project tab, in the Navigate group, choose Build Team .

Make a note of the resources listed on the right side of the view. These are the team members for the selected project whose information you’ll be researching for your forecast.

Tip:  It might be easier to print or add a screen capture of the page to your notes.

Review a resource’s details on the Edit Resource page

Now that you have the names of the resources who worked on the project, you can look at the resources individually on the Edit Resource page, and gather information about their functional skill sets, work units, and costs.

In the Quick Launch, choose Resources .

The Resource Center page opens. The Resource Center lists all resources in your organization’s resource pool who are set up in Project Web App. The team members of the project you chose are among this list.

Select the check box next to the name of the first resource you want to research.

On the Resources tab, in the Resources group, choose Edit .

The Edit Resource page opens, showing details about your selected resource.

For information about the type of resource, look at the RBS , Resource Departments , and Code fields. The Code field is sometimes used for job titles or job codes.

Tip:  If a code is present in the RBS field, you can press the Select Value button (the ellipses button) to see the full resource breakdown structure. An RBS is a hierarchical outline of functions which is often used to define resources from a functional or role-based point of view in a project. This contrasts with the department name or human resources job title in a company. If your organization has set up an RBS to detail functional skill sets and it’s been set up in Project Online, this is an excellent place to help determine the types of resources to recruit for upcoming similar projects.

For information about how much of this type of resource was assigned to this project, look at the Current Max. Units (%) field.

For information about the resource’s costs, look at the Standard Rate , Overtime Rate , and Cost/Use fields. Note any information that’s useful to you. Again, print or capture the page if that’s easier.

When finished, choose Cancel .

In the Resource Center, select the check box next to the name of the next resource you want to research and repeat this process.

Note:  While people assigned to project tasks are considered work resources and are the most common project resources, equipment is another type of work resource. There are also material resources and cost resources. Refer to Add a resource to Project Web App to learn more about the different types of resources.

Top of Page

Gain insight into when and how many resources were used throughout the project lifecycle by analyzing the actual time that resources spent working on their task assignments. The Resource Assignments view provides time-based information useful for future planning, for example, when a resource was added to the team and when their tasks ended, and also when their peak times were during the project. In addition to seeing actual hours spent on individual tasks per time period, you can see rolled-up totals for phases or for the entire project.

This information about actual hours worked would have ideally been reported by resources through their submitted timesheets, although project managers might have entered them as well.

Select the check box next to the names of the resources whose actual time you want to research.

On the Resources tab, in the Navigate group, choose Resource Assignments .

The Gantt Chart view appears for the project assignments of each of the selected resources.

On the Assignments tab, in the Display group, choose Timephased Data .

The view changes to show Planned, Actual , and Overtime hours for each task in the project, grouped by the different resources selected. The timephased portion of the view shows the number of hours per time period.

To review summary information per time period, in the timephased portion of the view next to the project name, see the values in the rolled-up Actual and Overtime fields. To get the total actual and overtime hours for the resource on the entire project, click in the timephased portion of the view, and then press the End key to navigate to the Total field.

You can review resource reports and lessons learned summaries from a previous similar project.

Review reports

To see the Resource Overview report for the completed project, on the Quick Launch, choose Reports .

In the PWA Reports page which appears, choose your language. The three sample reports are listed.

To open the report in Excel for the web, choose Resource Overview .

To download it to your filing system, click the bubble to the left of the report name, and then, on the menu bar, choose Download . Navigate through your file system to find the location where you want to save the report, and then choose Save .

Review lessons learned

If the completed project went through a lessons learned exercise, find the summary document and see what information it has about resource types, skill sets, cost, and usage. It might be stored in the document library for the project.

In the Project Center , choose the name of the project whose lessons learned document you want to open.

In the Quick Launch, choose Documents. The Documents page for the project opens.

Find the lessons learned document and select it by clicking the bubble to the left of the filename. (If you select the filename itself, it might open the file.)

On the menu bar, choose Download .

Navigate through your file system to find the location where you want to save the document, and then choose Save .

Tip:  If you don’t find a lessons learned file in the project’s document library, contact the project manager and the resource manager if applicable. Interview them to learn what you can about their experiences with resource demand.

When you’ve analyzed previous similar projects for useful resource information, you can develop your forecasts for future projects and possibly for the portfolio of projects throughout your organization. From your analysis, create a list of resource types and their skill sets, ideally with the help of an RBS.

Then, in Project Web App for Project Online, add a new generic resource for each resource type or job title you might need in future projects. A generic resource is a resource you can add to the Project Web App resource pool that represents the job title, skill set, cost per hour or per use, and availability levels.

Add a generic resource

You add a generic resource to a team and assign it to tasks the same way you do an actual resource. The difference is that the resource is flagged as “generic,” and instead of having a name like “Darlene Sanchez,” the resource name is something like “Network Engineer.”

On the Resources tab, in the Resources group, choose New .

On the New Resources page, in the Type section, select the Generic check box.

In the Display Name box, type the generic functional name of the resource. For example, instead of a person’s name, type a title or function like Designer , Writer , or Developer .

Complete any other fields that might be useful for modeling resource requirements along with their associated scheduling and costs. For example, enter any information you might have for the Base Calendar , Standard Rate, Overtime Rate , Current Max. Units (%) , or Cost/Use fields.

Choose Save .

The new generic resource is added to the Resource Center and is now available to be added to project teams.

Note:  Generic resources often apply to people, but you can also identify generic resources for equipment and material resources.

Model an upcoming project by using generic resources

In upcoming projects, you can work with the project manager to build the team by using the set of generic resources. In this way, when modeling an upcoming project, you can forecast resource requirements and costs without artificially committing actual resources to a project that doesn’t yet exist.

In the Project Center , choose the name of the project you’re modeling.

On the Project tab, in the Navigate group, choose Build Team .

In the left table on the page, which lists your Project Online resource pool, select the check box next to the generic resource.

Between the two tables, choose Add .

On the Team tab, in the Team group, choose Save & Close .

The generic resource is now added to the current project’s team. You or the project manager can now assign tasks to this generic resource.

Replace generic resources with actual resources

When the project gets the go-ahead from the managing stakeholders, you can recruit actual resources that meet the criteria, and replace the generic resource placeholders.

Select the check box next to the name of the generic resource you want to replace.

On the Edit Resources page, in the Type section, clear the Generic check box.

In the Display Name box, replace the generic functional name of the resource with the name of the person.

Complete any other fields for which you have information. Of particular interest for scheduling, usage, and cost are the RBS , Base Calendar , Earliest Available , Latest Available , Standard Rate , Overtime Rate , Current Max. Units (%) , or Cost/Use fields.

Throughout any projects, the generic resource is replaced with the name and information of the new, actual resource, both on the Build Team page as well as in project task assignments.

During your research of historical data, if you were dismayed to find that certain categories of resource-related data were not recorded in past projects, you can start to set that right. Do what you can to ensure the following in current and future projects:

Job titles, costs, job codes, and departments are entered on the Edit Resources page for each resource.

An RBS is created and periodically updated for all skill sets and associated with all resources in the Resource Center, which is the Project Web App resource pool.

Team members update the project schedule with their actual hours from their periodic timesheets.

Every project team goes through a lessons learned exercise and uploads the summary document to the Project Web App document library for the project.

If your company has a project management organization or portfolio manager, these practices can be instituted as a standard for all projects. You can also ask your Project Online administrator to make resource fields that you identify required rather than optional.

How do I use maximum units for resources?

Add a resource to Project Web App

Sample reports in Project Online

What reporting tools can I use with project data?

Need more help?

Want more options.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Thank you for your feedback.

• Microsoft Applications
• Microsoft Training
• Microsoft Consulting
• Microsoft Support
• Microsoft Project
• Microsoft Dynamics 365
• Microsoft SharePoint
• Microsoft Power Platform
• About Integent

September 8, 2015

Microsoft project online - time phased reporting in excel.

Time Phased Reporting presents special challenges for Project Online users.  The good news is that a simple timesaving solution has been provided.

There is an entity set (essentially a table) provided called TimeSet.  This table contains a row for every date from 1984-2049. For each of these dates, fields are provided for Quarter, Month, etc:

If this table is related to any Time Phased data table (ie, MSPO_AssignmentTimePhasedDataSet), then each date with Assignment information can be presented with its week, month, etc.

Then, finally, take this information, pivot it and potentially put it in a chart:

There is one thing to note, if your data includes multiple years you will want to add a column for year.   Instructions to follow in a future post.

Note, this solution can also work well for Project Server users who are not using OLAP cubes, as Odata is available for Project Server data as well.

Related Links

• Microsoft Project Online–Time Phased Reporting in Excel part III
• Resource Engagements Coming Soon in Microsoft Project Online 2016
• Microsoft Project Online–Time Phased Reporting in Excel, part II
• Using EPM Workflow Phases and Stages with Microsoft Project Server & Microsoft Project Online in Reporting–Tips and Tricks

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Task.TimeScaleData method (Project)

• 6 contributors

Sets options for displaying timephased data for the task.

expression . TimeScaleData ( _StartDate_ , _EndDate_ , _Type_ , _TimeScaleUnit_ , _Count_ )

expression A variable that represents a Task object.

Return value

TimeScaleValues

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Was this page helpful?

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback .

Submit and view feedback for

Additional resources

Time-phased Resource Utilization and Financial Reports

Introduction

Use Time-phased resource utilization and financial resource reports to better understand past resource utilization and financials, analyze trends, and forecast future resource utilization and budgets.

The reports display data by time period, for your teams and team members.

Use the reports to:

• View target vs actual utilization for teams and individual members (planned vs actual work)
• Forecast work, cost and revenue
• Slice and dice the data to see what resources are working on

The reports utilize data from the following Clarizen items:

• Project and task assignments from the resource link (the user-Work Item link)
• Capacity as defined in user calendars
• Actual work as recorded in timesheets
• Financial metrics for labor based on hours * rates

An example chart  showing a timeline of your team’s capacity, planned work and actual work. See more chart examples .

Watch a video to get acquainted with time-phased reports.

• The data is presented in a daily time resolution, which you can group by weeks, months or quarters.
• The reports can include data from the beginning of the previous fiscal year until the end of the following fiscal year. For example, if present is July 2018, a report can include data from January 2017 to December 2019 (provided the fiscal year begins in January).

More on this page

Refreshing the Data

Time-phased data and deletions, creating a time-phased report, creating an example time-phased report, choosing related data to report on.

• Examples of Charts in Time-phased Reports
• Report Filters
• Report Templates  

Performance for Time-Phased Resource Reports

The data is automatically refreshed within a few hours after a change. However, if you are an Admin or Lite Admin and need to see updated data before a refresh, you can manually refresh all time-phased data (for all reports) up to once every hour. The refresh process can take some time. You will receive an email notifying you when the refresh is complete.

To refresh manually, click Refresh Time Phase Data in the Reports list.

Time-Phased Data is calculated data which is not stored in the database to avoid negatively affecting system performance. As a result, Time-Phased Data does not have an external ID nor is it stored in the recycle bin after it is deleted.

There are two types of deletion for Time-Phased Data :

• soft delete – records are marked as deleted in the database
• hard delete – records are deleted from the database

There are differences in how Monthly and Daily Time-Phased data are deleted:

• Monthly Time-Phased data is soft deleted only and saved indefinitely.
• Daily Time-Phased Data is soft deleted for 30 days, after which it is hard deleted.

Restoring Deleted Time-Phased Data

If a soft-deleted record is restored, it retains the same object ID. If a hard-deleted record is restored, it is assigned a new object ID.

For example, if a resource assignment is removed from a task, it is soft deleted (marked as deleted) in the database. After 30 days, the soft deleted resource assignment is hard deleted. If the resource assignment is later reassigned to the task, it is restored with a new object ID.

Note:  To create Resource Utilization reports, the  Enable Resource Utilization Reporting system setting (under Resource Management Settings ) must be enabled. After enabling the setting, it can take up to 24 hours until Resource Utilization data becomes available in reports.

Build time-phased reports from scratch or use out-of-the-box report templates created by Clarizen .

The following procedure explains the required additional steps for creating a time-phased report.

To learn more about how to create reports, click here .

To create the report:

• Create a new report in Clarizen.
• Time-phased reports are based on Time-Phase attributes:
• Labor Time Phase Data - Data based on the resource link (between the user and the Work Item) and timesheets

• Add highlights to your report. Click here to learn more about creating charts.
• Add charts to your report. See the example below to learn more about creating time-phased charts.
• In the Table  section, add a basic table with columns, or use a crosstab format with time periods as headers, and repeating columns with time-phased data. Continue with Adding a Basic Table or Adding a Crosstab Table .

Adding a Basic Table

• The rest of the procedure is the same as for other reports, and includes adding charts, using formulas, etc. See  Creating an Example Time-Phased Report .

Adding a Crosstab Table

Benefits of the crosstab format include: 

• View and analyze more data in a readable format, with repeating columns and option for leading columns
• More flexibility for grouping variables (mainly time periods)

If you use Monthly time-phased data, then:

 - The available units are Month(s) and Quarter(s)  - The actual date range displayed in a report will be:   - In the Following - from the first day of a current month until the end of the last month in the range   - During the Previous - from the first day of the first month in the range until the last day of the previous month

If you use Daily time-phased data, then:

 - The available units are Day(s) and Week(s)  - The actual date range displayed in a report will be:   - In the Following - from the current date until the last day in the range (not included)   - During the Previous - from the first day in the range until the current date (not included)

• Click  Leading Columns  (enabled only if you selected Item ID in  Grouping ) . You can now select fields related to the Identifier-type fields selected in the previous step, to appear as leading columns. Add up to 16 leading columns. 
• Click Crosstab Columns to select up to 8 repeating columns.
• Set Totals as needed.
• Select the Wrap column titles checkbox.
• Select Freeze columns to freeze the first column and leading columns, useful for horizontal scrolling with lots of columns.

The following procedure describes how to create a report with a line chart that shows us how our team is performing, by comparing their capacity, project and task assignments, and actual work.

• Create a new report.

• This combination should be used whenever you want to see all users, their capacity, their planned work, and their actuals.
• Chart Type: Line
• X-Axis: Select Capacity Time Phase Data Fields > Date Group by Month
• Y-Axis: Select Sum to display the total number of hours of all users
• Select Multi-dimensional grouping.
• Select Capacity Time-Phased Data Fields and then the related data. For the first line, select Capacity Time-Phased Data Fields > Capacity
• For the second line, select Capacity Time-Phased Data Fields > Labor Time Phase Data > Project Assignment

• Customize the related data table. As for all reports, you can choose which columns to include, define grouping, select the format of the column summary, etc.
• Save and run the report.

The line chart

The Data table

Tip: Add some conditional formatting, so that the Project sum displays in red when it’s above capacity, and green when less. 

The following diagrams illustrate how to match related data with use cases.

User > Capacity > Labor Time Phased Data

Select the attributes listed in the diagram below to include all users, regardless of if they have work or not, and only Work Items with assigned users appear in the report.

User > Labor Time Phased Data

Select these attributes when the report is more work-focused, without the need for capacity.

Work item > Labor Time-Phased Data Start from Work Item when you want to see forecast or planned vs. actual at the project level. All Work Items are included.

Only users with assigned work appear in the report.

Work item > Financial Resources Start from Work Item and then the required financial data.

Note: We recommend adding a special filter to display financial resources either in an aggregated, or direct form when using financial time-phased reports. This is to avoid seeing duplicate results.

To add the filter when using Financial Resources as related data (1), add the Time Phased Data Fields parameter (2 + 3). Then choose the Aggregated filter (4+5). Then set this filter to TRUE or FALSE, depending on if you want to see aggregated or direct resources:

Examples of Charts

View current (to date), past and planned utilization for your team using gauges.

  See where your teams are spending their time, based on Work Item categories.

View your team’s utilization by Job Title.

Compare the financial performance of your team over time.

View individual resource utilization.

Best Practices

• Resource Utilization
• Use formula-based totals for crosstab columns in your report. This is especially useful in crosstab reports with groupings. See more in  Working With the Results Table .
• Planned Project Utilization: If(IsNull($CapacityOfUserDaily.LoadFor.LinkObject.ProjectAssignment),0,($CapacityOfUserDaily.LoadFor.LinkObject.ProjectAssignment/$CapacityOfUserDaily.Capacity)*100)
• Actual Utilization: If(IsNull($CapacityOfUserDaily.LoadFor.LinkObject.ActualApproved),0,($CapacityOfUserDaily.LoadFor.LinkObject.ActualApproved/$CapacityOfUserDaily.Capacity)*100)

We recommend defining filters for reports. This allows you to focus only on relevant data and improves performace with faster loading times. Click here to learn more about creating filters. There are two things you need to bear in mind when settings filters for time-phased reports:

Dates in Report Filters and Data Table

It is recommended to use the same date ranges in Filters and the data table, to avoid conflicts in the report data. 

Unassigned Resources

When filtering the report on labor-related items, unassigned resources are automatically excluded and will not appear in the report.

Report Templates

You can use our report templates to help you get started. You can find the templates under the Resource Utilization and  Financials  report folders.

Note: Unlike other report templates in Clarizen, the templates for Resource Utilization and Financial reports are visible by default to admins only. To make the templates visible to additional users, an admin must update the viewing/editing permissions for these templates accordingly. 

The following templates are available.

Resource Utilization Reports

Resource utilization dashboards.

Financial Reports

We have improved the performance and reduced calculation times for time-phased resource reports.

Calculations are now performed for a 3-year period, from the beginning of the previous year until the end of next year. Results outside the calculation timeframe will not be recalculated or updated.

What is Timephased data?

Time Phased refers to a task, resource, or assignment information that is distributed over time. You can review time phased information in any available time period in the fields on the right side of the Task Usage and Resource Usage views.

• Skip to primary navigation
• Skip to main content
• Skip to primary sidebar
• Skip to footer

Ten Six Consulting

Project and Earned Value Management, Primavera P6 & Deltek Cobra & Acumen Services

Reporting Time-Distributed Data in P6

April 29, 2024 By TheP6Pro

Schedulers can create time-distributed data in P6 for the initial planning baseline and a real-time snapshot. This snapshot is the project data at a specified time, e.g., the end of the first month’s reporting period. The time-distributed reporting feature outputs time-phased schedule data for selected Time Interval Fields.

In this way, the scheduler can report Time Interval Field data for a date interval such as Day, Week, Month, or Year for the project’s life.

This article demonstrates using the report wizard to generate time-distributed data in P6.

In Figure 1, our demonstration project includes a baseline and two months of reported progress.

We want to produce a tabulated monthly project report that is time-distributed. We proceed and create a time-distributed monthly report showing resource hours (units) in a time-phased table. The following are instructions on this process:

In our demonstration, we want to place our Wellmont Substation reports in the Substation Project Reports group.

• Select the Substation Project Reports Report Group to store the report, Figure 2, and choose Edit | + Add.

• Click next in the Create or Modify Report Wizard dialog box.
• Toggle on the Time Distributed Data option in the Select Subject Area dialog, Figure 3.

Note : The selection of this option filters the list to display only time-distributed subject areas.

• Choose the subject area for the Activity Resource and Role Assignments, Figure 4.

• Click next.
• In the Configure Selected Subject Areas, click the Columns… button.

• Add and locate Budgeted Units at the bottom of the list, composing Activity ID, Activity Name, Start, and Finish, Figure 6.

• Below the Columns button, choose the Group & Sort button and set it up as follows:
• Confirm the Group By field is set to Resource ID Name.
• Change the font color of the Group By fields to black.
• Set the Show Group By Options to ID/Code.
• Set the Show Totals to ‘Bottom’.

• Click Next.
• In the Date Options dialog box, choose the Timescale button.

• Confirm the Date Interval is set to Month.

• For the remaining options in this dialog, keep the defaults.
• Click on the Time Interval Fields… button.

• In the Fields dialog, add the selected options Budgeted, Actual, and remaining Units, as shown in Figure 11.

• Enter a suitable title for your report.

• In the Report Generated dialog box, uncheck the Format Numbers option and click Run Report.

• Confirm Print Preview is on and click OK to run the report in the Report Previewer, Figure 14.

The output for the Foreman resource in the report should appear as follows: Figure 15.

• Close the report.
• Save the Report by clicking the Save Report button.

• click OK when the below dialog appears.

• Click Previous.
• Click Run Report.
• Toggle on Delimited Text File and click OK.

The spreadsheet and Foreman resource time-distributed data appear as follows:

The activity percent complete of the Project Management effort through the end of February is calculated as follows:

The original and remaining duration of the project management effort are shown in Figure 1. The equation then computes as follows:

The Foreman Actual Labor Units during this period is as follows:

Using the reports feature, schedulers can generate time-distributed data in P6 throughout the project’s life. The scheduler can then tabulate respective time interval fields for each reporting period or other intervals in the schedule.

These time interval fields include budgeted, actual, and remaining labor units. In this way, the scheduler reports resource allocation and usage at the end of each reporting period, including weekly and monthly intervals.

Furthermore, there are numerous Time Interval Field options for cumulative time-phased reporting.

Upcoming Classes

• Join Our Mailing List
• Email This field is for validation purposes and should be left unchanged.
• Primavera P6 Training
• Deltek Training
• Earned Value Management Training
• Project Management Training
• Open Training Class Dates
• Scheduling Services
• RFP Support
• Your EVM System
• Certification
• Data Analysis and Reporting
• Post Contract Support
• Staff Augmentation
• WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
• Knowledge Transfer, Mentoring and Coaching
• BI Publisher Services
• Primavera Unifier
• Knowledge Transfer, Coaching and Mentoring
• Microsoft Project to Primavera P6 Conversion Services
• Building an Integrated Master Schedule (IMS)
• Integrating Microsoft Project with Deltek Cobra
• Migrating From Microsoft Project To Oracle Primavera P6
• Deltek Acumen
• Deltek Cobra
• Earned Value Mgmt
• Microsoft Project
• Primavera P6
• Project Management
• Risk Management

Assignment TimePhasedData Issue

The attached files have a single assignment. I am creating an assignment object for the single assignment, and reading the TimePhasedData array property.

The array returned does not match my expectations. Not sure if this is a bug or an incorrect expectation and would like clarification.

Project 1 File: Expected Result: PT24H0M0S, PT24H0M0S, PT24H0M0S Aspose Result: PT48H0M0S, PT48H0M0S, PT48H0M0S, PT48H0M0S, PT48H0M0S

Project 2 File: Expected Result: PT24H0M0S, PT12H0M0S, PT24H0M0S Aspose Result: PT48H0M0S, PT24H0M0S, PT48H0M0S

I believe this is a defect, since the Aspose results are inconsistent with each other, since both assigments are for 3 days.

In the first project, there are 2 extra time phases, and the hourly amounts are double expectations.

In the second project, there are thre correct number of phases, but the hourly amounts are still doubled.

Dear Kevin,

At the moment, you can read time phased data from XML files only. Reading time phased data from MPP files is not supported but a request in this regard has been logged into our issue tracking system as TASKS-15911 . We will keep you updated on this issue in this thread.

Please feel free to contact us in case you have further comments or questions.

Best Regards,

The issues you have found earlier (filed as TASKS-15911;TASKS-33124) have been fixed in this update .

The issues you have found earlier (filed as ) have been fixed in this Aspose.Words for JasperReports 18.3 update .

• Oracle Primavera Cloud REST API
• Scope Assignment Baseline Time Phased Data

View Scope Assignment Baseline Time Phased Data

/api/restapi/baselineTimePhasedData/{scopeAssignmentBaselineTimePhasedDataId}

• The object has an ID that matches the value of the {scopeAssignmentBaselineTimePhasedDataId} path parameter.
• scopeAssignmentBaselineTimePhasedDataId(required): integer(int64) The system-generated identifier of baseline time phased data.

There's no request body for this operation.

• application/json

200 Response

• scopeAssignmentBaselineTimePhasedDataId
• baselineHours(required): number (double) Revised hours at the time the baseline was set.
• baselineUnits(required): integer (int64) Revised quantity at the time the baseline was set.
• date(required): string (date-time) Date used for updating the dates of scope assignments and work packages when they are not linked to activities.
• link: string (url) Read Only: true The self-link to the object. This field is populated only in the responses generated by the batch create APIs.
• scopeAssignmentBaselineTimePhasedCostData: scopeAssignmentBaselineTimePhasedCostData An object containing the cost fields associated with the baseline time phased data.
• scopeAssignmentBaselineTimePhasedDataId: integer (int64) The unique identifier of baseline data. This value should not be provided in create operation request data, however, it is required for update requests.
• scopeItemAssignmentId(required): integer (int64) The unique identifier of a work package.
• updateDate: string (date-time) Read Only: true Date when the record was last updated.
• object ApiEntityScopeAssignmentBaselineTimePhasedCostData Title: ApiEntityScopeAssignmentBaselineTimePhasedCostData
• baselineCost(required): number (double) The Revised Cost at the time the current baseline was set. This field is in base currency and is calculated from baselineCostProject field based on the specified exchange rate.
• baselineCostProject: number (double) The Revised Cost at the time the current baseline was set. This is the cumulative value for all scope assignments in the work package. This value is based on the project currency.
• scopeAssignmentBaselineTimePhasedDataId(required): integer (int64) Time phased baseline data ID.

404 Response

Scope Assignments

View the time phased distributed data for work package scope assignments to analyze quantity, hours, and cost. Set the curve profile to distribute time phased data for scope assignments according to a specified nonlinear curve.

Distribute Hours and Quantities for a Scope Assignment Per Timescale Interval

Review the Time Phase Distribution for a Scope Assignment

Scope Assignments: Time Phase Fields

Last Published 7/17/2024

Last Published Wednesday, July 17, 2024