| Table of Contents |
|---|
...
Overview
eMite BI platform supports KPI creation/maintenance through its KPI dashboard. Anyone has been given access to KPI dashboard can create/edit/delete/publish KPI(s) and/or use KPI(s) inside other KPI(s). Also within each KPI creation/maintenance, we are able to add as much as we want, with the ability to apply business logic filters on top of existing data sources. The data sources are eMite's RTBI data structures - and not the customer's data sources.
...
Access KPI Dashboard
There are two options to access KPI Admin dashboard page:
1. Web Admin Dashboard Page
Go to eMite Web admin page.
From Edit Page menu, select Add Content.
Click Add Row button.
On the Select Datablock page, select KPI Admin then follow the Add button. You should now see the new KPI Admin page added. The page can be resized by dragging the resize tool on the right corner of the page.
2. Standard Method
The eMite web dashboard refreshes all the pages automatically (including the one you have already opened within KPI Admin page), or you may need to navigate through other pages. When this happens, you may face an RTBI data source structure's reloading experience, or you may even lose your page if you did not save it. Some users want to create/change/publish KPI(s) reports and quickly test the result. These users are likely to experience the reloading issue more than others, as they need regular page navigation. In this case, you should use the direct KPI Admin URL in another browser or a separate page on the current browser.
...
Contact your eMite administrator or eMite consultants if the page failed to open, probably the settings in back-end have not been configured correctly.
...
Components/Sections of the KPI Admin Dashboard
There are three main components on the KPI Admin dashboard page. These allow you to add, edit, delete, and/or publish KPIs in eMite platform.
...
| Note |
|---|
Any creation, deletion, and edit will be auto-saved - so be careful when making changes within KPI Admin dashboard. The auto-save does not perform the auto-publish (where you can see changes in report designers). The KPI will only be published when the UpdateKPI button is selected (see below on how to Publish). |
...
Cube & KPI Selection
Click the expand button to collapse or expand the options.
...
Cubes | The Cube is a report representation of your single or multiple data sources. In eMite, this sometimes called a Fact Query. The Cube can be selected from the system dropdown menu. | ||
KPI Groups | The KPI Group is a group that contains one or many KPIs.
| ||
KPIs |
|
...
Templates & Settings
Click the expand button to collapse or expand the options.
...
Template
Predefined templates can be used for predefined calculations. This is the standard mode of KPI calculation where we use predefined KPI templates to create KPIs.
Templates allow you to select the type of formula/calculation for the KPI. It contains one or two sets (maximum of two, Set A or Set B or both) to represent the KPI logic. Each set carries one or more logic, and each logic works as a filter on top of data source. Each logic (filter) contains two parts - the Measure, and the Dimension member(s).
For example, Callback Handled: | |
|---|---|
 | The [Measures].[Handled Count] means that we are trying to count the handled calls where "Handled Count" is the measure. The [InitiationMethod].[InitiationMethod].[CALLBACK] means that we are looking for Callback (Initiation method dimension member) calls. The combination of the measure and dimension filter means that we are trying to count the number of Callback Handled. |
