EPM Foundations
Master the core architectural concepts of Oracle Essbase and FCCS. Designed for aspiring Architects.
The Anatomy of a Block
The fundamental storage unit. Learn why block size is the #1 factor in app stability.
Dense vs Sparse – The Survival Math
The 'make or break' decision. Master how Essbase allocates physical vs. virtual space.
The Hourglass Effect: Mastering Dimension Order
Ordering dimensions from Dense to Sparse to optimize the index search path.
ASO, BSO, and Hybrid: The Three Engines
The 'Best of Both Worlds'. Compare heavy-lifting BSO with speed-demon ASO engines.
Data Storage Properties: Store vs. Dynamic Calc vs. Shared
The balance between Speed vs. Space. Learn when to store data or calculate on-the-fly.
Partitions: Connecting the Cubes
The Bridge between Databases. Learn how to link multiple cubes to act as one single source.
The POV: The GPS of EPM
The coordinate system of data. Learn why every cell needs a 'full address' to exist.
Database Restructuring: The House Metaphor
Renovating the Cube. Learn why adding a member can sometimes take hours and require 2x disk space.
Alias, Smart Lists, and Menus
The UI layer. Translate codes into language and steps into shortcuts.
Generations vs. Levels: Navigating the Tree
Top-Down vs. Bottom-Up. Master how Essbase identifies members within a hierarchy.
Attributes vs. UDAs: The Art of Tagging
Don't bloat your outline. Use dynamic attributes for high-speed reporting slices.
Data Types: The Language of Your Data
Gatekeeping your data. Ensure currency, dates, and text are handled correctly.
Typed Measures: Storing Text and Dates
Beyond Numbers. Learn how to store project statuses and dates for advanced date-math.
FCCS Movement: The Heart of Cash Flow
Opening + Movement = Closing. The formula that automates your Cash Flow.
Time Balance Properties: Flow vs. Balance
Accounting brain of the app. Learn how data rolls up from Months to Quarters.
Account Types: The Moral Compass
Stop sign-flipping errors. Learn how Account Types automate your Balance Sheet math.
Consolidation Properties: The Math Symbols
The math symbols (+, -, ~) that dictate how children roll up to parents.
Bottom-Up vs. Top-Down Calculations
Efficiency vs. Exhaustion. Master how Essbase searches for data to calculate.
Parallel Processing: Mastering Speed
Multi-Threading. Learn how to use multiple CPU brains to slash calculation times.
Two-Pass Calculations: Fixing the Math
Ratios and Percentages. Learn how to prevent math errors when rolling up data.
The FIX Command: Targeting your Logic
Efficiency 101. Learn how to tell the calculation engine exactly which data to process.
Intelligent Calculation: Clean vs. Dirty Blocks
Work Smarter, Not Harder. Learn how Essbase tracks changes to skip unnecessary work.
Data Loading and Clearing
The inhale and exhale of data. Master physical vs. logical clearing.
Load Rules: The Data Translator
The Front Door of Data. Learn how to map, clean, and transform messy source files into clean cube data.
Substitution Variables: The Power of Placeholders
The Admin's Magic Wand. Learn how to update hundreds of reports by changing one single variable.
Security and Roles: The Gatekeepers
Protecting sensitive data. Learn about Functional Roles vs. Dimensional Security.
Top EPM Interview Questions
Ace your next job. Compendium of Junior and Senior level technical questions.