EazyBI filter on component lead

Thomas Verbeke

Hi,

I created eazyBI reports which I will upload into an iTrack-dashboard. The eazyBI reports are focusing on components with underlying issues. In iTrack, each component is assigned to a component lead. In the iTrack dashboard I'd like to show only report data for the components where the user is component lead.

Anyone with an idea how I can apply this kind of filter to my eazyBI reports in the iTrack dashboard?

Thanks in advance,

Thomas

Zane eazyBI Support

Hi @Thomas Verbeke

If eazyBI reports are shared with authorized users, then you can use that information in the report.

In the Project dimension, you might want to define a new calculated member that would go through all project components and check the component lead name. If the lead name matches the current user name, then show them in the report.

The expression might look like this:

Aggregate(
  Filter([Project].[Component].Members,
    CoalesceEmpty([Project].CurrentMember.Get('Component lead'),"")
      MATCHES CurrentUserName()
  )
)

More details on how to build calculated members and use function CurrentUserName() described in eazyBI documentation:

• https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-other-dimensions
• https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/currentusername

 

Note this solution won't work for reports shared in the iframe with the public token (https://docs.eazybi.com/eazybijira/publish-reports/dashboards-and-reports-visible-to-non-jira-users).

 

Best,
Zane / support@eazyBI.com