AI Features
Captain EPM leverages advanced Generative AI to boost your productivity. Our built-in assistants understand your metadata, Essbase calculations, and application logs.
Calc Generator (Rule Advisor)
Stop writing complex Essbase calculations from scratch. With the Rule Advisor, you can describe what you need in plain English.
Example: "Write an Essbase calc to allocate rent expense across all level 0 descendants of Department based on Headcount, clearing the target first."
The AI will generate the MDX or Groovy script, complete with syntax highlighting and explanations, directly inside the task pane.
Log & Activity Chat Analysis
Upload large, messy activity reports or job logs and talk to them. You can ask the AI to find anomalies, summarize errors, or extract specific time ranges without having to manually parse thousands of lines of text.
Context-Aware Diagnostics
Right-click on any cell in your Excel sheet to trigger AI-powered diagnostics tailored to the cell's content:
- Analyze Data Block: The AI extracts the intersection and checks Essbase block statistics to detect sparsity issues.
- Lookup Object: Instantly fetch metadata properties for a specific dimension member.
- Explain Variance: Highlight a variance cell, and the AI will summarize the key drivers behind the number based on the surrounding data.
Predictive Analytics
Generate future predictions based on historical cell data selections.
- Select at least two consecutive cells containing historical data in Excel.
- Click Predict in the Captain EPM ribbon.
- The AI will analyze the trend and generate forecasted values, which you can insert directly into your planning sheets.
Metadata Analyzer
A deep diagnostic tool to analyze your application hierarchies and properties.
Powered by AI, the Metadata Analyzer scans your hierarchy structure to detect anomalies, missing attributes, or poorly optimized dimension setups, giving you actionable insights without manual inspection.