# Managing Mapping Sources

The Mapping Sources page contains various functionalities to configure and set up sources of mapping. Some of the examples that are always configured are user-to-groups.map and user-properties.map mapping files, which are manually created using instructions from the Core Server Web Interface > Administration > Mapping and are located by default in C:\Program Files\OpeniT\Core\Configuration.

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 user-properties.map mapping file usually contains user details from the Active Directory such as:

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

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

# Adding a Mapping Source

1. Create a mapping source for user-to-groups.map. Click the New Mapping Source button.

   The edit pane will appear.

2. Configure the details of the mapping source:

   Detail	Description
   Name	The descriptive identifier of the mapping source. Name it user-to-groups.map.
   Enabled	The switch to enable or disable the mapping source. Set it to True.
   Kind	The type of the mapping source file. Supports Multimap and CSV, with Multimap being the recommended option.
   FilePath	The mapping file's relative path, which is by default in C:\Program Files\OpeniT\Core\Configuration.
   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.

   Mapping Source Fields

3. Click Save to add the mapping source.

   

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

4. Create another mapping source for user-properties.map. Click the New Mapping Source button.

   The edit pane will appear.

5. Configure the details of the mapping source:

   Detail	Description
   Name	The descriptive identifier of the mapping source. Name it user-properties.map.
   Enabled	The switch to enable or disable the mapping source. Set it to True.
   Kind	The type of the mapping source file. Supports Multimap and CSV, with Multimap being the recommended option.
   FilePath	The mapping file's relative path, which is by default in C:\Program Files\OpeniT\Core\Configuration.
   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.

   Mapping Source Fields

6. Click Save to add the mapping source.

   

   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
   
   

# Configuring Destination Field Sources

Follow these instructions to assign a mapping source to various destination types used for reporting:

1. Look for user-to-groups.map from the source list, then click Load Fields.

   

   Analysis Server Mapping Sources: Loading Mapping Sources

   In the Destination Field Source table, the column of the selected mapping source should be filled with values.

2. Map the following source values by clicking the radio button beside the row value then select the same destination value:

   Destination	Source Value
   User.Department	department
   User.Division	division
   User.Location	l

   Destination Field Source
   These are the default configurations for the Destination Field Sources. To add or remove attribute values, follow step number 4 in the Configuring LDAP Settings section.

3. Click Save Configuration to apply the changes.

   

   Analysis Server Mapping Sources: Configuring Mapping Sources

4. Configure another mapping source by looking for user-properties.map, then click Load Fields.

   

   Analysis Server Mapping Sources: Loading Mapping Sources

   In the Destination Field Source table, the column of the selected mapping source should be filled with values.

5. Map the following source values by clicking the radio button beside the row value then select the same destination value:

   Destination	Source Value
   User.DisplayName	displayName
   User.Mail	mail
   User.PhysicalDeliveryOfficeName	physicalDeliveryOfficeName
   User.Title	title

   Destination Field Source
   These are the default configurations for the Destination Field Sources. To add or remove attribute values, follow step number 4 in the Configuring LDAP Settings section.

6. Click Save Configuration to apply the changes.

   

   Analysis Server Mapping Sources: Configuring Mapping Sources

   Repeat these steps to configure multiple mapping sources.

# Verifying Mapping Sources Configuration

Follow these instructions to check whether the mappings have been successfully configured in the License Monitor Portal:

1. Go to the License Monitor Portal's Web Interface.

   For detailed instructions, refer to the License Monitor Portal section.

2. Select an item from the list of vendor licenses.

3. Click on a feature from the list. Check if it displays only the UserName instead of the Display Name.

   

   Analysis Server Home - License Monitor Portal
   
   

4. Run the command SyncMapping. To do this, follow the instructions in the SyncMapping section.

   The configurations will be applied in the next scheduled ETL process. To manually sync and preview the configured mappings immediately, proceed to the next step.

5. Run the command ProcesSql. To do this, follow the instructions in the ProcessSql section.

6. Run the command SyncLicenseStatus /reload. To do this, follow the instructions in the SyncLicenseStatus section.

7. Refresh the License Monitor Portal page.

   This should now show the Display Name instead of the UserName. Click on the Display Name to view the details, including UserName, Mail, Department, Division, Manager, EmployeeType, Location, CostCenter, and PhysicalDeliveryOfficeName, if available.

   

   License Monitor Portal: View Details
   
   

# Previewing a 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
   
   

# Recommended Reading

The following configurations are required for Mapping Sources to function properly.

   Configuring LDAP Collector

   Mapping