Utilization Flow Intermediate Processing

After importing the input fields and augmenting them with the data from their lookup objects, the PS Cloud Analytics dataflow filters out non-relevant or repeated records.

You can use the dataflow editor in Analytics Studio to visualize the PS Cloud Analytics dataflow and its nodes. Alternatively, you can download the dataflow definition file which is a JSON file representing the dataflow and its logic. For more information on the dataflow editor and the dataflow definition file, see Configure the Dataflow in the Salesforce Help.

Warning:

Modifying the PS Cloud Core Analytics dataflow might result in the loss of functionality. Contact your system administrator before using the data manager tool in Analytics Studio.

Dataflow Nodes

These are the main dataflow nodes in the Utilization flow.

Dataflow Node

Description

utilization_details__FILTER This filter matches records with an associated time period.

Calculated Fields

These are the fields calculated by the Utilization flow.

Field API Name

Description

HasResource Identifies if a record has a resource associated.
ValueActualHours Calculated by the sum of the Utilization Detail object Historical Billable Hours plus Historical Credited Hours plus Historical Excluded Hours plus Historical Non-Billable Hours.
ValueBillableHours Calculated by the sum of the Utilization Detail object Historical Billable Hours plus Historical Scheduled Billable Hours plus Scheduled Billable Hours.
ValueScheduledHours Calculated by the sum of the Utilization Detail object Scheduled Billable Hours plus Scheduled Credited Hours plus Scheduled Excluded Hours plus Scheduled Held Hours plus Scheduled Non-Billable Hours.
ValueHistoricalScheduledHours Calculated by the sum of the Utilization Detail object Historical Scheduled Billable Hours plus Historical Scheduled Credited Hours plus Historical Scheduled Excluded Hours plus Historical Scheduled Held Hours plus Historical Scheduled Non-Billable Hours.
UtilizationStartDate This is the Historical Start Date if this field is not null. Else, this is the Scheduled Start Date.
UtilizationEndDate This is the Scheduled End Date if this field is not null. Else, this is the Historical End Date.
ValueCreditedHours Calculated by the sum of the Utilization Detail object Historical Credited Hours plus Scheduled Credited Hours.
ValueCalendarHours Calculated by the sum of the Utilization Detail object Historical Calendar Hours plus Scheduled Calendar Hours.
ValueExcludedHours calculated by the sum of the Utilization Detail object Historical Excluded Hours plus Scheduled Excluded Hours.
RPGType Identifies whether the record is associated with a region, practice, or group.
RPGHierarchyDepth The hierarchy depth value of the RPG.