eMite currently supports 7 types of calculation templates and an Advanced Option. Each type of calculation requires its own requirements (one or two Sets).
KPI Template | Description | Example |
|---|---|---|
SUM(A) = X | This is the sum aggregation of records for a set (Set A) of logic. | "Number of PI Incidents", which shows the sum of incident records by P1 priority. |
SUM (A) / SUM(B) * 100 = X% | This type is used to create percentage KPIs.
The percentage is a value from between 0 to 100. However, eMite % KPI calculates the % depending on Set A and Set B. | % of Answered Calls, which shows a percentage of number of calls were answered versus the total calls offered to the queue. |
SUM(A) + SUM(B) = X | The result of this type of KPIs would be the sum of results from Set A and Set B. Each Set can have one or many logics (filter). If in case, you are looking for Set A + Set B + Set C, you need to first build your first KPI (for example call it MyFirstKPI) as Set A + Set B, then publish it, then reload the KPI Amin (to make sure the new KPI, MyFirstKPI, has come through to the list of measures). Then you can build second KPI as Set A + Set B, where Set A (or Set B) can use the new KPI, MyFirstKPI, as your measure. | Total Handle Time4 = Talk Time + Hold Time + After Call Work Time In this case, we create 2 KPIs.
|
|
SUM(A) - SUM(B) = X
Similar to SUM(A) + SUM(B), but here the final result is the Set A - Set B
|
SUM(A) |
- SUM(B) = X | Similar to SUM(A) + SUM(B), but here the final result is the Set A |
- Set B |
|
SUM(A) |
* SUM(B) = X | Similar to SUM(A) + SUM(B), but here the final result is the Set A |
SUM(A) = X (include 0)
This is same as SUM(A) = X, but has one more feature - and that is, if the result is empty (null value), it gets converted to zero.
Advanced
This is an advanced mode of KPI calculation where none of the above templates covered your calculation type. Here, you can put your own MDX query (the query language of Analytic structures - for more clarification, refer to: https://msdn.microsoft.com/en-us/library/ms144785.aspx) and system will try to parse, run, and return a numeric value of that.
In MS Analysis version of eMite, all kinds of valid MDX queries are supported (MS Analysis has its own MDX parser). While in RTBI version, currently, just the "Case Statements" are supported.As an example, you can write: "Case When [Measures].[Incident Count] > 10 Then 1 Else 0 End"
multiply Set B |
| |
SUM(A) / SUM(B) | Similar to SUM(A) + SUM(B), but here the final result is the Set A divided by Set B | |
SUM(A) = X (include 0) | This is same as SUM(A) = X, but has one more feature - and that is, if the result is empty (null value), it gets converted to zero. |
|
Visible
When set to “false” and after publishing your changes, nobody will see that KPI in reporting side - so it is like a hidden KPI. If a KPI does not need to be used by users/reports through dashboard, it can be used to build a second level of KPIs.
...
one is a fixed value KPI (like $1 per unit of low performance), and you approximately prefer to hide it of reporting side,
and the second one which is the actual low performance value KPI, calculates the performance.
Format String
This feature is to wrap the KPI value to a specific format. eMite supports following formats. This feature helps to show the values in proper format in all places like status block, cube report.
"#,##0.00 %;-#,##0.00 %"
"#,##0.00;-#,##0.00"
"$#,##0.00;-$#,##0.00"
"0"
"Currency"
"d/MM/yyyy"
"dddd, d MMMM yyyy"
"Long Date"
"Percent"
"Short Date"
HH:mm:ss
e.g. % Answered KPI
...
Status KPI
When creating a KPI, you can define the expected Thresholds Boundaries for that KPI, and what color (Status) the KPI will represent in the dashboard.
...
1. In this case, we need to create 2 KPIs separately.
Answered Calls  | % Answered Set up the threshold boundaries based on your requirement. In this example;
 |
2. Select % Answered as the Status KPI in the Answered Calls KPI
...
Status color can be set to the font color, background color, header color, etc. in the status block.
Trend KPI
Trend KPI is used to find how the KPI is performing during time - Is it getting better? worse? or even not changing?
...
As discussed at the start of the article, a KPI has many angles and Trend is one of them. Even knowing a KPI value and its status, but there are reasons to find how the KPI is performing during time - is that getting better, worse or even not changing? Knowing the team performance is good, but it is also useful to know when the performance is dramatically moving down. To see the KPI's direction, you can use a eMite's Score Board and check the KPI's Trend.
Target KPI
Target KPI is a value which helps you understand how close your KPI are from what you are expecting as your desire value. How much you are expecting to sell in current financial year is a Target for your selling KPI. Same as Trend KPI, you can see that value in Score Board datablock and if no KPI has been linked to TargetKPI of a KPI, the Target would come from the first value of threshold boundaries.
Description
Just put your own description about the KPI and explain the logic. Anyone who looks at your KPI can/will understand the reason and logic of your KPI with Description.
Threshold Boundaries
The threshold boundaries are what you are expecting your KPI to look like.
...
| Info |
|---|
Although, the three statuses, Green/Warning/Alarm are very popular, in eMite, there is no limitation on how many expression lines/colors you want to have. You are welcomed to have nothing or even 10 lines. You can pass your own desire expression values and colors as well, all would be automatically and with no delay reflected into UI components. |
Setting Up Threshold Boundaries Based on Another Dimension
E.g. Setting up threshold boundaries for % Answered KPI based on Queue Name.
In this example there are 3 queues:
Queue Name | Threshold Boundaries |
|---|---|
Basic Queue | >=90% of calls answered = Green >=80% - <90% of calls answered = Orange <80% = of calls answered = Red |
Sales | >=80% of calls answered = Green >=70% - <80% of calls answered = Orange <70% = of calls answered = Red |
Support | >=70% of calls answered = Green >=60% - <70% of calls answered = Orange <60% = of calls answered = Red |
In this case, you need to:
...
Continue the same steps to setup threshold boundaries for each queue.
...
Reports
Logic (Filters)
Filters allow you to include additional filters over the measures. A KPI can have multiple filters. E.g.
...
List of special date function commands and examples:
Keyword Function for Date Dimensions | Example |
|---|---|
@Today | [InitiationTimestamp].[Date]=@Today |
@Now | [InitiationTimestamp].[Hour] =@Now |
@Yesterday | [InitiationTimestamp].[Date]=@Yesterday |
@ThisMonthAndYear | [InitiationTimestamp].[MonthAndYear] = @ThisMonthAndYear |
@LastMonthAndYear | [InitiationTimestamp].[Date].[MonthAndYear] = @LastMonthAndYear |
@LastYear | [InitiationTimestamp].[Year] >= @LastYear |
@ThisYear | [InitiationTimestamp].[Year] < @ThisYear |
@ThisWeek | [InitiationTimestamp].[Date] >= @ThisWeek |
@OneWeek | [InitiationTimestamp].[Date] >= @OneWeek |
@LastWeek | [InitiationTimestamp].[Date] > @LastWeek |
@LastHours | [InitiationTimestamp].[Hour] >= @Last72Hours |
@LastDays | [InitiationTimestamp].[Date] >= @Last2Days |
@TodayAndLastDays | [InitiationTimestamp].[Date] <= @TodayAndLast3Days |
@NextMonthAndYear | [InitiationTimestamp].[MonthAndYear] <= @NextMonthAndYear |
@NextYear | [InitiationTimestamp].[Year] <= @NextYear |
@NextWeek | [InitiationTimestamp].[Date] < @NextWeek |
@NextHours | [InitiationTimestamp].[Hour] > @Next48Hours |
@NextDays | [InitiationTimestamp].[Date]<= @Next4Days |
@TodayAndNextDays | [InitiationTimestamp].[Date]<= @TodayAndNext5Days |
@ThisDayLastYear | [InitiationTimestamp].[Date]=@ThisDayLastYear |
@ThisMonthLastYear | [InitiationTimestamp].[MonthAndYear] = @ThisMonthLastYear |
@ThisDayOfWeek | [InitiationTimestamp].[Day Of Week] = @ThisDayOfWeek |
Text Search
Text Search functions can be used on String fields.
Keyword Function | Example | Description |
|---|---|---|
@TextSearch | [description].[description].[@TextSearch(Password Reset)] | In this example any of the text after the @TextSearch Keyword and the brackets will be searched in the respective column. |
[description].[description].[@TextSearch(Email Service Issue)] | Text search will work with any number of words. In the above example columns containing the 3 words will be returned. |
...
Nested KPIs
Nested KPIs allows to create more sophisticated calculations.
...