A limit has an underlying measure that is used to evaluate the limit. Under the hood, Atoti Limits creates a KPI on that measure to allow for monitoring. A limit can be defined on any cube measure (normal post-processed 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.
note
If two calculated measures - one saved in Atoti UI 4 and one saved in Atoti UI 5 -
have the same name, then the one saved in Atoti UI 5 takes precedence.
Limits only work against saved calculated measures. When a calculated measure is not saved, it is not particular to any cube or even server. Unsaved calculated measures exist in the context of the UI and don’t exist in the cube.
Limit on a calculated measure
To create a limit on a calculated measure, first, create and save a calculated measure through the UI. See Calculated measures in the Atoti UI documentation on how to do this.
Once your calculated measure is saved, create the limit by using the Inventory’s File Upload functionality.
note
Limits can’t be created on calculated measures in the UI.