Jira Cloud Insight - Multiple GetLinkedMembers

Questions & Answers
1

Hello all,

we are useing eazy BI since a some weeks and start to get more challening requirments.

My actual problem ist the linking of Insight objects over 3 referenced steps.

  1. Benutzerlizenzen - Attribute Module - Module is linked to Lizenzpositionen
  2. Lizenzpositionen - Attribute Verrechnungszyklus - Verrechnungszyklus is linked to Verrechnungszyklus
  3. Verrechnungszyklus - Attribute Zahlenwert

I want to Show the “Zahlenwert”.

I tried it with the following Formula.

NonEmptyString(Generate(
[Object].GetLinkedMember('Benutzerlizenzen Module'),
[Object].CurrentMember.GetLinkedMember('Lizenzpositionen Verrechnungszyklus'),
[Object].CurrentMember.GetNumber('Verrechnungszyklus Zahlenwert')
))

I get this working for 2 layers but didn’t understand what i’m doing wrong with layer 3.

I hope someone can help me out.

Best Regards

2

Hi @lmersich

Welcome to the Community! :slight_smile:

You are on the right track!

The Generate() function has two possible expressions, and for this case, I would suggest the String expression syntax with the following formula:

Generate(
  [Object].CurrentHierarchyMember.GetLinkedMembers('Benutzerlizenzen Module'),
  [Object].CurrentHierarchyMember.GetLinkedMember('Lizenzpositionen Verrechnungszyklus').GetString('Verrechnungszyklus Zahlenwert'),
  ','
)

If you have several “Benutzerlizenzen Module” linked to one Object, this will return all of the different “Verrechnungszyklus Zahlenwert” for these modules in one line separated by a comma “,”.

If all of the “Benutzerlizenzen Modules” in a single object have the same “Verrechnungszyklus Zahlenwert” and you would like to return only one value for the Object, you can use a simpler formula that will return the Zahlenwert of the first linked member:

[Object].CurrentHierarchyMember.GetLinkedMembers('Benutzerlizenzen Module').Item(0).GetLinkedMember('Lizenzpositionen Verrechnungszyklus').Get('Verrechnungszyklus Zahlenwert')

If each Object has only one “Benutzerlizenzen Module”, you can use an even simpler formula:

[Object].CurrentHierarchyMember.GetLinkedMember('Benutzerlizenzen Module').GetLinkedMember('Lizenzpositionen Verrechnungszyklus').Get('Verrechnungszyklus Zahlenwert')

Let me know if this fits your use case!
Best regards,
Nauris / eazyBI support

3

Hello Nauris,

thank you for the solution, it works as i planned it.

Best Regards and Thank you.