ScriptRunner Issue Picker

Hi EazyBI Community,

We have a custom field which is a Issue Picker from ScriptRunner.
Is there a way to pull in the linked issues in this field via a Heirachy?

Example:
(Issues in the picker)
Objective 1
Objective 2
Objective 3
Objective 4
Objective 5

Initiative 1 - Issue Picker: Objective 1 Objective 2
Initiative 2 - Issue Picker: Objective 3
Initiative 3 - Issue Picker: Objective 5
Initiative 4 - Issue Picker: Objective 3 Objective 5

Would like to report on:

Objective1:
        Initiative 1
Objective2:
        Initiative 1
Objective3:
        Initiative 2
        Initiative 4
Objective4:

Objective5:
        Initiative 4

Hi,

It is possible to create the hierarchy from the issue picker fields in eazyBI with specific advanced settings. The limitation is that eazyBI cannot build a hierarchy if the child can have several parents. In other words, the issue picker field must be of single-issue picker type at the child issue, which seems not to be your case.

The approach with the multiple user picker field is to create a multiple value dimension from this field with advanced settings like this:

[jira.customfield_NNNNN]
data_type="string"
dimension=true
multiple_values= true
separate_table=true

NNNNN is the ID of the issue picker field. Once you import this field as a dimension, you can combine the new dimension with Issues and see the report like this:

Kindly,
Janis, eazyBI support