Configure Mapping Sources

Adding Alias to Destination Fields

Alias is used to replace the static name of the destination field. This is to customize the fields in reporting. Follow these instructions to add alias:

1. Look for the field to assign an alias from the Destination Fields Sources table.

2. Click the Alias column of the field to assign. This should transform into a textbox.

   Type the desired alias.

   NOTE

   Hover the question mark icon to see some limitations in setting the alias.

3. Click the Save Configuration button to apply the changes.

   

   Adding Alias to Destination Fields

4. Reprocess the OLAP database using the command OpeniT.Server.Etl.Console.exe ProcessOlap with the Analysis Server console application.

5. After a successful reprocessing, verify if the aliasing is successful through the Analysis page and expanding the User dimension in the Pivot Table Fields.

   The aliased attribute should be present.

   

   Aliased Destination Fields

Editing a Mapping Source

Follow these instructions to edit a mapping source:

1. Look for the mapping source to edit.

   The edit pane should appear containing the details of the mapping source.

2. Modify the details as needed.

3. Click Save to apply the changes.

   

   Editing Mapping Sources

   A notification message should appear at the top of the page and the sources list should automatically be updated.

   

   Edited Mapping Sources

Populating the Identity Field

NOTE

This option is only available for CSV mapping sources.

Follow these steps to populate the Identify Field option:

1. After saving the mapping source, notice that the Identity column is red.

2. Click Load Fields of the created mapping source.

3. Click Edit. The Identity Field will be populated with column values.

Added Mapping Source - CSV

4. Choose among the values.

5. Click Save to apply the changes.

   

   Save Identity Mapping Source - CSV

   A notification message will appear at the top of the page and the sources list will be updated with the chosen identity.

   

   Saved Identity Mapping Source - CSV