Measure Types

A limit has an underlying measure that is used to evaluate the limit. Under the hood, Limits will create a KPI on that measure to allow for monitoring. A limit can be defined on any Cube Measure (normal PostProcessed or Copper measures) as well as Calculated Measures.

Cube Measures

Cube Measures are measures that exist within a particular cube. These measures can be selected when creating a limit through the UI or can be specified in an input file.

Calculated Measures

A Calculated Measure is a user defined measure created in the UI.

You have to publish it. If it is not published, it is not particular to any cube or even server. Unpublished Calculated Measures exist in the context of the UI and don’t exist in the Cube.

Limit on a Calculated Measure Example

In the following example we will go through creating a Calculated Measure and then creating and using a limit on the Calculated Measure.

Create a Calculated Measure

First, let’s create a Calculated Measure through the UI.

Enable Creating Calculated Measures in UI

Before we start, we first need to ensure that we can create Calculated Measures through the UI. To check this, navigate to the Content Server and check either the organization_settings file or the permissions on an individual user basis.

We will need to add the following property to the organization_settings file or individual user settings files:

"calculatedMeasures.areEnabled": true

We will first need to navigate to the content server, located at:

/content/ui

Example using the FRTB Acclerator:

http://localhost:8080/frtb-starter/content/ui

organization_settings File

The organization_settings file is located at /ui/organization_settings:

If this file does not exist then we can create it with a blank JSON structure.

User settings File

We can navigate to the individual user’s settings by going to /ui/users/USER_NAME/settings:

Create new Calculated Measure

With the Calculated Measures enabled, we can create a new calculated measure through the Calculated Measure button. We will create a Calculated Measure named Scaled PV which will scale the PV measure by a factor of 1000:

Save Calculated Measure

In order to to use our Calculated Measure with a limit, we must save the Calculated Measure by clicking the Save icon on the measure in the Content editor:

This will save the measure definition onto the Content Server.

Publishing A Calculated Measure

Once a calculated measure has been created, you can publish it to the cube. This can be done using the Publish Measures drawer on the left bar of the application.

When you are ready to publish you measure:

1. Click the Save and Publish measures button on the left navigation bar.
   This displays a list of your saved measures.

2. Right-click on your measure, and in the context menu, click Publish.
   This opens a popup, which allows you to specify the cube.

3. In the firt dropdown, select the cube where you want to publish your measure. In the second dropdown you can assign read/write permissions to particular roles.

4. Click OK.
   Your measure is now published to the specified cube.

Create Limit on Calculated Measure

The Limits Creation Widget can’t used to create a limit on Calculated Measures, so we must create the limit by using the Limits Inventory’s File Upload functionality. We can define our limit with its measure being our Calculated Measure “Scaled PV”. We will upload the following Limit Definition file:

Group,ID,Name,Comment,From,To,FrequencyType,PollingFrequency,KpiType,LimitValues,AbsoluteValueIndicator,WarningThreshold,MeasureName,Scope,Precedence,LimitStatus,WarningWorkflow,WarningWorkflowParameters,BreachWorkflow,BreachWorkflowParameters,ChangeWorkflow,ChangeWorkflowParameters,userID,CubeName,ServerName
Calculated Measure,CM_01,Limit on Scaled PV,,2018-03-01,,OFFICIAL,EOD,Greater Than,1000000,false,,Scaled PV,Desk=*,,APPROVED,,,,,,,User_1,StandardisedApproachCube,FRTB