
Introducing TRS Cubed
A solution for power users who spend a lot of time working with data, want to build their own reports and perform ad hoc data queries. Pull data and build reports directly from the data warehouse using a powerful Cube connected via MS Excel Pivot Tables.
Key Benefits:
- Accessed via Microsoft Excel so- no need for additional software licenses
- Use standard Excel functions to chart, drill, format & filter
- Uses Excel so it reduces training needs
- Share reports with other users in a common format
- Save time using auto refresh on built pivots
- Manage access using site to site authentication
How Does It Work

The Cube is a highly structured database that contains all the dimension defined in the data warehouse and all the measures and calculations linked to those dimensions.
The combination of pivot functionality and this structured Cube ensure users can pull any information they need.
This in turn allows the user to:

Key Benefits:
See sales alongside stock, purchases or any other measure, including stock back through time!
View cross dimensional reporting e.g. Product Sales Mix by Channel
Build reports that automatically update on refresh e.g. a report for Last Week or Yesterday
Populate existing reports with data from the TRS Cube
Create unlimited reports, visualisations, and ad hoc queries
View unlimited time calendars and time aggregates including relative periods e.g WTD, MTD, YTD