<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-PD6KG7L" height="0" width="0" style="display:none;visibility:hidden">

Version 6.9.4

What's new in Version 6.9.4

New Transform Data - Insert Entity

A new Transform Data in the commission system has been introduced to insert an Entity's EID field and Period Number into a selected Table.

Transform Data Insert Entity

The Transform Data allows the input of the related Table and Entity Type to be inserted. Available Entities are:

  • Participant
  • Team
  • Territory
  • Product
Transform Data Insert Entity

Subsequently, the EID Field and the Period Field can be selected to indicate the fields for the Entity details. If a Period Field is not defined, then the Period Number is ignored and only the Entity EID is inserted.

If the selected Entity Type is Participant, then an option to insert 'inactive' Participants is displayed. By default, this option is unselected, resulting in only active Participants inserted. If selected, then both active and inactive Participants are inserted.

  • Transform Data Insert Entity

New Transform Data - Update Table

A new Transform Data has been introduced for power Administrators to update one to multiple fields on a selected table.

Transform Data Update Table

The new Transform Data allows the following items to be defined to perform a table update:

  • Destination Table: Table to update values into.
  • Reference Table: Table to reference when choosing what values to update into the Destination Table, or to provide Criteria.
  • Set Fields: Field (or fields) to set values in, from either the Destination Table or Reference Table.
  • Criteria: A set of nested and grouped rules to dictate when to set fields
Transform Data Update Table

Example:

Transform Data Update Table

Set Fields

One to many fields can be updated on the Destination Table by setting a field and a set operation: =, SUM, COUNT, AVG, MIN, MAX, COUNTDISTINCT

Transform Data Update Table

Subsequently, a field's value is selected, with the option of selecting a field from the Destination or Referenced Table, or:

  • Input Value...: User-defined (free text input) 
  • Participant EID: User-defined (free text input) 
  • Period: Input Period number of running Calculation
Transform Data Update Table

Criteria

Nested levels of AND and OR conditions can be defined to filter on the data selected for the table update.

The Criteria function allows Groups to be added to enable nested conditions, where the AND/OR condition can be set for each group.

Rules are added for each conditional field being compared. Similar to the Set Field function, the field's comparison value can be set to either a field from the Destination or Referenced Table, or:

  • Input Value...: User-defined (free text input) 
  • Participant EID: User-defined (free text input) 
  • Period: Input Period number of running Calculation
Transform Data Update Table

The Rule's comparison operator can be set to either: =, !=, <, <=,>,>=, IN, IS NULL, IS NOT NULL

Transform Data Update Table

Note: Please speak to your Customer Success or Experience Manager if you would like to enable the Update Table Transform Data feature.

Compare and Migrate Transform Data

In continuation to the new Compare and Migrate Transform Data feature delivered last Release, the Quick Formula and ToDate Calculation Transform Data have now been added to the library of enabled objects for migration.

Enhancements

1. Updated "Hotlinks" to "Shortcuts" in the Administration Dashboard.

Short Cuts

Bugs

1. Fixed the link to the support article provided in the help bubble on the Commission Overrides table.

Override Help Link

2. Fixed all Hierarchy Tree pages (Participant, Team, Territory, Product Group, Market) to not display the URL encoded version of special characters when the entity contains a special character.

3. Fixed the Audit Logs > Administrator page to display the text in the Details field without exposed HTML elements.

4. Fixed the Calculation API to prevent a calculation to be run for deactivated participants.

5. Fixed the Calculation API to run for the selected participants when executing Reverse Lookup Transform Data.