# Managing User Source

# Adding a New User Source

A User Source is a destination field source connected to the User dimension. It creates a dimension property that can be reported using the user dimension.

All destination field sources are predefined and cannot be edited and deleted. Follow these instructions to add new user source:

1. Click the New User Source button located at the bottom-right corner of the destination field source table.

   The Add user source pane should appear.

2. Accomplish the details of the new user source.

   Detail	Description
   Name	Descriptive name for the new user source.
   Default Value	Used as the default member of the attribute.
   Historic	Signifies that the source is changing over time.

   Administration: Mapping Source User Source Field
   
   

3. Click Save to continue.

   A notification message should appear at the top of the page.

# Reporting New Source

Since the newly created user source is created as one of the properties of the User dimension, there is a special instruction in reporting it through Microsoft Excel.

To report, follow these instructions:

1. Open Microsoft Excel.

2. Connect to an Analysis Services databases. Please follow instructions on how to connect from Microsoft Excel to Analysis Services database, found in the Open iT External Reporting Guide.

3. Once connected, create a report with User Id on the Data Row field.

4. Right click on one item of the User Id, choose Show Properties in Report and select the newly added user source.

5. Another column will appear in the report with the header named after the newly created user source.

   

   Analysis Server Mapping Sources: Reporting New User Source

# Deleting an added User Source

Only the added user source can be deleted.

To delete an added user source:

1. Click the delete () symbol beside the destination field name.

2. A warning message should appear confirming the deletion of the item.

3. Click OK to continue