Mapping user profile attributes to report dimensions
Edit Metrics configuration files to map various user profile attributes to Metrics report dimensions.
Before you begin
To edit configuration files, you must use the IBM® WebSphere® Application Server wsadmin client. See Starting the wsadmin client for information about how to start the wsadmin command-line tool.
About this task
- com.ibm.snx_profiles.base.countryCode
- Mapped to the Geography dimension in Metrics reports.
- com.ibm.snx_profiles.base.orgId
- Mapped to the Department dimension in Metrics reports.
- com.ibm.snx_profiles.base.title
- Mapped to the Role dimension in Metrics reports.
To see the full list of Profiles attributes that are available through the administration Atom API provided by Profiles, refer to Retrieving the Profiles Administration API service document in the IBM Social Business wiki.
- com.ibm.snx_profiles.base.deptNumber
- com.ibm.snx_profiles.base.countryCode
- com.ibm.snx_profiles.base.orgId
- com.ibm.snx_profiles.base.employeeTypeCode
- com.ibm.snx_profiles.base.workLocationCode
If any of these attributes are used, Metrics shows real values in the reports.
To manage a task, complete the following steps:
Procedure
What to do next
If you update the mapping of Proflies attributes while IBM Connections is running, your changes affect new users only. Existing users who were already mapped to the orgid attribute and are not automatically updated with the new mapping.
To apply your changes to all users, run the MetricsUsersService.reloadUsersAttributes() metrics administrative command. For more information, see the Metrics administrative commands topic.
After you run the command, open the f_users table in the Metrics database and verify that the attribute2 attribute of all users has a value of com.ibm.snx_profiles.base.profileType.
- After you update the Metrics database, the expected Group by report is still not available because the report displays historical data from the power cube. Refresh the power cubes by running the build-all to command.
- Despite refreshing the power cubes, the community metrics report might not be updated because that report is static. The report is updated only after the specified date range for the report expires.