I have a table view that shows the in progress issues of a certain project.
The table shows the issue name + key, the status etc. I have imported the issue links Blocks and Is blocked and I want to add to the table next to the status column the Is Blocked column, which should show the issue name + key of that Is blocked issue.
I have put the Is Block dimension in the rows section and activated the Is Blocked at all members at level Is Blocked. It now shows me indeed the Is blocked issues in the table but at the same time it filters out the project issues that donât have a Is Blocked relationship. I do want to still see them as well. How can I do that?
To stretch this requested a bit more, would it be possible to show the status of those Is Blocked issues in the same table?
Hi @Jlf4EazyBi ,
I would suggest adding the âIs Blockâ dimension at the âAll levelâ and expanding it, and then you will also see those issues from the âIssueâ dimension that doesnât have this relationship.
And if you need some measures, e.g., see block issues statuses, check this training account were are some example measures you can use in your report. Copy the measures in your account, and adjust the dimension name âBugsâ in the formulas to the name you are using for your issue link dimension: Stories with Bugs details - Issues - eazyBI Demo Training - eazyBI
They âIs Blockâ at âAll levelâ is giving me indeed the whole list but the expand makes the list twice as larges at it already is. I have around 120 jira tickets listed and with the expand it doubles the row count. Is it possible to have a mdx code that give the best of both worlds, so give the all hierarchy level members at level âIs Blockedâ and if the result is empty still show the row just with an empty Is Block cell.
Then when I import the demo chart to see block issues statuses, I get an error âMDX object â[Bugs]â not found in cube âIssuesââ. In my case the blocking issue is not always a bug, can be anything.
Hi @Jlf4EazyBi ,
First about the âerror âMDX object â[Bugs]â not found in cube âIssuesâââ - you need to copy the formula and replace dimension name âBugsâ to the dimension name you have in your account.
Thanks for your response. Because of the error the import of the chart (and included formulas) is not successful and thus I canât see and modify the formulas. Any advise on that or can you copy the formula of âissue bug with statusâ here?
To further explain, the dimensions in the demo account are read only. Normally when I import a demo report into my own account the dimensions become editable so I see see the MDX code and modify it as need. In this case the import stops due to the Bugs not found in cube error.
Hi @Jlf4EazyBi ,
Yes, you need to do a little bit differently in the training account if you have a different name for your linked dimension.
Press formula for the one you want to copy and manually copy the formula:
Create a new calculated measure in your eazyBI account and manually replace the â[Bugs]â with the name you have, e.g. âIs Blockâ. Here is an example of the formula for âIssue bugs with statusâ:
-- annotations.group = 4 Issue links and hierarchies
Generate(
-- get a list of 'Is Block' issues
[Issue].[Issue].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get('Is Block')
),
-- show by key
cast([Issue].CurrentHierarchyMember.Key as string)
|| " - " ||
-- show 'Is Block' status
[Status].[Status].GetMembernameByKey(
[Issue].CurrentHierarchyMember.Get("Status ID")),
chr(10))
-- annotations.group = 4 Issue links and hierarchies
Case
When
[Bugs].Currentmember is [Bugs].Defaultmember
Then
Generate(
-- get a list of linked issues
[Issue].[Issue].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get('Bugs')
),
-- show by key
"[*"||
cast([Issue].CurrentHierarchyMember.Key as string)
||"*](https://eazybi-training.atlassian.net/browse/"||cast([Issue].CurrentHierarchyMember.Key as string)||")"
|| " - " ||
-- show issue status
[Status].[Status].GetMembernameByKey(
[Issue].CurrentHierarchyMember.Get("Status ID")),
chr(10))
END
Hi @Jlf4EazyBi ,
We as eazyBI donât provide training, but we have training videos on our documentation about eazyBI: Training videos and also some resources about MDX in videos from eazyBI Community Days: Training videos on specific topics