Ranking Management

Icon plus Rating

General - Ranking

The classification function of DataChain is accessible from GenericsData. Logo GenericsData

The number of classifications is not limited.

This function is used to generate a series of rules (or classes) which will be applied to a column of a data block with the aim of classifying the values ​​according to the Positive or Negative response to each rule.

Note that the classifications apply to the columns of the data blocks via the CLASSIFICATION formula. (see Formulas Documentation - RANKING Formula)

Like all the formulas, the CLASSIFICATION formula can be implemented at the level

  • mappings between Repositories and Business Entities LogoGenericsData

  • from the generation of a Formula type virtual characteristic genericsData-color.png[LogoGd, 20,40]

  • of each step of a DataBlock via the formula generator LogoGenericsData

  • when defining a link between two Business Entities LogoGenericsData

  • source representations in HandleData Logo HandleData

Creation of a Ranking

List of Rankings

A Classification is created from the GenericsData module. GenericsData.png

  • Access module GenericsData.GenericsData

  • Choose, in the left menu GenericsData, the option plus.svg

  • Choose the sub-menu Classification

ListRanking

Metadata

  • Click on the New button

  • Each Ranking has a list of metadata. Entering a label is required.

View Metadata Classification creation

Optional input areas allow for more description. An icon can also be assigned to the metadata list of a Ranking.

Two compulsory fields are necessary to carry out the recording and to make it possible to define the various classes of a classification.

  • 1 Label definition: mandatory

  • 2 Rank Description

  • three Make ranking active or inactive

  • 4 If need license

  • 5 Added tag

  • 6 Classification type: defines on which type of data the Classification will be applied, namely

    • String of characters

    • Whole number

    • Large Whole Number

    • Decimal number

    • Date

  • 7 Processing by class: allows to define the result returned according to the positive and/or negative response of the rule.

    • Execute all classes: All classes will be executed on each value. A separator character can be defined to separate each result.

    • Stop on the first positive response: For each value, the rule of each class is executed. As soon as a rule is positive, the corresponding result is returned and the next value is tested.

    • Stop at the first negative response: For each value, the rule of each class is executed. As soon as a rule is negative, the corresponding result is returned and the next value is tested.

    • Execute all classes with a positive response: For each value, the rule of each class is executed. If a rule is positive, the corresponding result is returned and is added to the result already obtained for this value. After all classes are tested, the next value is tested.

    • Execute all classes with a negative response: For each value, the rule of each class is executed. If a rule is negative, the corresponding result is returned and adds up to the result already oheld for this value. Once all classes are executed, the next value is tested.

  • 8 Allows to add the classification (opens a window)

A Ranking is made up of different Classes (or rules)

Creation of a Class inside a classification

The number of classes in a ranking is not limited.

To create a class, use the add button

For each class, a screen makes it possible to define several pieces of information implementing a rule.

Creating a class

1 Class label: Assigns a label to the class.

2 Operator: Choice of operator used to apply the rule. The operators offered depend on the type of classification (Integer, Date, Character string, etc.)

3 Value to search for: Value that will be used for the test

3 Value to return if positive: Value that will be returned by the formula if the rule applied to the value is positive.

four Value to return if negative: Value that will be returned by the formula if the rule applied to the value is negative.

6 Case Sensitivity: Check to make case insensitive.

Depending on the type of ranking, different features will be available

Creating a class

1 Class label: Assigns a label to the class.

2 Operator: Choice of operator used to apply the rule. The operators offered depend on the type of classification (Integer, Date, Character string, etc.)

3 Lower bound: Value used by the test in combination with the operator.

3 Upper bound: Value used by the test in combination with the operator.

3 Value to return if positive: Value that will be returned by the formula if the rule applied to the value is positive.

four Value to return if negative: Value that will be returned by the formula if the rule applied to the value is negative.

Warning It is important to save the classification regularly between the entry of each class to avoid losing the construction of the classification in progress.

A classification contains several classes presented as follows:

lScreenClass.png

1 Plus button allows you to add a class to the current ranking

1 Button to remove a class from the current classification

3 Button to edit a class of the current classification

4 Zone allowing to move, by Drag&Drop, the Class. Realizes the change of the order of the classes in a classification.

information Order is important to consider in the following types of ranking behavior: Stop on first hit and * Stop at the first negative answer*

Examples of applying a classification on a column

As an example

Age First name

12

ANDRE

25

LEON

9

MARRIED

65

MARTINE

45

MARINE

71

JEANS

35

JOAN

We carry out the following classification which will be applied to the column Age with the following formula CLASSEMENT(Age,Tranche d’age)

Wording Operator Result if Positive Result if Negative Value 1 Value 2

< 10 years

inferior

< 10 years (+)

>= 10 years(-)

10

>= 10 and < 50

in the meantime

>= 10 years and < 50 years (+)

