Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Common Types of Mappings required : Usually for source system to target planning or consolidation system following type of mappings are required by the business

Mapping TypeExampleDescription
Explicit - One to OneReporting Unit – DA100Simple One to One Mapping
Like5100?????, *9800Using Wild characters
Range – Between Numeric Values5000 - 6000Alphabetical and numeric ranges required

Range –

Set of Values

5000,6799,9999,S459Set of possible values.
Logic – If then Else

If CURVAL > 0 then

    Result = CURVAL

End If

If the condition is true then only perform mapping

The table below represents the recommended approach that can be followed in FIM mapping tables

Mapping TypeSolution
Explicit - One to OneEnter Direct Value
LikeLeverage FIM string matching operators
Range – Between Numeric Values

[no1..no2]

any number between no1

and no2

Range –

Set of Values

{ABC+;XYZ*}

If the data matches either ABC+ or

XYZ* then the result is true.

Logic – If then ElsePreferable to avoid. ERP assement cycle should to be performed before loading information in FIM
Logic - Multiplication by Factor

[Amount]/1000000

For division by millions

To be discouraged for allocation

Most used FIM mapping operators

Common Errors that needs to be highlighted to business users during FIM training

  1. Do not write the source fields beginning or ending within single quotes.
  2. Do not use comma as a delimiter, semicolon is default delimiter in FIM.
  3. Target fields should begin and end with single quotes if they contain constant strings.
  4. Not using correct source field names while referring it in the target. E.g. if source field name is "DP Year" then space should be maintained while referencing it. Still better is to avoid space in all source field names.
  5. While referring to the source dimension in the target, write the source dimension names in same case as in Source
  6. While concatenating not writing strings within single quotes. E.g. [YEAR]||'.'||[MONTH]  here the dot should be written in single quotes.
  7. Using comma as delimiter instead of 2 dots in range definition E.g. [10000,20000] instead of [10000..20000]
  8. Account, Cost Center fields not padded with Zeros. In case field length would vary in different source systems.



1 Comment