I’m making a report in EazyBI on our business services and their customers (Organisations) (relation 1-n) from Insight database.
Every Business Service is an object in Insight. They all have reference objects from the object “Organisations”. I now want to see all the Business Services with their organisations attributes (ie. name and code)
I tried next syntax as a calculated measure but have no data, so clearly I’m doing it wrong:
[Object].CurrentHierarchyMember.GetLinkedMemberName(‘Organisaties Naam’)
and
[Object].CurrentHierarchyMember.GetLinkedMember(‘Organisaties OVO nr’)
To retrieve the referenced Category object type attribute “Type”, first ensure the respective attributes are selected for import for each Object type in the Insight import options. See an example below:
Finally, to retrieve a specific Category type object attributes, define a new calculated measure with a formula similar to the below:
[Object].[Object].GetMemberByKey(
[Business Services Service Category].CurrentMember.Key
).Get('Category Type')
In the formula, replace the Business Services Service Category dimension with the Business Services Organisation dimension. The report could look similar to the one below: