Considerations for Program Based Business When Processing Large Volumes of Data
Program Based Business uses Data Processing Engines to generate manufacturing program
component forecasts. The data volumes in the manufacturing program forecast fact, manufacturing
program variant forecast fact, and manufacturing program component forecast fact records play a
crucial role in determining the time taken to generate these forecasts.
Required Editions
Available in: Lightning Experience
Available in: Enterprise, Unlimited, and Developer
Editions
The number of forecast fact records is a scalar multiple of all relevant dimensions. For
example, the number of manufacturing program forecast fact records is 50*10*36*3 = 54000, for a
manufacturing program with these values:
Manufacturing program records: 50
OEM products, for example, cars: 10
Product variant SKUs, for example, Alpha, Gamma, Delta: 80
Program Component SKUs, for example, engines: 10
Periods: 36
Locations: 3
For the above manufacturing program, the number of manufacturing program variant forecast fact
records is 50*80*36*3 = 432,000, and the number of manufacturing program component forecast fact
records is 50*80*10*36*3 = 4,320,000.
Note
The forecast formula baseline calculation has a significant impact on the time taken to
calculate forecasts.
The out-of-the-box forecast fact objects support higher data volumes compared to custom fact
objects.
Keep these limits in mind when using Program Based Business. The standard fiscal calendar is
used to come up with these recommendations.
Type
Recommended Limit for Small Orgs (Up to 4 million records)
Recommended Limit for Large Orgs (Up to 55 million records)
Manufacturing Programs
50
150
Products
100
200
Periods
36
60
Manufacturing Program Forecast Facts
54000
450000
Manufacturing Program Variants
432000
5850000
Manufacturing Program Components
4320000
58500000
Product Related Materials
40000
195000
Note To load large volumes of data, the manufacturing program grid may take more than two
seconds.
Best Practices
These are some of the best practices for using Program Based Business.
When processing large volumes (for example, 60 million records), split the data into smaller
batches based on criteria such as region, manufacturing program, product, or product
category.
For Data Processing Engines, an export capacity of 1 GB of CSV file data per day is included
in an org. For out-of-the-box Data Processing Engine templates, this capacity translates to
2.67 GB for 9 million records, and therefore, you can process up to 3 million forecast fact
records in a single day with one org. To process more than 3 million records in a day, purchase
additional processing capacity by using the Salesforce Data Pipelines AddOn license.
Archive or purge the forecast records that you no longer need.
Did this article solve your issue?
Let us know so we can improve!
Loading
Salesforce Help | Article
Cookie Consent Manager
Cookie Consent Manager
General Information
Required Cookies
Functional Cookies
Advertising Cookies
General Information
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.