Working with Statistic Definitions
The basis for the info system is the definition of statistics. Predefined configurations are maintained by the schema installation and cannot be edited apart from a few properties. The default configuration is moved to a configuration buffer during handling. You can retrieve changes from the configuration buffer and restore the default configuration in this way.
To edit an statistic definition
- Select the category User Interface | Statistic definitions in the Designer.
- Select the statistic definition.
- OR -
To create a new statistic definition, select Object | New.
- Edit the master data.
- Enter general properties on the Properties tab.
- Enter measurement queries on the Queries tab.
Detailed information about this topic
- General Properties of a Statistic Definition
- Querying Statistic Measurements
- Examples of Statistic Definitions
General Properties of a Statistic Definition
| Property | Meaning | ||||
|---|---|---|---|---|---|
| Statistics | Name of the statistic | ||||
| Display name |
This display name is used to show the statistic definition in the settings for the info system in the administration tools. The display name forms the title of a statistic. Translate the given text using the
| ||||
| Description | Description of the statistic definition. The statistic definition description is shown in the info system settings in the administration tools. Translate the given text using the  button. | ||||
| Calculation schedule |
Select the schedule for calculating the statistic information. Schedules supplied are: "Calculate statistics", "Calculate weekly statistics" and "Calculate monthly statistics on the 1st".
| ||||
| Aggregate function |
Use the aggregate function if the measurements query returns several values but there should only be one value displayed in the statistics. Example: Determines the number of employees for which a department head is responsible. Use the aggregate function "SUM" to display a statistic for all employees in a department. Do not use an aggregate function to display statistics by department. | ||||
| Base aggregate function |
Use the base aggregate function if a unique base value cannot be attained from the measurements query.
| ||||
| Threshold green | Threshold in range [0-1]. The base measurement percentage representing a "correct state" is found with the help of this threshold value factor. | ||||
| Threshold red | The base measurement percentage representing an "accepted state" is found with the help of this threshold value factor. | ||||
| Unit of measure: | Unit for measured values. This is the unit of measure displayed in the info system statistics. Translate the given text using the button. | ||||
| Time scale | Enter the display accuracy of the data on the time axis for statistic definitions that contain a time query (for example, the number of new employees in the last week). Permitted values are "hour", "day", "week", "month", "quarter" and "year". | ||||
| Measurement runs to archive | The number of measurement run (apart from the current measurement) to be archived for displaying in the history. Only if the most recent values should remain intact, enter the value "0". | ||||
| Disabled | Specifies whether the statistic definition is disabled. Statistic definition which are disabled are not calculated. | ||||
| Preprocessor condition | You can add preprocessor conditions to statistics. This means that a statistic definition is only available when the preprocessor condition is fulfilled. | ||||
| Disabled by preprocessor | If a statistic definition is excluded through a preprocessor condition, this option is set by the Database Compiler. | ||||
| Instant calculation | Set this for statistic definitions, which are calculated at the moment they are displayed in the Web Portal. If this option is not set, the statistics are calculated during maintenance tasks. | ||||
| Imported statistics data | Specifies whether these statistics are calculated at the moment they are displayed (for use in the Web Portal). If this option is not set, the statistics are calculated asynchronously by the DBQueue Processor. |
Related Topics
- Querying Statistic Measurements
- Examples of Statistic Definitions
- Setting Up and Configuring Schedules
- Conditional Compilation using Preprocessor Conditions
Querying Statistic Measurements
| Property | Meaning | ||
|---|---|---|---|
| Measurements query |
Enter the complete database query in SQL syntax to determine the statistic measurements. The query must return the columns ElementName and ElementValue as results. You can also return the columns ElementObjectKey, ElementObjectKey2 and ElementValue2 for displaying statistic information in the Web Portal. You can, optionally, control the display order of statistic measurements with the column ElementOrder. If the column ElementOrder does not exist, they are sorted by ElementName. | ||
| Base measurements query |
Enter the complete database query in SQL syntax to determine the statistic measurements. The query must return the columns ElementName and ElementValue as results. You can also return the columns ElementObjectKey, ElementObjectKey2 and ElementValue2 for displaying statistic information in the Web Portal. You can, optionally, control the display order of statistic measurements with the column ElementOrder. If the column ElementOrder does not exist, they are sorted by ElementName. The threshold factors entered in the fields Threshold green and Threshold red refer to the result in the ElementValue column. To determine the base measurement percentage, the result from column ElementValue is applied with 100%.
| ||
| Condition |
Formulate a condition with which the statistic measurements can be limited to the current user. The condition has to be formulated as a valid where clause for database queries and limits the result of the query further based on the column ElementObjectKey using the variable %UserUID%.
|
Example of Calculating the Threshold
Threshold factors help to find the base measurement percentage that represents an "Correct state" or a "unacceptable state".
| Base Measurements | Threshold green | Threshold red | Percentage | State |
|---|---|---|---|---|
| 100 | 0,25 | 0,75 | < = 25 | correct |
| >25 to >75 | acceptable | |||
| >= 75 | unacceptable | |||
| 0,75 | 0,25 | > = 75 | correct | |
| <75 to <25 | acceptable | |||
| <= 25 | unacceptable |
Related Topics
Linking Statistics into the User Interface
In order to visualize statistics in the One Identity Manager administration tools, such as the Manager, you have to link the statistics into the user interface as a custom menu item.
You will typically find statistics under the category Info system in the administration tools navigation menu. You should set up custom menu items for statistics under an info system like this. All statistics that are defined at one menu level are displayed on one form.
Statistics can also be linked as form elements into overview forms. To do this, use the Overview Form Editor.
|
|
NOTE: If you set up a custom info system, ensure that the menu item under which you define the statistics, is labeled with the configuration flags Not expandable by user and Force open menu item. |
For more information about general properties of menu items, see General Menu Item Properties. Take note of the following properties for menu items.
| Property | Meaning |
|---|---|
| Item type | Select the item type "Statistics". |
| Caption | The caption given here, overwrites the statistic definition caption. Leave this field empty if you want to use the statistic definition display name. |
| Statistics | Enter the statistic definition to be displayed. |
| Diagram type |
Select the diagram type that is going to represent the statistic. |
| Alignment | Positioning of statistics on the overview form. This layout information is used if the statistic is used as a form element on an overview form. |
| Background | Background color of the form elements on the overview form. This layout information is used if the statistic is used as a form element on an overview form. |
All menu items that are to be displayed in an application user interface have to be assigned to a permissions group and an application. Use the views Applications and Permissions groups for this when you are editing menu items.