Formula Batch Processing¶
Overview¶
What is Batch Processing?¶
When working with large Excel reports containing many formula cells, CALUMO can process them in smaller batches to improve performance and prevent timeouts.
Why Use Batch Processing?¶
Large Excel reports with CALUMO formulas (especially CGETMDX) can cause timeout errors when calculating all at once. Batch processing solves this by:
- Breaking large calculations into smaller pieces
- Preventing timeout errors on reports with 200,000+ cells
- Improving reliability for high-volume data reports
- Allowing users to see progress during long calculations
Setup and Configuration¶
How to Enable¶
Administrators can turn on this feature:
- Go to CALUMO Admin > Settings > Feature Settings
- Set
Excel Batch: Enable Formula Batching
toTrue
Settings¶
Excel Batch: Batch Size¶
- What it does: Controls how many cells are processed at once
- Default: 10,000 cells per batch
- Note: Higher numbers = faster processing, but may cause timeouts
Excel Batch: Max Cells Per Batch¶
- What it does: Sets the total limit of cells that can be processed in one report
- Default: 2,000,000 cells
- Note: Reports with more cells than this limit will show an error message
User Experience¶
How It Works¶
For Users¶
When you recalculate a large report, you’ll see: - A progress bar showing calculation status - Current batch information (e.g., “Batch 1 of 5”) - Total number of cells being processed - Option to cancel if needed
Progress Display¶
When batch processing is running, users will see:
- Progress message: Shows which batch is currently processing
-
Example: “Processing CGetMDX batch 5 of 10 (5,000 out of 10,000 cells processed)”
-
Cancel button: Allows users to stop the processing
When Reports Are Too Large¶
If a report has too many cells:
- A warning dialog will appear showing:
- How many cells were found
- The current limit