< 10 years or >= 50 years (-)

10

49

>= 50 years

greater than or equal to

>= 50 years (+)

< 50 years (-)

50

  • Execute all classes: All classes will be executed on each value. A separator will make it possible to define a character of separation between the various results.

The formula returns

Age First name Class

12

ANDRE

>= 10 years (-); >= 10 years and < 50 years (+); < 50 years (-)

25

LEON

>= 10 years (-); >= 10 years and < 50 years (+); < 50 years (-)

9

MARRIED

< 10 years (+); < 10 years or >= 50 years (-); < 50 years (-)

65

MARTINE

>= 10 years (-); < 10 years or >= 50 years (-); >= 50 years (+)

45

MARINE

>= 10 years (-); >= 10 years and < 50 years (+); < 50 years (-)

71

JEANS

>= 10 years (-); < 10 years or >= 50 years (-); >= 50 years (+)

35

JOAN

>= 10 years (-); >= 10 years and < 50 years (+); < 50 years (-)

  • Stop on the first positive response: For each value, the rule of each class is executed. As soon as a rule is positive, the corresponding result is returned and the next value is tested.

The formula returns

Age First name Class

12

ANDRE

>= 10 years and < 50 years (+)

25

LEON

>= 10 years and < 50 years (+)

9

MARRIED

< 10 years (+)

65

MARTINE

>= 50 years (+)

45

MARINE

>= 10 years and < 50 years (+)

71

JEANS

>= 50 years (+)

35

JOAN

>= 10 years and < 50 years (+)

  • Stop at the first negative response: For each value, the rule of each class is executed. As soon as a rule is negative, the corresponding result is returned and the next value is tested.

The formula returns

Age First name Class

12

ANDRE

>= 10 years (-)

25

LEON

>= 10 years (-)

9

MARRIED

< 10 years or >= 50 years (-)

65

MARTINE

>= 10 years (-)

45

MARINE

>= 10 years (-)

71

JEANS

>= 10 years (-)

35

JOAN

>= 10 years (-)

For the following tests, we add two classes

Wording Operator Result if Positive Result if Negative Value 1 Value 2

< 10 years

inferior

< 10 years (+)

>= 10 years(-)

10

>= 10 and < 50

In the meantime

>= 10 years and < 50 years (+)

< 10 years or >= 50 years (-)

10

49

>= 50 years

greater than or equal

>= 50 years (+)

< 50 years (-)

50

Young

less or equal

Youth

20

Less Young

superior

Less Young

20

  • Execute all classes with a positive response: For each value, the rule of each class is executed. If a rule is positive, the corresponding result is returned and is added to the result already obtained for this value. After all classes are tested for a value, the next value is tested.

The formula returns

Age First name Class

12

ANDRE

>= 10 years and < 50 years (+); Youth

25

LEON

>= 10 years and < 50 years (+); less young

9

MARRIED

< 10 years (+); Youth

65

MARTINE

>= 50 years (+); less young

45

MARINE

>= 10 years and < 50 years (+); less young

71

JEANS

>= 50 years (+); less young

35

JOAN

>= 10 years and < 50 years (+); less young

  • Execute all classes with a negative response: For each value, the rule of each class is executed. If a rule is negative, the corresponding result is returned and is added to the result already obtained for this value. Once all classes are tested, the next value is tested

information It is advisable to save the metadata panel, classification type and Processing type as soon as you enter. Use the button Save button located in the right part of the top banner of the ranking screen.

Editing a DataChain Ranking

  • GenericsData module. Logo GenericsData

  • Click on Icon plus.svg

  • Click on menu Rankings

  • At the level of the list of classifications, find the classification to be edited. It is possible to use the search and sort functions present at the level of each column.

  • Select line

  • Click on the classification label or on the edit icon at the end of the line.

Removing a ranking

  • MBdule GenericsData. Logo GenericsData

  • Click on Icon plus.svg

  • Click on menu Rankings

  • At the level of the list of classifications, search for the classification to delete. it is possible to use the search and sort functions present at the level of each column.

  • Select line

    • Option 1: Use the button icon suppression at the end of the line and confirm the action.

    • Option 2:

      • Click on the label of the ranking or click on the icon edit at the end of the line.

      • Once in ranking edition. Click on the Delete button and confirm the action.

Quick Reference

Creating a ranking list-alt.svg

Steps Objective Stock Landmarks

1

Access to the GenericsData module

Click on the GenericsData icon

Logo GenericsData

2

Choice of Menu Ratings

Click on Miscellaneous plus then on Ratings list-alt.svg

plus

3

Creation of a Ranking

Click New Button

New

4

Entering Metadata information

Enter a label required

5

Definition of the Classification type

Choose a type of behaviour of the Ranking

6

Definition of all the Classification classes

Enter each class by defining the rule

7

Registration of the ranking

Click on Save button

save-light_button