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 most comprehensive and battle-tested Essbase automation available. Oracle has nothing comparable — no comprehensive automation, no orchestration, no mutual exclusion, no sophisticated error handling.
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
Encrypted credentials stored in one secure location with role-based access control. No more passwords scattered across scripts.
Immediate Error Detection
Timestamped logging with automatic notifications. Know instantly when a calculation fails, a load errors, or an application stops.
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 fills this critical gap with enterprise-grade capabilities built from extensive real-world production experience.
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."
Ready to Automate Your Essbase Environment?
Enterprise EPM automation that Oracle doesn't offer.
Contact Blue Isle Software