How can I get the value of the FixVersion of the current issue?

Questions & Answers
1

I will compare two values and would like to have the FixVersion of the issue. I have a table and the FixVersion shall be visible in the row of the current issue.

It works with the “Fix version IDs”. But I want to have the value behind the Fix Version ID.
CASE
WHEN Val(ExtractString([Measures].[Issue fix versions].Value, ‘.*R(\d+)’, 1)) <
Val(ExtractString([Measures].[Issue Validation in].Value, ‘.*R(\d+)’, 1))
THEN
[Issue].CurrentMember.Get(‘Fix version IDs’) //It shall be get(‘Fix Version’)

WHEN [Measures].[Issue Validation in]=’(none)’ THEN ‘tbd’

ELSE ‘’
END

If I use [Measures].[Issue fix versions] or [[Measures].[Issue fix versions]] I get the error message:
Formula is not valid:
No function matches signature ‘CASE WHEN THEN … END’

If I use [[Measures].[Issue fix versions] I get the error message:
Formula is not valid:
MDX object ‘[[Measures].[Issue fix versions]’ not found in cube ‘Issues’

What can I do to get the value behind if FixVersionID?

2

Hi @Christine ,

Sometimes the CASE WHEN construct gets confused when various data types are used in conditions and returned values. Or empty values are returned. You can enclose the “Issue fix versions” property inside the CoalseceEmpty() function to see the fix version names instead of IDs. See the suggested formula below:

CASE
WHEN Val(ExtractString([Measures].[Issue fix versions].Value, '.*R(\d+)', 1)) <
Val(ExtractString([Measures].[Issue Validation in].Value, '.*R(\d+)', 1))
THEN
CoalesceEmpty([Measures].[Issue fix versions],'')
WHEN [Measures].[Issue Validation in]='(none)' THEN 'tbd'
END

See more details about the CoalesceEmpty() function on the eazyBI documentation page - CoalesceEmpty - eazyBI.

Best,
Roberts // support@eazybi.com

3

Hi Roberts,

thanks for your support. I tried to use your proposal. But I get this error message. I don’t know what this means. Can you support here?
Formula is not valid:
Lexical error at line 2, column 63. Encountered: “\u2018” (8216), after : “”

4

Hi @Christine ,

In some weird way, the single quotes were transformed into backticks. I corrected the formula in my original answer.

Best,

5

Hi Roberts,
it works. Thanks a lot.

1 Like