Version 7.5 provides the ability for more interactive, chart-driven reporting. This is achieved by extending the existing Small Multiple Charts in the product. Users can now click a chart, or a datapoint within a chart and have the rest of the report update in context, as in the example below where Road Bikes, Q2 has been selected and the ranking table beneath has been filtered accordingly.
Small Multiples have been extended in three key areas:
- Full control over selected chart and chart area, with associated formatting
- More control over axis and title formatting
- In addition to cubes, Small Multiple charts can also be built from an Excel Range or directly from SQL.
When building reports, it's now possible to track any selected element of a Small Multiple Chart. This includes an axis element, an individual chart, or any data point in the chart. This information can be output to a range of Excel cells, and then other parts of the overall report, including grids and formulae, can be based on the content of these cells. The chart will also indicate by colour which chart or datapoint is selected. This is handled by all unselected elements being displayed in a much lighter shade, while the selected item retains the original colour.
These output properties are configured in the properties for the chart control, as shown in the screenshot. To track an element, select the relevant checkbox and chose the desired output cell.
'Link to' is also available as an option, where the focus can be moved to another area of the report in the context of the selected chart or chart element.
SQL and Excel sourced Charts
7.5 introduces the capability to build small multiple charts from non-cube data. This can be any Excel range, or directly from a SQL query or stored procedure. When inserting a small multiple chart from the XLCubed ribbon, you can now specify which data source this is for.