TRANSFORMER

Node mapping

Use a Node mapping process to manually connect data in streams to nodes in the BMP system, i.e. describe how data from the source is to be connected to target nodes. Node Mapping is static. It is usually used with a BMP data records target which has automatic node creation built in.

Creating a Node mapping process

To create a Node mapping process, right click in the Transformer design panel, choose Process -> Node mapping. Connect it to the previous process as described in Processes. Double click the object to configure it.

Properties

General

Name - the name "Node mapping" is generated automatically but it may be changed
Description - an optional text describing the process

Audit

Modified by - the name of the last user to make changes to the object.
Last modified - the date and time when the object was last changed.
Created by - the name of the user who created the object.
Created - the date and time when the object was created.

Custom

In the Table column drop-down at the top of the screen, choose the column from the source that contains the data to be used as node ID.

When the column has been selected, the left-hand pane will contain the values from the Source column.

The right-hand pane shows the nodes that are available in the BMP database. You can search for a specific node by writing the search criterion in the Search field and clicking the Search icon .

To choose which data from the Source to map to which node(s), click the desired value(s) in the left-hand pane. Hold down the 'Ctrl' button for multiple selection. A Function consisting of the Table column name and the selected value(s) will be displayed in the Function field in the middle of the screen. It is also possible to enter selection criteria manually, using valid syntax.

Then mark the desired node in the right-hand pane, and click the Add button to create a new node mapping.

The node mapping rule will now be displayed at the bottom of the screen, under Function and Destination, e.g. ${NodeID} = "102" in Function and "102 Other costs" in Destination means that records with NodeID = 102 in the source are mapped to the node with ID = "102" and Name = "Other costs".

To change a mapping rule, mark it, then mark the correct value in the top left-hand column and/or the correct node in the top right-hand column at the top and click the Change button.

Use the Up and Down buttons to the right to change the order of the mapping criteria.

Depending on the rules you have defined, their order may be important.

Use the Remove button to delete a mapping.

Node mapping uses only the number of rows specified in Max preview rows. I.e. if Max preview rows is set to 100, only the first 100 rows in the source will be mapped. Default value is 5000. You may want to set it lower during development, but remember to increase it again when you have finished creating and testing your project and are ready to run it, to make sure all rows are included in the run.