Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager Version 7.1
This article is focused on using the Column Splitting feature with OnePager Bundle Standalone and imported Oracle Primavera P6 source plans.
About Splitting and Parsing Fields
The OnePager column splitting feature allows you to duplicate task bars when a task in your Oracle Primavera P6 source plan is assigned to multiple resources (or anything else). Because assignments from Oracle Primavera P6 found in the Resources tab in the Project Activities screen, this feature enables OnePager to access the resources list and create a unique task bar for each instance in the Resources tab.
Split Resource Names Example
Say you want to use color-codes on task bars/milestone symbols based upon your Oracle Primavera P6 source plan’s Resources as shown below:
The entries in the Resources table above consist of multiple, individual row items. Without the column splitting feature, a chart created from these data and assigned task bar/milestone symbol colors based upon the Resources table for this Activity looks like this:
OnePager, in this case, treats the entries in the Resources table as an individual Resource value. To provide more flexibility in displaying task bars that have multiple resources assigned, OnePager supports the concept of a column splitting. This feature recognizes multiple resource values in a Activity and creates a separate task bar for each of the Resource table entry values associated with the Activity.
To use this feature requires turning ON the feature in the Oracle Primavera P6 Template Properties form you intend to use to make the chart. The setting must be turned ON before the chart is created so launch OnePager Bundle from the desktop icon, click the NEW button on the OnePager Bundle Start form to access the OnePager choices form, select your Smartsheet source plan, and type in the chart's title as shown here:
When you click the Next> button at the bottom of the form, OnePager accesses the second page of the OnePager choices form shown below:
Clicking the Edit current template button accesses the current Template Properties form. Navigate to the Field Mappings tab on the form, check the Enable splitting on: checkbox to ON and (in this example) select the Resources column from the dropdown list provided. The results are shown here:
Click the Save and use button to complete the process and close the current Template Properties form returning you to the second page of the OnePager choices form show above.
Split Resources in the Chart
Clicking the Create new chart button completes the process and creates the chart with the column splitting feature in use. The chart with splitting looks like this:
In the chart with column splitting shown above, there are now more task bars in the Chart Editor than there were before. The task bar for Mechanical Engineers is now split into three (3) separate task bars, one for each of the three resources assigned. Each of the resources has a unique color assigned. Each of the resources appears by itself in the Legend. The Legend title shows the column name that is used for splitting the columns.
With this feature, you can use column splitting just like any other column by using the dropdowns in the Template Properties form or Chart Properties form to assign colors, highlight task bars and milestone symbols, and to define and label rows and swimlanes.
Splitting Resources and Task Links
When task bars with Data-Driven or manual Task Links are split, the Task Links (Data-Driven and manual) are not shown. Further, the Task Links that are now hidden and do not have entries in the Where are My Links? form.