Data Sets

P338C1T5#yIS1

The Data Sets page displays the available data sets for the current match set and provides the ability to create new ones.

A Data Set is the transactional data used for matching. A data set may contain one or many data sources. Each data set may contain the following fields:

P342#yIS1

Field

Description

Name

The name of the data set.

Description

The description of the data set.

Sequence

The sequence (order) of the data set (1,2,3) to be used for display on the Matches and Manual Matches pages. The first data set (DS1) is the primary data set used to compare against the remaining data sets.

Data Security

Security level of the data set (Entity, IC, Entity OR IC, or Entity AND IC) based on members in the Read and Write Data Group or Read and Write Data Group 2 in the Security section of Member Properties on the OneStream Entity.

P358#yIS1

IMPORTANT: Assign the primary data sequence to position 1; match variances are calculated by comparing all subsequent data sets to the primary.

Create a Data Set

  1. On the Match Set Administration page, click Data Sets.

  2. Click Insert Row and then double-click in the following cells to enter information:

  • Name: Enter a display name to identify the data set.

  • Description: Enter additional information you want to display to further identify the data set.

  • Sequence: Enter the number indicating the order you want the data set displayed.

  • Data Security (Optional): Select the security type you want to assign to the data set from the drop-down list or leave the default (Not Enabled) to display everything. This column is visible only when the Data Security option is enabled for the Match Set.

  1. Click Save.

NOTE: Although the Transaction Matching Administrators user group has the access necessary to manage the solution, if Data Security is enabled, the ability to view transactions depends on the individual user’s Entity level security. Users are only able to see transactions for the entities to which they have Read and Write access.

Data Set Fields

Each data set holds up to 47 fields identified by a predetermined field name. Although 50 fields are available, only 47 fields are displayed in the Transaction Matching grid view. Three of the 50 fields are used to display the Transaction ID, Transaction Number, and Comment/Attachment identification.

  • 16 Cube Dimensions: Entity, Account, Scenario, Flow, Time, IC, UD1-8, Label, SourceID, TextValue, WF Profile, WF Scenario, WF Time, and Status WF Time.

  • 16 Text Fields: Attribute Fields 1-16

  • 4 Date Fields: Attribute Fields 17-20

  • 13 Value Fields: Amount and Attribute Value Fields 1-12

Each piece of data contains the following descriptors:

Field

Description

Name

Drop-down list containing the available fields.

NOTE: If integrating Transaction Matching with Account Reconciliations, you must include all Tracking Levels used for Account Reconciliations in your Data Set Name field. See Preparing External Files.

Alias

Freeform text field that describes the friendly name intended to further identify the data in a field.

Column Order

Allows users to see the data/information in a specific order on both Matched and Transactions pages.

Display Format

Formats that numerical values display such as dates, amounts, and decimals throughout the solution, for example:

  • N0 will not show any decimals or zeroes.

  • N1-N6 shows X number of decimals (N2 shows two decimals, N5 shows five decimals, etc.)

  • #,###,0\% displays 10,000% and -10,000%

  • #,###,0.00 displays 10,000.00 and -10,000.00

See Application Properties in the Design and Reference Guide for the complete listing of number formats.

Summary 1–3

Amount or Attribute Value fields displayed on transactions and match grid pages that are used to cross-reference and total up to three value fields to verify that the values are in balance.

NOTE: Summary fields can only be changed before matches exist in a match set.
Detail Item Mapping Select which column in Transaction Matching will populate the detail item in Account Reconciliations.
Editable

Select which fields are editable on the Transactions page directly in the grid.

The following fields cannot be set as editable: SourceID, S.Cons, Cons, S.Scenario, Scenario, S.Time, Time, S.View, View, S.Origin, Origin, WF Profile, WF Time, and Status WF Time.

NOTE: Even if fields are marked editable, they cannot be edited for matched transactions and transactions that are associated to a detail item in Account Reconciliations.

Import Workflows

  1. On the Match Set Administration page, click Data Sets.

  2. Click the data set you want to import into.

  3. In the <Data Set name> Import Workflows pane click Insert Row and then click the new row.

  4. Select a base import workflow from the drop-down list.

  5. Click Save.

NOTE: If multiple import workflows are added, they will be sequentially stacked together into a single data set.