Filter on active user

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

@martins.vanags

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