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:
Long time has gone by since I asked this question. To be honest, it slipped to the background.
Now I need it, but can’t figure it out.
My situation is that I’ve got in Assets an object type “Business Services” with in that object a list of inbound references of Technical Businesses (those are linked in the object type Technical Services throught Object and Dependency) .
I have no clue how I can create a report in EazyBI with a list of my attributes from the “Business Services” and a list of my inbound references (ie Technical Services).
The solution you gave above doesn’t work for me. Good chance ofcourse I’m doing something wrong.
I recommend placing the attribute dimension representing the “Business Services” object types in the “Technical Businesses” report rows. In the example below, the “Asset Category” type objects have inbound links. The “Asset Category” is referenced in “Model” type objects in the attribute “Asset Type”:
In the eazyBI import options, I imported the “Asset Type” attribute as a dimension. Placed in the report rows, I can combine it with the Object dimension to view the list. The report could look similar to the one below:
