Split comma separated members into columns on the same row

[must1]

Hello EazyBI Community,

In my table you see above, I want to divide the defect keys members into different columns in the same row. I don’t want the members to be separated by commas, but to be separated by columns on the same row.

*As an alternative solution, we can list the comma-separated members for defect keys in the same row and column as follows.

Defect Key 1: ADC-9632
Defect Key 2: ADC-8745
Defect Key 3: ADC-4821

How can I fix this problem?

[janis.plume]

Hi,

Splitting the comma lists from a table cell to separate columns is impossible.

The workaround for your use case is to implement a custom measure, assuming you have imported the defects as an issue links with the dimension option.

Please find here an example based on the Bugs dimension, which is the link from the issue to the bug:

Generate(
  [Bugs].[Bugs].GetMembersByKeys(
    [Issue].CurrentHierarchyMember.get('Bugs')
  ),
  "Defect KEY "||CAST(Rank(
    [Bugs].CurrentHierarchyMember,
    [Bugs].[Bugs].GetMembersByKeys(
      [Issue].CurrentHierarchyMember.get('Bugs')
    )
    ) as String 
  )  
  ||": "||[Bugs].CurrentHierarchyMember.KEY,
  CHR(10)
)

My report looked the following:

Kinldy,
Janis, eazyBI support