XLCubed has been a leading client tool for Microsoft Analysis Services data for many years. Customers love the flexibility and speed of delivery, and have been keen to extend these benefits to multiple data sources. With version 9, and again in 9.1 we have made this a concrete option. We have added connectors for many additional sources including relational databases, Big Data providers, and other platforms such as SAP HANA and Oracle Essbase.
9.1 extends XLCubed's modelling capabilities when reporting on flat and relational data. Users can now define multi-level hierarchies, and add sophisticated workbook level calculations. The mashup capabilities mean different sources can be combined into one model at report-time for analytics or reporting.
XLCubed already has the concept of Small Multiple charting, where it is very easy to quickly build several charts varying by just one element. We see these used a lot, particularly in retail environments when looking at relative performance of locations or sales teams.
The all-new Repeater control extends this concept to any part of a report, not just one chart or one grid. It lends itself really well to card based reporting where a summary view is defined, potentially combining XLCubed and native Excel functionality, along with charts. Having built the base layout as required, (for a specific store for example) the process of extending that across other stores, and displaying them together in a consolidated view is extremely straightforward. The example below shows the concept, where a view on transfer activity has been built for one premier league football club, and then repeated across the others.
In the last few years we have seen the level of interest in dynamic data commentary increase hugely. Customers use this in several different ways including:
The new capabilities introduced in 9.1 are based extensively on feedback from several corporate customers and include discussion threading, richer formatting, support for attachments, and more flexible reporting on and display of comments.
9.1 adds further flexibility to the responsive dashboard design environment first introduced in Version 9.
See our 9.1 wiki for more details.
Ultimately the products need to work in your environment and on your own data, and we’re happy to provide XLCubed on a time limited evaluation basis to enable that. To discuss your interest in more detail, or arrange a web based overview please contact us at firstname.lastname@example.org
Siena Court, Broadway,Maidenhead, Berkshire
SL6 1NJ, United Kingdom
+44 1628 321 525