Fix Version properties missing?

Questions & Answers
1

I see many examples here on determining the earliest Release Date for a set of Fix Versions etc.

My problem is that Fix Versions seem to be imported without any properties at all and, as a result,I can’t make use of release date info in any measures.

I’ve tried creating a debug measure with the following and they all return empty or unexpected results.

  • [Fix Version.By name].[‘fix version name’].Get(‘Release date’)
    • Returns nothing.
  • [Fix Version.By name].[‘fix version name’].GetDate(‘Release date’)
    • Returns nothing.
  • [Fix Version.By name].[‘fix version name’].AllProperties
    • Returns: KEY: ‘fix version name’.

I’ve double-checked that ‘fix version name’ has a release date defined in Jira. I’ve also tried fully reimporting all data for the eazyBI account. I’ve looked in the import settings for the account and don’t see anything specifically related to the Fix Version field.

Any ideas?

2

FixVersion properties are stored under the Fixversion.Project because each Fix Version belongs to only one project.
So, if you have a report like:

image
image1024×644 71.3 KB

you will find something like:

KEY: ABC
URL_ID: 100314
DISPLAY_KEY: ABC
Start date:
Release date: 2023-06-05
Status: Archived or Released
Description: blabla

And it will have the same behaviour if you add nested the Issue Dimension.

So, not sure how you want to create your report. However, it can used as Testing purposed for you.

3

Hello @chrispy35 ,
As @Nacho already mentioned, properties for “Fix Version.By name” are available at the project level:

  • Try this formula to see all available properties:
[Fix Version].CurrentHierarchyMember.AllProperties
  • Or to get the “Release date” specifically:
[Fix Version].CurrentHierarchyMember.Get('Release date')

best,
Gerda // support@eazybi.com

4

Thanks @gerda.grantina and @Nacho ,

I did a bit more digging and have confirmed that the data is present in the cube but is not accessible in the way I am expecting. As an experiment, I created a new report with Fix Versions in the rows and created three measures:

CurrentHierarchyMember AllProperties = [Fix Version].CurrentHierarchyMember.AllProperties

Fix Version All Properties = [Fix Version].[Project Name].[Unreleased].[Version name].AllProperties

Fix Version.By name All Properties = [Fix Version.By name].[Version name].AllProperties

As you can see below, the first two measures contain the expected property data and the last one that uses the ‘Fix Version.By name’ dimension does not. Any ideas why that one is not working as expected?

image
image571×173 8.14 KB

I see Fix Version.By name appears to evaluate the KEY property differently and I don’t understand why that would be.