Backlog 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 Backlog flow.

Dataflow Nodes Related to the Backlog Dataset

Dataflow Node	Description
BacklogDetailConverted_Currency_FILTER	Matches the currency ISO code associated with a backlog detail converted record with the Integration User currency.
BacklogDetailCalculation_HasProject_FILTER	Only allows backlog calculations associated with a Region, Practice, or Group.
BacklogDetail_FirstLevelProject_FILTER	Ensures that only records associated with the top-level Project are included. Note: Only data for top-level projects is displayed in the PS Cloud Analytics Billings dataset.

Calculated Fields

These are the fields calculated by the Backlog flow.

Calculated Fields Created for the Backlog Dataset

Field	Value
HasProject	Identifies whether or not a record has an associated project. If the record has a project associated the HasProject value equals "Yes", else the value is "No". PS Cloud Analytics uses this calculation to differentiate between records.
ProjectRPGType	Identifies if a project is associated with a "Region", "Practice", or "Group".
ProjectRPGHierarchyDepth	This calculation stores the hierarchy depth of the RPG associated with the project.
BacklogCalculationRPGType	Identifies if a backlog calculation is associated with a "Region", "Practice", or "Group".
BacklogCalculationRPGHierarchyDepth	Stores the hierarchy depth of the RPG associated with the backlog calculation.
BacklogDetailRPGType	Identifies if a backlog detail is associated with a "Region", "Practice", or "Group".
BacklogDetailRPGHierarchyDepth	Stores the hierarchy depth of the RPG associated with the backlog detail.
BacklogType	Assigns the "Backlog" backlog type to backlog records that have a time period type other than "perpetual". If the backlog records have a time period type of "perpetual" then this calculation assigns the "Unscheduled Backlog" backlog type to those records.
ValueBacklogAmount	Depending on the backlog type assigned to a backlog record by the BacklogType calculation: If the backlog type is "Backlog" then the ValueBacklogAmount is the sum of the time revenue plus the milestone revenue fields. If the backlog type is "Unscheduled Backlog" then the ValueBacklogAmount is the unscheduled revenue field amount.