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 to True

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