Get atribute value from a reference object

[Cr0w]

Hi,

We have in our CMDB scheme an object Computer with a referenced atribute object called Contract, this Contract has a numeric atribute Cost

We need to make a table showing all Active (Status) Computers with their respective contract and cost, but we cannot seem to get the cost through the Computer, we only get the Contract, but the Cost property appears empty.

[zane.baranovska]

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:

• GetMemberByKey
• GetLinkedMember
• get

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

Getting Count of Inbound/Outbound References in Insight

eazyBI supports outbound reference import in Insight data cube. This will support grouping any objects by outbound reference objects. In your case, you would like to import outbound reference Location for Laptop as dimension (an property). eazyBI should create a dimension Laptop Location (the dimension name could be different for inherited attributes). You can use this dimension on Rows to Count Laptop objects by each Location. eazyBI does not have a default access to object properties for dim…

Best,
Zane / support@eazyBI.com

[Robert]

@zane.baranovska

k 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

Hello @zane.baranovska ,

that’s great explanation, I was able to solve a tricky customer request with it. But they tried me with another interesting one

Is it possible to extract attribute data from multiple object connection?

Continuing with the example above, we have the computer object and the referenced attribute object called Contract. But the Contract object also has a referenced attribute object called Supplier, which has the numeric attribute Phone number.

What do you think is creating a table with the following values?

Thanks a lot,
Robert

[zane.baranovska]

Hi @Robert,

Yes, you can get attribute values from several linked objects. In that case, you might want to use function GetLinkedMembers() to retrieve a set of several linked objects and function Generate() to concatenate a list of individual object attributes (MDX function reference).

Check out this community post on a similar use case:

Get attribute value from Object type attribute with multiple values

The function GetLinkedMember works well when you need to switch to another object. But it can’t switch to several other objects. You would like to use the function GetLinkedMembers instead. The function getLinkedMembers will access a set of linked objects. Then you would like to apply some additional configurations to them: Show details per each object as a string: NonEmptyString(Generate( [Object].GetLinkedMembers('Desktop Displays'), [Object].CurrentMember.Name || " - " || [Object].Curren…

Best,
Zane / support@eazyBI.com

[Robert]

Hi @zane.baranovska ,

Happy New Year!

Thanks for your answer, but after several attempt I was not able to solve the problem. Could you please give me a hint how to define the attribute of the third object in the “object chain”?

Computer - Contract - Supplier - > Phone number of the supplier

NonEmptyString(Generate(
[Object].GetLinkedMembers(‘Computer Contract’),
[Object].GetLinkedMembers(‘Contract Supplier’),
[Object].CurrentMember.GetString(‘Supplier Phone number’)
))

Thank you!
Robert