Multi-Dimensional Planning
Una's Multi-Dimensional Planning engine stores data in a manner that allows querying in both multidimensional and relational formats. It is similar to an OLAP engine but includes enhancements specific to financial planning.
Architecture
The planning engine organizes data into models, dimensions, and fact tables:
- Key Concepts - Understanding models, dimensions, hierarchies, and measures
- Architecture - Technical details about dimension and fact tables
Query Engine
Una provides multiple ways to query data:
- Dimension Queries - Retrieve members from dimensions
- Model Queries - Retrieve data from models with axes and filters
- SQL Queries - Use SQL for custom data retrieval
- Dimension Roles & Member Tags - Reference dimensions by role and members by tag
Calculations
The engine supports various calculation types:
- Formulas - Simple expressions for single member calculations
- Calc Scripts - Complex, parametrized calculations for multiple cells