I have a report which will filter based on issue type and show the hours logged on those jiras.
But my client request to validate based on few issue types and containing text in issue title.
Example:
My filter should not show issues with issue type = IPAD and summary contain text = IPAD and it should show issues with issue type other than “IPAD” and summary does not contain text = “IPAD”
Could someone help to get this resolved
Please find the attachment which will show you my report sample with text as “IPAD” in issue title
We have more than 60,000 issues in our Cube, and we have to filter the issues which are “Issue Type” <> iPad and Summary not contains 'iPad" Text. This filter should be created in “Issue Type” Dimension. (Issue Type Dimension is available in Pages).
Kindly advise. we are facing performance issue when we create same calculated member in “issue Type” dimension. and trying to filter the issues.
please share if you need more information. thanks in advance.
we have two filters in "Issue Type " dimension which is located in Pages.
With IPAD issues
Without IPAD Issues.
when i select the first filter, it should filter all the issues (rows) including issue type = IPAD
When i select the second filter, it should filter all the issues excluding issue type =IPAD and issue title does not contain text as ipad.
So, now could you please where i need to create your filter.
Did you consider option not to import these issues in the eazyBI at all?
Please note the JQL filter option in Jira import options screen where you can define which issues should be imported (and which shouldn’t) in your eazyBI cube.
That would decrease the number of issues in your cube so all the reports would be faster.
If that is not an option and you still need rest of issues imported, perhaps you could create a new pre-calculated custom field using Javascript in eazyBI advanced settings.
Then you could import this custom field as a separate dimension and use this new dimension for much faster calculation than MDX with regular expressions (Matches method).
That would be much faster considering you have 60k+ issues imported on your account.