# Managing Mapping Sources

The MappingSources page contains various functionalities to configure and set up sources of mapping. Some of the examples that are always configured are user-properties and user-to-groups.map mapping files from the Core Server located in the Configuration directory, which is by default in C:\Program Files\OpeniT\Core\Configuration.

The user-properties mapping file usually contains user details from the Active Directory such as:

  • Display Name
  • Employee Type
  • Mail
  • Manager
  • Physical Delivery Office Name
  • Title

The user-to-groups.map mapping file usually contains one-to-many usergroup to users mapping, which are also from the Active Directory with the following commonly used group types:

  • Cost Center
  • Department
  • Division
  • Location

The page is only visible to users with administrative rights to Analysis Server.

# Adding a Mapping Source

  1. Prepare the mapping file to configure.

  2. Click the New Mapping Source button.

    The edit pane will appear.

  3. Configure the details of the mapping source:

    Detail Description
    Name The descriptive identifier of the mapping source.
    Enabled The switch to enable or disable the mapping source.
    Kind The type of the mapping source file. This supports Multimap and CSV.
    File Path The absolute path of the mapping file.
    Separator The type of separator used in the mapping file. Only applicable for CSV.
    Identity Field The field that uniquely identifies a record in the mapping file. Only applicable for CSV.
    Administration: Mapping Source Fields

  4. Click Save to add the mapping source.

    Analysis Server Mapping Sources: Adding Mapping Sources

    Analysis Server Mapping Sources: Adding Mapping Sources

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

    Analysis Server Mapping Sources: Added Mapping Sources

    Analysis Server Mapping Sources: Added Mapping Sources

# Populating Identity Field

Follow these steps to populate the Identify Field option when configuring a CSV file:

  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.

    Analysis Server Mapping Sources: Added Mapping Source - CSV

    Analysis Server Mapping Sources: Added Mapping Source - CSV

  4. Choose among the values.

  5. Click Save to apply the changes.

    Analysis Server Mapping Sources: Save Identity Mapping Source - CSV

    Analysis Server Mapping Sources: 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.

    Analysis Server Mapping Sources: Saved Identity Mapping Source - CSV

    Analysis Server Mapping Sources: Saved Identity Mapping Source - CSV

# 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.

  3. Click Save to apply the changes.

    Analysis Server Mapping Sources: Editing Mapping Sources

    Analysis Server Mapping Sources: Editing Mapping Sources

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

    Analysis Server Mapping Sources: Edited Mapping Sources

    Analysis Server Mapping Sources: Edited Mapping Sources

# Previewing a Mapping Source

The preview functionality is only applicable for CSV type mapping source. Follow these instructions to preview a CSV mapping source:

  1. Look for the CSV mapping source to preview from the list.

  2. Click the Preview button.

  3. The preview should appear under the sources list.

    Analysis Server Mapping Sources: Previewing Mapping Sources

    Analysis Server Mapping Sources: Previewing Mapping Sources

We value your feedback!

Please take a few minutes to complete our survey and share your thoughts on your recent experience with our documentation.

Take survey

Close