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

 Analysis Server Mapping Sources: Adding New User Source

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

    Analysis Server Mapping Sources: Reporting New User Source

# Deleting an added User Source

Only the added user source can be deleted.

 Analysis Server Mapping Sources: Deleting User Source

Analysis Server Mapping Sources: Deleting User Source

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

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