Cloud Software Group, Inc. EBX®
Insight Add-on Documentation > Indicator Portfolio Reference
Navigation modeInsight Add-on Documentation > Indicator Portfolio Reference

Indicators applied to a dataset - dataspace

Dataset completeness rate [ON] D-I01

Property

Specification

Code

[ON] D-I01

Name

Dataset completeness rate

Use other indicators

N/A

Specification

This indicator computes the 'completeness rate' of every table in the dataset and then computes the average rate. The completeness computation follows the rules described for the indicator 'TI-04 Table completeness rate'.

Linked records

no

Applied to D.E.C. type

Dataset

Output parameters

"Dataset completeness rate": Decimal

Storage procedure

Any resulting value is stored

Reporting table

'Flat data report' - One record is saved in the Flat data report table.

Input parameters

Void

Computation frequency

"On demand"

Periodicity of control and watchdog

Periodicity of control=no

Minimum threshold=no

Maximum threshold=no

Tolerance number=no

Probe

no

Save last value only

Configuration

Email alert

Configuration

Data view

ONDatasetCompletenessRate

Dataset freshness [ON] D-I02

Property

Specification

Code

[ON] D-I02

Name

Dataset freshness

Use other indicators

N/A

Specification

This indicator computes the 'freshness' of every table in the dataset and then computes the average rate. The freshness computation follows the rules described for the indicator 'TI-06 Table freshness'.

Linked records

no

Applied to D.E.C. type

Dataset

Output parameters

"Dataset freshness (in days)": Decimal

Storage procedure

Any resulting value is stored

Reporting table

'Flat data report' - One record is saved in the Flat data report table.

Input parameters

Void

Computation frequency

"On demand"

Periodicity of control and watchdog

Periodicity of control=no

Minimum threshold=no

Maximum threshold=no

Tolerance number=no

Probe

no

Save last value only

Configuration

Email alert

Configuration

Data view

ONDatasetFreshness

Number of operations on the tables in a dataset [ON] D-I03

Property

Specification

Code

[ON] D-I03

Name

Number of operations on tables in a dataset

Use other indicators

N/A

Specification

This indicator retrieves the most updated values of the number of operations (creation, modification, deletion) of every table in the dataset and computes and saves the total and the average results. This indicator uses the data history.

Linked records

no

Applied to D.E.C. type

Dataset

Output parameters

"Total number of creation": Integer

"Total number of modification": Integer

"Total number of deletion": Integer

"Average number of creation": Decimal

"Average number of modification": Decimal

"Average number of deletion": Decimal

Storage procedure

Any resulting value is stored

Reporting table

'Flat data report' - One record is saved in the Flat data report table.

Input parameters

"Chart display mode": String. To display either the total numbers or the average numbers for charts.

Computation frequency

"On demand"

Periodicity of control and watchdog

Periodicity of control=no

Minimum threshold=no

Maximum threshold=no

Tolerance number=no

Probe

no

Save last value only

Configuration

Email alert

Configuration

Data view

ONNumberOfOperationsOnTablesInDataSet

Dataspace information [ON] D-I04

Property

Specification

Code

[ON] D-I04

Name

Dataspace information

Use other indicators

N/A

Specification

This indicator computes and saves four values applied to the dataspace:

- number of open dataspaces

- number of close dataspaces

- number of open version (snapshot)

- number of close version (snapshot)

Linked records

no

Applied to D.E.C. type

Dataspace

Output parameters

"Number of open dataspaces": Integer

"Number of close dataspaces": Integer

"Number of open version (snapshot)": Integer

"Number of close version (snapshot)": Integer

Storage procedure

Any resulting value is stored

Reporting table

'Flat data report' - One record is saved in the Flat data report table.

Input parameters

Void

Computation frequency

"On demand"

Periodicity of control and watchdog

Periodicity of control=no

Minimum threshold=no

Maximum threshold=no

Tolerance number=no

Probe

no

Save last value only

Configuration

Email alert

Configuration

Data view

ONDataspaceInformation

