I searched around to see if there were similar posts, but I couldn’t find any.
I have a custom field named “Reporter Location from AD” This returns around 145 different locations around the world. I created a customer measure for 9 different regions. The MDX is like this:
When [Reporter Location from AD].CurrentMember.Name MATCHES ‘.North Dakota.’
*and so on THEN ‘Central’
When [Reporter Location from AD].CurrentMember.Name MATCHES ‘.Kentucky.’
*and so on THEN ‘EastCoast’
That worked out great (I think. Maybe not the correct way to go about this).
However, the data being displayed still lists out all 140+ locations. I just want to see this consolidated “Region” and the Issue Created number. I have attached a screenshot of how it is now. The Rows showing all the more specific location is what I don’t want to see or at least hide somehow. But removing it, removes the needed information.
I am very new with EazyBi, don’t use it much, but found this was the only way to represent the needed location data from Jira Cloud since it isn’t tied directly into Active Directory. Thanks for any help or tips!
Hi @Tacoman
Your calculation is referencing [Reporter Location from AD].CurrentMember.Name and, thus, the location will be visible only when you have the full list of your “Reporter Location from AD” dimension members in rows. You could create separate calculated members in the “Reporter Location from AD” dimension, but the report will have some performance issues with MATCHES and 140+ locations.
The best would be using additional import and adding a custom property to your field “Reporter Location from AD.” You can create a custom hierarchy in your custom field based on the property. Here you can read more about it in our documentation: Custom hierarchies
This will allow you to aggregate your values in the “Reporter Location from AD” dimension, and then you can select measures from the “Measures” dimension to see the values per each location.
Here is an example from the eazyBI Community using the “Assignee” dimension:
