XLCubed 9.1 - what's new?

XLCubed works extremely closely with key partners and customers to ensure our product development roadmap fits the needs of their businesses. Customer input has been key to several of the new capabilities introduced in version 9.1.

Data Access 

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.

Ad-hoc Query, Analytics and Data Discovery

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.

Repeater Concept


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:

  • 'Operational' - e.g. notifying report readers that there is a problem with a data feed which is affecting the numbers. This can be done at the point they read the report rather than have potentially hundreds of users raise the same support question.
  • 'Budget Cycle' - justifying the provided numbers at the point of entry
  • 'Ad-hoc / Conversational' - Ability for users to raise a question about specific data points, and have this answered by other users in a conversation thread.
  • 'Supplementary detail' - supports file attachments for more detailed text based background on the specific entity being reported on

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.

Dashboards & Mobile

9.1 adds further flexibility to the responsive dashboard design environment first introduced in Version 9.

More Details...

See our 9.1 wiki for more details.




Unrivalled Flexibility:
"There is always a way"

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 support@xlcubed.com