Nb. of dataspaces and snapshots without description [ON] D-I08

Property

Specification

Code

[ON] D-I08

Name

Number of dataspaces and snapshots without description

Use other indicators

N/A

Specification

This indicator computes the number of dataspaces and snapshots for a dataspace without any description (short label and long description are empty). This indicator computes for all descendants of the selected dataspace.

The use of the "Use closed snapshots" and "Use closed dataspace" is an option.

Linked records

no

Applied to D.E.C. type

Dataspace

Output parameters

"Number of dataspaces without any description": Integer

"Number of snapshots without any description": Integer

Storage procedure

Any resulting value is stored

Reporting table

'Flat data report' - One record is saved in the Flat data report table.

Input parameters

"Use closed dataspaces": Boolean

"Use closed snapshots": Boolean

Computation frequency

"On demand"

Periodicity of control and watchdog

Periodicity of control=no

Minimum threshold=no

Maximum threshold=no

Tolerance number=no

Probe

no

Save last value only

Configuration

Email alert

Configuration

Data view

ONNumberOfDataSpaceSnapshotsWithoutAnyDescription

Nb. of child dataspaces - snapshots created for a given period [ON] D-I09

Property

Specification

Code

[ON] D-I09

Name

Number of child dataspaces and snapshots created for a given period

Use other indicators

N/A

Specification

This indicator computes the number of created child dataspaces and snapshots for a dataspace during a period (periodicity of control).

The computation is performed in an 'absolute' mode, and not on a rolling basis. For example, for the periodicity 'monthly', if the indicator is executed on April 5 then the period is the five first day of April.

If the periodicity of control is 'any' then all time is considered. In this case the output "from date" is the creation time of the dataspace, and the output "To date" is the execution time of the indicator.

If the periodicity of control is 'none' then the input parameters are used.

The use of the "Use closed snapshots" and "Use closed dataspace" is an option.

Linked records

no

Applied to D.E.C. type

Dataspace

Output parameters

"Number of child dataspaces created": Integer

"Number of snapshots created": Integer

"From date": Timestamps

"To date": Timestamps

Storage procedure

Any resulting value is stored

Reporting table

'Flat data report' - One record is saved in the Flat data report table.

Input parameters

"Use closed dataspaces": Boolean

"Use closed snapshots": Boolean

'From date': Timestamps

'To date': Timestamps

Computation frequency

"On demand"

Periodicity of control and watchdog

Periodicity of control=yearly, semester, quarterly, monthly, weekly, daily, any, none

Minimum threshold=no

Maximum threshold=no

Tolerance number=no

Probe

no

Save last value only

Configuration

Email alert

Configuration

Data view

ONNumberOfCreatedChildDataSpaceForAPeriod

Dataspace lifetime [ON] D-I10

Property

Specification

Code

[ON] D-I10

Name

Dataspace lifetime

Use other indicators

N/A

Specification

This indicator computes the dataspace lifetime in days, between its creation and its closure. If the dataspace is not closed, then the lifetime value is from its creation time to the execution time. If the relational dataspace is closed, this indicator will appear at the master reference service to compute all closed dataspaces that are configured with this indicator.

The same computation is performed for every child of the dataspace except if the input parameter 'Compute parent dataspace only' is set to 'True'.

Linked records

no

Applied to D.E.C. type

Dataspace

Output parameters

'Dataspace name': String

"Lifetime (days)": Interval (the format is defined by configuring the input parameter "Format Day + Time")

Storage procedure

Any resulting value is stored

Reporting table

'Flat data report' - One record is saved in the Flat data report table for each dataspace.

Input parameters

"Compute parent dataspace only": Boolean

'Interval format': enumeration, with such possible value: (x weeks, y days), (x days, y hours), (x days, y hours, z minutes, w seconds), etc.

Computation frequency

"On demand"

Periodicity of control and watchdog

Periodicity of control=no

Minimum threshold=no

Maximum threshold=no

Tolerance number=no

Probe

no

Save last value only

Configuration

Email alert

Configuration

Data view

ONDataSpaceLifetime