Loading
 Experience Cloud – Feature Degradation on Lightning Web Runtime SitesRead More
The Trailblazer Community is now read-only Read More
Considerations for Program Based Business When Processing Large Volumes of Data

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
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
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.
 
Loading
Salesforce Help | Article