Query Engine
Una's query engine provides multiple ways to retrieve data from the multidimensional model.
Query Types
Dimension Queries
Dimension queries return metadata about dimension members. Use them to:
- Populate dropdown lists and filters
- Navigate hierarchies
- Apply security profiles
Learn more about Dimension Queries
Model Queries
Model queries retrieve data from fact tables with support for:
- Multiple axes (rows and columns)
- Filters (slicers)
- Different request types (KPI, Metrics, Stats)
- Time perspectives (MTD, QTD, YTD)
Learn more about Model Queries
SQL Queries
SQL queries provide direct database access for custom data retrieval. They require a specific result format to integrate with Una components.
Dimension Roles & Member Tags
Reference dimensions by their role in a model rather than by name, and locate members using tags for flexible, reusable queries.