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 Nodes Related to the Utilization Dataset

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.

Calculated Fields Created for the Utilization Dataset

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.