Custom User Attributes
In addition to basic user attributes like
department, Teamwork Analytics allows you to report on custom user attributes from your active directory (we currently support Directory Extensions).
Gathering the attributes
To configure custom attributes, you must add their names to the
configuration.CustomUserProperties table in the TWA SQL database.
The table has one column called
Name which supports alphanumeric characters and underscores (
_), as in the following examples:
The next time TWA queries user data it will search for these attributes and save any values it finds to the SQL database within the
Filtering by custom attributes in Power BI
To configure custom attributes to show up in your Power BI reports, you must add their names to the
configuration.CustomUserPropertiesForReports table in the TWA SQL database.
The table has numbered CustomAttribute columns for their corresponding filter in Power Bi. The values must match whichever custom attributes names you have previously configured in the
configuration.CustomUserProperties table to use. They can be in whatever order you wish for them to show up in, such as in the following example.
There can only be one row in this table and we currently only support up to 10 custom attributes to show in Power BI at a time.
These configured filters will then be displayed in the filter bar in all supported pages.