Analytics Catalog/Oracle EPM
Oracle EPM Cloud · Catalog
Oracle EPM analytics, owned
Planning, consolidation, reconciliation, and the rest of EPM Cloud live in Essbase cubes with no database access. This catalog documents the dimensions, the reports finance actually needs, and the compliant ways to get trustworthy data out and alongside the warehouse you own.
◆The spine
The extraction patternLive
There is no database to query. The six ways data leaves EPM Cloud, which one belongs in a warehouse pipeline, and the traps in each.
The stack, one mapLive
ERP, EPM, and the warehouse you own, three zones, five arrows, every number's path.
Chart of accounts to the 10-KLive
How a listed company is configured, which tool emits which report, and where the street's metrics are born.
Connect Power BI to EPM CloudLive
Why direct connection fails, the one-screen dataflow, the gateway and Tableau Bridge decision, and the automated loop.
EPM to Snowflake, Databricks & the warehouseLive
The six-stage owned pipeline, the honest read on paid connectors, and the reconciliation to the ledger.
EPM Automate command dictionaryLive
The twenty commands data work uses, grouped by job, each with the trap that catches people.
REST API patternsLive
One loop, submit, poll, collect, when it beats EPM Automate, and the new JSON grid APIs.
Data Management to Data IntegrationLive
The dated handover timeline, where everything lives now, and the vanished-schedules fix.
Smart View & retrieval performanceLive
The five causes of a slow grid, the Activity Report method, and the fix loop that turns minutes into seconds.
The warehouse modelLive
The star every cube flattens into, level-0 facts, dimensions from metadata, and the reconciliation to the ledger.
Update governanceLive
The test-window routine, the snapshot habit, and five real 2026 changes that prove why.
◆Modules
Planning (EPBCS)Soon
Financials, Workforce, Capital, and Projects: the dimension dictionary, the reports finance needs out of the cube, rule design, and the prebuilt-rule dictionary. 22 pages planned.
Financial Consolidation & Close (FCCS)In build
The seeded dimension dictionary, the close reports, the compliant exports, and the known-issues answers. First pages live.
Account Reconciliation (ARCS)Soon
Profiles, formats, and periods; reconciliation status, aging, and auto-match rate; the status export for outside automation. 12 pages planned.
Tax Reporting (TRCS)Soon
The tax provision cube: dimensions, the provision and rate reports, and the export path. 10 pages planned.
Enterprise Profitability & Cost MgmtSoon
Allocation models, the profitability reports, and getting allocated results out. 10 pages planned.
Narrative ReportingSoon
Report packages, doclets, and the data behind the narrative. 6 pages planned.
Enterprise Data Management (EDMCS)Soon
The dictionary of dictionaries: viewpoints, subscriptions, and the cure for metadata drift. 7 pages planned.
FreeForm & the Essbase engineSoon
BSO, ASO, and Hybrid: the cube-design decisions every application inherits. 4 pages planned.