Multi-Dimensional Analytics

Visual Report Designer & Multi-Dimensional Query Engine

Design custom reports and print layouts via drag-and-drop, powered by a dynamic OLAP-style query engine that groups by any selected dimension with live manufacturing reservation and multi-unit calculations.

How This Works Inside Xtra Desktop: High-performance dynamic SQL builder combining recursive CTE hierarchies, pre-aggregated manufacturing component reservations, variable unit factors, and custom pricing functions.
Download Free Trial (MSI)
Visual Report Designer & Multi-Dimensional Query Engine
01 / Xtra Desktop

Visual Drag-and-Drop Report & Print Designer: Drag fields, configure custom summary formulas, apply dynamic currency/decimal formatting, and build bilingual report headers.

02 / Xtra Desktop

Dynamic Multi-Dimensional Grouping (OLAP-style): Select any combination of dimensions (Item Groups, Branches, Warehouses, Cost Centers, Projects, Patterns) and the engine constructs optimized SQL joins and GROUP BY clauses on the fly.

03 / Xtra Desktop

Deep Recursive Hierarchy Filtering: Filter and roll up data across 100-level hierarchical trees for Item Groups, Cost Centers, Projects, Branches, and Warehouses.

04 / Xtra Desktop

Live Manufacturing Reservations & 11+ Pricing Policies: Real-time deduction of raw materials reserved in Confirmed, In-Progress, and To-Close manufacturing orders to compute true available stock, with 11+ valuation formulas and 3-tier variable unit conversion.

05 / Xtra Desktop

Custom Window Reporting: Extract and join data directly from user-designed windows created in the Window Designer.