Skip to content

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:

  1. Go to CALUMO Admin > Settings > Feature Settings
  2. 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
Back to top