Calculation
Execute calc scripts with dynamic parameter substitution. Run server-side or inline calculations.
Battle-Tested
InTouch Essbase Tool
Enterprise EPM Automation That Oracle Doesn't Offer
Decades of 24/7/365 Production Reliability
The old paradigm is out. The new paradigm is AI. AI automation is InTouch AI — and Essbase is just one thing a general AI-native engine runs. A purpose-built EPM scripting tool can never grow an AI core. This one was born with one.
The most comprehensive and battle-tested Essbase automation available. Oracle has nothing comparable — no comprehensive automation, no orchestration, no mutual exclusion, no sophisticated error handling. And here's the part the config-era tools can't follow: a general AI-native engine does everything a specialized Essbase tool does, and then keeps going. The reverse is impossible. You can't bolt an AI center onto a calc-script runner.
Proven ROI: Save 2 FTEs Annually
One customer estimates saving two full-time employees per year through InTouch Essbase automation. When their Essbase expert left the company, automated processes kept running without disruption — no emergency hiring, no scrambling to understand scripts. The processes just kept working.
Key Benefits
Centralized Security
AES-256 encrypted credentials referenced by name, never written into a script, never exposed — not even to the AI itself. Role-based access on top. No more Essbase passwords scattered across MaxL files. This is the trust floor every operation runs on.
Immediate Error Detection
Timestamped logging with automatic notifications. Know instantly when a calculation fails, a load errors, or an application stops. The old "doesn't-work" clause was a dumb rule — retry twice, email a log. Now it's an assessment: InTouch reads the failure, knows why, smart-retries, refreshes an expired credential, and surfaces the one sentence that matters. It broke. Here's why. I fixed it. No calc-script wrapper can say that.
Non-Stop Operations
Continuous "chase its tail" workflows run 24/7/365 with intelligent mutual exclusion to prevent conflicts during backups and maintenance.
Battle-Tested Reliability
Decades of production use at major enterprises. Mission-critical monthly closes, daily integrations, and continuous planning cycles.
Oracle Has Nothing Comparable
Oracle does not provide comprehensive automation, orchestration, mutual exclusion, or sophisticated error handling for Essbase. InTouch AI fills this critical gap with enterprise-grade capabilities built from extensive real-world production experience. AI isn't a feature stapled to the side here — it's the architecture. The vault, the scheduler, the orchestration, the audit trail all sit behind it. That's why a single engine runs Essbase, your databases, your files, and your APIs in one workflow, while the config-era incumbents stay frozen at the boundary of the one system they were built for.
9 Comprehensive Essbase Operations
Dimension Build
Build dimensions from file or SQL sources. Update hierarchies and outlines automatically.
Load Data
Load from files or SQL. Clear data/regions, delete aggregates. BSO and ASO support.
Export Data
Export all levels, zero-level, or input-level data. Columnar output option for spreadsheet compatibility.
Report
Execute report scripts with parameter substitution. Generate formatted output for distribution.
MaxL
Execute MaxL administration statements. Automatic login and logout session management.
Start Application
Start Essbase applications and enable user access. Coordinate with workflow dependencies.
Stop Application
Gracefully stop applications with access disabled. Use before backups or maintenance.
Update Variables
Update substitution variables programmatically. Automate period rolls and scenario changes.
Why InTouch Over Manual Scripts?
| Capability | Manual Scripts | InTouch Essbase Tool |
|---|---|---|
| Centralized Security | Plaintext passwords in scripts | AES-256 encrypted, centralized, RBAC |
| Error Detection | Silent failures, manual log checking | Automatic detection and notification |
| Scheduling | external scheduler | Visual scheduler with triggers |
| Cross-System Workflows | Custom glue scripts | Native multi-system orchestration |
| Logging & Audit | Manual, inconsistent | Timestamped, searchable audit trail |
| Mutual Exclusion | None — conflicts happen | Intelligent lock management |
| Maintenance Burden | Grows with every script | Centralized, visual management |
| Continuous Operation | Complex scripting required | Built-in "chase its tail" mode |
Use Cases
- Monthly Financial Close — orchestrate the complete close process: stop applications, load data, build dimensions, run calculations, generate reports, restart applications
- Continuous Data Processing — "chase its tail" trigger-on-completion for non-stop data processing cycles
- Backup Coordination — intelligent mutual exclusion ensures backups don't conflict with running calculations or data loads
- Multi-Source Data Loading — load data from multiple databases and files with proper sequencing and error handling
- Planning Cycle Management — automate period rolls, variable updates, and calculation sequences for planning cycles
- Error Recovery — automatic retry with backoff logic, notification escalation, and fallback procedures
Technical Specifications
Supported Versions
Oracle Essbase (all modern versions)
Operations
9 comprehensive operation types
Credential Management
Centralized, encrypted, role-based access
Storage Types
BSO and ASO
Scheduling
Visual workflow designer with triggers
Error Handling
Immediate notification with detailed logs
Mutual Exclusion
Prevent conflicts during maintenance
Continuous Operation
"Chase its tail" trigger-on-completion
"When our Essbase expert left, we didn't panic. The automated processes kept running without missing a beat. That's when we truly understood the value of InTouch AI."
Ready to Automate Your Essbase Environment?
Enterprise EPM automation that Oracle doesn't offer — running on a general AI-native engine that outgrows every specialized tool it replaces.
Contact Blue Isle Software