SSAS KPIs in BI Office

By David Novick, Pyramid Analytics Technical Writer

This blog provides a quick introduction to the usage of SQL Server Analysis Services (SSAS) KPIs within BI Office. By means of some simple examples, we will demonstrate the various features that are available in BI Office for handling SSAS KPIs. 

NOTE:  An upcoming blog will cover the creation of “Custom KPIs in BI Office”. Custom KPIs operate a bit differently than SSAS KPIs and provide additional functionalities such as dynamic banding.

SSAS KPIs in Measures Panel

When you load a data model in BI Office, the SSAS KPIs in your data model appear in the Measures panel. In this example, we select the KPI titled "Cost per Item".


Report Layout for SSAS KPIs

In order to view SSAS KPIs in BI Office, we follow these steps.

We open the Home ribbon in Data Discovery and click on Report Layout.

We select one of the report layouts.


We choose Gauge as one of the layout options. If the Gauge option is disabled (grey), it can enabled by selecting a SSAS KPI in the Measures Panel.


We click the Run Query button to update the KPI contents. 


In the example, four SSAS KPIs display "Cost of Item" stats for the four quarters of 2010:

In-Grid Icons for SSAS KPIs

An example of in-grid icons is shown below. In each pair of icons, the first icon represents status while the second indicates trend.    

For a full list of SSAS KPI in-grid icons, see the topic titled:
How are SSAS KPI's Mapped in BI Office?


Resize In-Grid Icons

To resize the in-grid icons, open the Grid ribbon in Data Discovery and click on the KPIs icon, as shown below. There are two methods of changing the size of the in-grid icons:

  • Preset Sizes
  • Custom Sizes

Preset Sizes for In-Grid Icons

To use the preset sizes, choose one of the following options:

  • Small KPIs
  • Medium KPIs (default)
  • Large KPIs
  • No KPIs

Custom Sizes for In-Grid Icons

To set custom sizes, click the More KPI Options command and use the dialog to specify any custom size in the 1.00 to 6.00 range.


Reverting to Preset Sizes

You can revert to the use of the preset sizes at any time. Note that the preset sizes are equivalent to the following custom values:

  • Small KPIs = 2.00
  • Medium KPIs = 3.00 (default)
  • Large KPIs = 4.00 

Viewing Data for SSAS KPIs

Place your mouse over the status or trend icon to display KPI data, as shown below.


Gauge Types for SSAS KPIs

SSAS KPIs can be displayed within BI Office using several different gauge types, as shown below. The gauge type employed by BI Office for any specific SSAS KPI is determined automatically, as described in:  How are SSAS KPI's Mapped in BI Office? 

NOTE:  You cannot change an SSAS KPI gauge type within BI Office.

Editing SSAS KPIs

For instructions on how to edit SSAS KPIs, see the blog titled Editing of KPI Gauges.


Like Follow Reply
reply to topic
Like Follow
  • 8 days agoLast active
  • 218Views
  • 1 Following