Assets: How to Import "Inbound References" in eazyBI

[gerda.grantina]

In Assets, you can define inbound references for the objects that point from another object towards the current object.

By default, eazyBI can import outbound references (the opposite direction) but does not import inbound references. This means that in eazyBI, you can select the “Owner” attribute for “Asset” and import the dimension “Asset Owner,” by which you can split your objects (“Object” dimension) and see which assets are per each owner:

The limitation is that you cannot get the full inbound reference list with this solution. However, a workaround exists to get all “Inbound references” in eazyBI out of Assets.

1. In my example, I have an object schema where the object “Person” has two inbound references from “Asset” and “Role”:
   

   

2. I go to eazyBI data import options for Asset Cube and select to import attributes “Owner” (Person) for the object "Asset” and “Responsible” (Person) for “Role.”
   

   

3. With eazyBI version 6.2 or newer, it is possible to create an additional object hierarchy from the imported properties. I created new “Object” hierarchies from those newly imported references “Asset Owner“ and “Role Responsible.”
   

   

4. Now, I can display all the inbound references for the object “Person” with the following formula that references the hierarchies created above:

"**Assets**:"||
CHR(10)||
CoalesceEmpty(
  NonEmptyString(
    Generate(
      [Object.Asset Owner].[Owner].GetMemberByKey(
        [Object].CurrentHierarchyMember.KEY
      ).Children,
      [Object.Asset Owner].CurrentHierarchyMember.Name,
      ", "
    )
  ),
  "N/A"
)

||
CHR(10)
|| "**Roles**: "|| 
CoalesceEmpty(
  NonEmptyString(
    Generate(
      [Object.Role Responsible].[Responsible].GetMemberByKey(
        [Object].CurrentHierarchyMember.KEY
      ).Children,
      [Object.Role Responsible].CurrentHierarchyMember.Name,
      ", "
    )
  ),
  "N/A"
)

5. In the report, I can filter by “Person” and see referenced assets and roles:
   
   

best,
Gerda & Jānis // support@eazybi.com

[kayhantaskiran]

Hi Gerda Grantina,

First of all, thank you so much for sharing your method. I have an additional question here. While you are using the “person” object type, you can retrieve the values of the associated objects as inbound references.

My question and issue are as follows: If I explain it through your assets, I want to fetch the details like “model,” “country,” and “licenses” from the attributes of the objects in the “Asset” object type that are linked as inbound references to the “person” object type (e.g., where they are listed as the owner).

In other words, I want to see the data in other attributes of the objects linked via inbound references.

I would greatly appreciate your assistance on this matter.

Best regards,
Kayhan