Report with FixVersion Release Date and Next FixVersion Release Date

Questions & Answers
, ,
2

Hi,

Lead’s construction looks for the next version using the dimension members’ default order, and it cannot see that your report refers to a specific calculated member.

The following approach can fix that:

ChildrenSet([Fix Version].[Last 7 releases]).Item(
   Rank(
      [Fix Version].CurrentMember,
      ChildrenSet([Fix Version].[Last 7 releases])  
    )  
).get('Release date')

The formula’s idea is to use the Rank function to find the order number of the release in the Last seven releases member and then take the item with the same Rank. This approach works because Rank is calculated starting from 1, but the Item function starts the indexing from 0.

Kindly,
Janis, eazyBI support