Create project specific report using the EasyBI

[Pavani Maligi]

Hi ,

I am using EasyBI for Jira.I wanted to create report at project level and send the report to each project manager. Something manager will get report only related to his project.Is this possible using EasyBI.

Regards

Pavani

[Janis Plume _eazyBI_]

Pavani,

The closest workaround for your use case would be to use the "CurrentUser" function and the "Project lead" property in the Project dimension. It is possible to create a calculated member in the Project dimension filtering the projects managed by the user currently logged in.

The formula of the calculated member in the Project dimension ('My projects') is the following:

Aggregate(
 Filter(
 [Project].[Project].Members,
 [Project].CurrentMember.get('Project lead')=
 [Assignee].[User].GetMemberbykey(CurrentUser()).Name
 )
)

The limitation of this solution is that CurrentUser returns the user key, but the Project property stores the display name of the user and we need to utilize some of the User dimensions (e.g. Assignee) to map the user key to the display name. There might happen that the project manager has never been an assignee of an issue; in this case, the solution will not work.

Now you can use the "My projects" member in the report to have the report containing data for the project manager.

The sharing of the report to users via email needs the dashboard subscription which is done by each project manager (see here for more).

Kindly,