Visual BI Extensions – Feature Highlight: KPI Tile
In addition to the two previously discussed components – Hierarchical Filter and Advanced Table – we also added a new KPI Tile as part of our recent release of the Visual BI Extensions for SAP BusinessObjects Design Studio.
The new KPI Tile component allows you to quickly show a single measure as the main “visual aspect” of the component, but you can add several other options as well.
Figure 1 – KPI Tile
Figure 1 shows the new KPI Tile as a conceptual display. Our KPI tile supports the display of
- …a single KPI value
- ….the Unit / Currency
- … a title and sub title
- …a icon to provide the user a visual clue
- … an alert symbol based on a defined threshold
- … a footer
- …a micro-chart / sparkline chart showing the trend
All the items are optional and it is up to you to decide which of those elements will be part of your KPI tile and where these elements from a layout perspective are going to be displayed.
In the Data Series category of the Additional Properties you can select the value using the Data Selection feature for the property Data Value and you can define the data selection for the chart.
Figure 2 – Data Series
With the huge set of style options (Figure 3 shows only a subset) you can then customize the look and feel of your KPI tile.
Figure 3 Style options
And with the Alert category (see Figure 4) you have the ability to define a formatting rule for the Alert Icon. The entered value will be compared against the value you selected for the KPI tile itself.
And finally the category Layout Design allows you to define the layout of your KPI Tile.
Figure 5 shows an example with all elements added to the KPI Tile, but that is optional. The Layout Design also allows you to place the elements into different areas or to remove them and to only use a subset of the available elements as part of your KPI Tile.
So let us now built our first KPI Tile. Our data set shows the Revenue and Product costs based on our Product Category for the first 6 months of the year 2015 (see Figure 6).
Figure 6 – Data Set
We are going to use the subtotal for the Product Group “Mobile Devices 1” as the KPI value and we will use the 6 months as values for the sparkline chart.
In the Data Series category we are using the data selection feature to choose the value for the main KPI value (see Figure 7) and we also use the data selection feature to specify the data for the chart (see Figure 8).
In addition we are adding the title and subtitle, the currency, and doing some minor formatting, such as changing the font style and font sizes and our KPI Tile looks like this (see Figure 9) so far:
At this point we are missing a formatting rule for our alert and we are missing an image which will provide our users a visual clue on the product group.
In the Alert category I am first of all adding a rule as shown in Figure 10.
In addition we adding a Icon URL to our KPI so that we are giving our user a visual indication about the product itself and we then have a KPI Tile that looks similar to what is shown below.
In a few steps we were able to display a KPI in combination with an alert, a trend in form of a sparkline chart, and all together the content is being displayed in form of a KPI Tile.
In case you are interested to learn more about SAP BusinessObjects Design Studio, take a look at our new Training offerings, available in several cities in the US.