Chat now with support
Chat with Support

Identity Manager 8.0 - Configuration Guide

One Identity Manager Software Architecture Working with the Designer Customizing the One Identity Manager Default Configuration Checking Data Consistency Compiling a One Identity Manager Database Working with Change Labels Basic System Configuration Data
One Identity Manager Authentication Module Database Connection Data Configuration Parameters for System Configuration Setting up the Mail Notification System Enabling More Languages for Displaying and Maintaining Data Displaying Country Information Setting Up and Configuring Schedules Password Policies in One Identity Manager Reloading Changes Dynamically TimeTrace Databases Machine Roles and Server Functions Files for Software Update Operating Systems in Use System Configuration Reports Using Predefined Database Queries Managing Custom Database Objects within a Database
The One Identity Manager Data Model Granting One Identity Manager Schema Permissions Working with the User Interface
Object definitions for the User Interface User Interface Navigation Forms for the User Interface Statistics in the One Identity Manager Extending the Launchpad Task Definitions for the User Interface Applications for Configuring the User Interface Icons and Images for Configuring the User Interface Language Dependent Data Representation
Process Orchestration in One Identity Manager
Declaring the Job Server One Identity Manager Service Configuration Handling Processes in the One Identity Manager
Tracking Changes with Process Monitoring Conditional Compilation using Preprocessor Conditions One Identity Manager Scripts Maintaining Mail Templates Reports in the One Identity Manager Custom schema extensions Transporting One Identity Manager Schema Customizations Importing Data Web Service Integration SOAP Web Service One Identity Manager as SPML Provisioning Service Provider Searching for Errors in the One Identity Manager Processing DBQueue Tasks One Identity Manager Configuration Files

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

  1. Select the category User Interface | Statistic definitions in the Designer.
  2. Select the statistic definition.

    - OR -

    To create a new statistic definition, select Object | New.

  3. 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

Table 167: 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 button.

NOTE: If a caption is entered in the menu item, it overwrites the statistic definition display name.

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".

NOTE: Enable the schedules for calculating statistics in the category Basic data | General | Schedules in the Designer.

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.

NOTE: Aggregate and base aggregate functions are only evaluated if the formulated measurement value query is limited by a condition on the logged in user.

NOTE: Aggregate and base aggregate functions are only taken into account for statistics that are displayed in the Web Portal.

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

Table 168: Measurement Query Properties
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%.

NOTE: The column name ElemenName in the base measurements query must match the name of the column ElementName in the measurements query.

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%.

NOTE: The condition is only taken into account for statistics that are shown in the Web Portal.

Example of Calculating the Threshold

Threshold factors help to find the base measurement percentage that represents an "Correct state" or a "unacceptable state".

Table 169: Example of Finding the 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.

Table 170: Statistics Properties
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.

Related Topics
Related Documents