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

NOTE

The User dimension property can only be reported through Microsoft Excel. This cannot be used as a filter in a report.

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

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.

   Mapping Source User Source Field
   
   

3. Click Save to continue.

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

   warning

   Make sure to follow the instructions displayed in the note when adding a new user source.

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 for reporting it through Microsoft Excel.

To report, follow these instructions:

1. Open Microsoft Excel.

2. Connect to an Analysis Services database. Please follow instructions on how to connect from Microsoft Excel to an 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.

   

   Reporting New User Source

Deleting an Added User Source

Only the added user source can be deleted.

Deleting User Source

To delete an added user source:

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

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

3. Click OK to continue.