You are here:
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.
