Loading
Connect in real time with the Trailblazer Community in Slack Open BetaRead More
Workflow of the Account Hierarchy Forecast Prebuilt App

Workflow of the Account Hierarchy Forecast Prebuilt App

Review the high-level workflow of the Calculate Forecasts for Accounts in a Hierarchy prebuilt app.

Required Editions

Available in: Enterprise, Unlimited, and Developer Editions.

Business Requirement and Personas

Multiple accounts can be related to each other in a hierarchical structure. For example, Neo Dealers US is a parent account with two child accounts: Neo California and Neo Dallas. Each of these accounts can in turn have their child accounts. For example, the Neo California account can have child accounts Neo San Jose and Neo San Diego.

The Calculate Forecasts for Accounts in a Hierarchy prebuilt app allows companies to generate and calculate forecast for each account, and then roll up the calculated values of all child accounts to their parent account. So, the Neo California account shows rolled up forecast values for both the Neo East California and Neo West California accounts. And, the Neo Dealers account shows rolled up forecast values for both the Neo California and Neo Dallas accounts.

While country managers focus more on forecasts at a parent account level, regional managers are more concerned about the account forecasts specific to their cities or territories. And account managers typically only focus on the forecasts for a few key accounts they manage. A country manager would look at the aggregate forecast data for the Neo Dealers US account, a regional manager looks at the aggregate forecast data for the Neo Dealers California account, and an account manager looks at the forecast for the Neo San Diego account.

Packages and Components

Two packages are available for the Calculate Forecasts for Accounts in a Hierarchy prebuilt app.

The Account Hierarchy Custom Fields and Permissions package contains the following components that you can deploy in your Salesforce org:

Component Type
AcctHierAAFAdjustmentTriggerHandler Apex Class
AcctHierAAFAdjustmentTriggerHandlerTest Apex Class
AdvancedAccountForecastFactTrigger Apex Trigger
Account Hierarchy Based Forecasting Permission Set
Parent Account (added to the Advanced Account Forecast Fact object) Custom Field
Child Account (added to the Advanced Account Forecast Fact object) Custom Field
Country Manager Amount (added to the Advanced Account Forecast Fact object) Custom Field
Country Manager Quantity (added to the Advanced Account Forecast Fact object) Custom Field
Regional Manager Quantity (added to the Advanced Account Forecast Fact object) Custom Field
Regional Manager Amount (added to the Advanced Account Forecast Fact object) Custom Field
Adjusted Amount (added to the Advanced Account Forecast Fact object) Custom Field
Adjusted Quantity (added to the Advanced Account Forecast Fact object) Custom Field
ChildAccount (mapped to the Account object) Advanced Account Forecast Dimension Source
ParentAccount (mapped to the Account object) Advanced Account Forecast Dimension Source
Product (mapped to the Product2 object) Advanced Account Forecast Dimension Source

The Account Hierarchy DPEs and Forecast Set package contains the following components that you can deploy in your Salesforce org:

Component Type
AccountHierarchyBasedForecastSet Advanced Account Forecast Set
SampleAccountHierarchyForecastPeriodGroup Advanced Account Forecast Period Group
Generate_Forecasts_Based_on_Account_Hierarchy Batch Calculation Job Definition
Recalculate_Forecasts_Based_on_Account_Hierarchy Batch Calculation Job Definition
Rollover_Forecasts_Based_on_Account_Hierarchy Batch Calculation Job Definition

Permissions and Access

You must enable the following features in your org to use the deployed prebuilt app:

  • Sales Agreements
  • Data Pipelines
  • Advanced Account Forecasting

You must assign the following permissions to the users who use this prebuilt app:

  • Data Pipelines Base User
  • Manufacturing Sales Agreements
  • Manufacturing Advanced Account Forecasting
  • Account Hierarchy Based Forecasting (you get this permission set as part of the package you deploy)

Forecast Set and Data Processing Engine

Clone the following Data Processing Engine templates to create definitions that you can use in a forecast set:

  • Generate Forecasts Based on Account Hierarchy
  • Recalculate Forecasts Based on Account Hierarchy
  • Rollover Forecasts Based on Account Hierarchy

You can customize the definitions as per your business requirements. Activate the definitions.

Add the definitions to the Account Hierarchy Based Forecast Set.

Customize the forecast set as required by adding other dimensions, forecast adjustment periods, and measures.

Three measure groups are available in the forecast set by default to be used by country managers, regional managers, and account managers.

You can run the generation Data Processing Engine definition to generate forecasts for all child accounts and aggregate the data at the parent levels.

At the start of each forecast period, you can also use the rollover Data Processing Engine definition to expire the forecast for a past period and add a new period to the display.

You can also run the calculation Data Processing Engine definition to calculate forecasts whenever there are new products added or when the measure values change.

 
Loading
Salesforce Help | Article