Overview
This topic identifies the key steps involved in checking rules and mappings which have been applied, adding missing rules and applying these to the data. This will also explain how to update variable descriptions to avoid <unknown> or ***auto-created*** in your report.
Checking and Updating Rules in a Conversion Table
Before running the Item Code Mapping MultiTask, you are able to check the rules which will be applied to the item codes based on the entries they have for other variables. For general information, please see Item Code Classification Variables Mapping Tables.
Depending on if the variable is a classification based rule (3rd character is C) or an item code rule (3rd character is I) will depend on how to check and update the Source Code part of the rules.
If the rule is classification based then the Source Code in the rule will be broken down as follows:
[Target Variable Index] C [Source Variable Index] [Source Variable Value]
The index relates to the variable number used, this can be found in Item Code Classification Variables Maintainence. The indexes used should relate to the variable you are entering the Target Code in as well as the variable IFP is searching within. For example the Source Code 01C03ATR will be entering the Target Code in variable 01 (Local BU) for all codes which have an entry in variable 03 (Local Brand) which is ATR.
If the rule is item code based then the Source Code in the rule will be broken down as follows:
[Target Variable Index] I [Source Item Code]
For example the Source Code 01IABC01_PH_01_?? will enter the Target Code in variable 01 (Local BU) where the item code is ABC01_PH_01 and then any characters on the end as the ?? represent wildcards.
Once you have updated the Source Code you will then need to check / update the Target Code, Factor and Description as follows:
- Target Code - This is the entry you want to add to the Target Variable Index set above. If you are unsure on the code used in IFP then these can be found in the relevant Item Code Classification Maintenance Values table
- Factor - For mapping tables this will always be 1
- Description - This is a suitable description for the rule in question
Applying the Item Code Mapping MultiTask
There has been a MultiTask setup in the database in order to apply the mapping rules found in the Code Conversion Table to variables which do not currently have an entry for the variable in question. To run the MultiTask:
- From IFP Home select Databases/Files > AutoTask Manager > Item Mappings
- Select the Assign All Item Mappings MultiTask and from the toolbar click Run
- Click Run AutoTask and check any warning messages to ensure all items were mapped successfully.
You can view an AutoTask’s Properties (selections, favourites etc.) by selecting the AutoTask and clicking the Properties button. If you need to change these Properties, see How to Edit an AutoTask.
Checking Mappings which have been applied
Once the field mappings have been applied these can be checked in 2 ways:
- Load the Item Codes Maintenance for all Item Codes and check the records have the expected mappings
- Run reports which will show the hierarchy of Item Code, Brand, Local Franchise, Local BU
If there are any mappings which are incorrect you can update these manually in Item Codes Maintenance or update the relevant conversion table rules and apply these.
Manually Applying Mapping Tables
If you find a mapping is incorrect and the rule has been updated, you will need to change this in Item Codes Maintenance. This can be done as explained in Applying Item Code mapping Models.
When applying these IFP will apply the rules to all cells selected for the corresponding variable. Therefore if you are only updating a specific code / set of codes within a variable, for example Brand ABC should be moved from Local BU 01 to Local BU 02, then when making selections for Item Codes maintenance you should include Brand ABC only.
Updating Variable Descriptions
Once you have updated the mappings and applied these, you should update the Item Code Classification Variables list for any variable which has a new entry. For more information on this please see Maintaining Classification Variables Codes and Descriptions.
Comments
0 comments
Please sign in to leave a comment.