Get atribute value from a reference object

Questions & Answers
2

Hi @Cr0w,

Cost is not related to the Computer directly but thorough Contract. In this case, you might want to define the calculated measure (in Measures) to follow a path of relation and retrieve the Cost value.

First, chose to represent Computers on rows (dimension Objet on rows and dimension Object Type on pages with selected value Computer).
For the calculated measure to retrieve Contract of Computer and then Cost of Contract, you might want to use functions GetMemberByKey(), GetLinkedMember() and get().

--look for the contract of the Computer in Object dimension based on contract key value
[Object].[Object].GetMemberByKey(
  --get the key of Contract for the selected Computer
  [Object].CurrentMember.GetLinkedMember("Computers Contract").Key
--get Cost of the Contract
).get("Contracts Cost")

Please validate and update the property names in the formula to match your Insight object and attribute names in eazyBI.

More details on used functions are in the documentation:

You might also check out this community post on how to retrieve attribute values for Insight data:

Best,
Zane / support@eazyBI.com

1 Like