Hello,
Is there a way to filter a report only to active users ?
I have some reports witch show hours spent by user and I would like to see only active users.
Olivier
Hi Oliver,
Currently, we don’t import additional property for “active users” in any of user dimensions by default, therefore it would not be possible to filter active users in a simple way.
For Jira Server add-on clients we recommend using additional data import via SQL select from the database and then map this information to existing user dimensions to import as additional properties.
https://docs.eazybi.com/display/EAZYBIJIRA/Additional+data+import+into+Jira+Issues+cube
Martins / eazyBI support
Hi Martins, do you support Active user property in latest eazy bi addon for jira server edition?
Hi @jekson
eazyBI creates user dimension members from imported issues or worklogs
Perhaps, you can elaborate on your question. What do you mean by “Active user property”?
Martins / eazyBI support
active user means those users only who are active in JIRA, we do not want to display users who have left organization
Hi,
Thanks for the clarification.
Currently, eazyBI does not import the attribute “active” (and “inactive”) for any user dimension. You can import this attribute as additional property for any user with additional data import.
Then you can use this property to filter out active users only by creating a new calculated member which aggregates user dimension member by new property
https://docs.eazybi.com/display/EAZYBIJIRA/Additional+data+import+into+Jira+Issues+cube
Or you can try creating a calculated member in user dimension by dragging manually only active users
Martins / eazyBI team
Since version 6.4.2 you can create new custom hierarchies in the user dimensions.
That means you can use SQL query and import additional data into Issues cube and map this data to user dimension (such as Assignee, Reporter or Logged by) at the user level.
Try this query in DB:
SELECT u.user_name AS "Username",
"Active"
FROM cwd_user u
WHERE u.active = 1
Then create a new custom hierarchy and finally select the active users in the report.
Martins / eazyBI
If you don’t have access to eazyBI db, you can try using the Rest API endpoint to retrieve all users with property “active”
/rest/api/2/user/search?username=.&includeInactive=true
Then import the property to user level members and create custom hierarchies
Martins / eazyBI