In this blog I will be explaining what a Maximo Relationship is, how to create one, and, the benefits of having Maximo Relationships.
What is a relationship?
The way in which two or more things are connected, or the state of being connected.Why do we need Maximo relationships?
To retrieve data on objects, you must define the relationships between objects. The Maximo Entity Relationship Document (ERD) describes the Maximo business objects and the logical relationships between them.
In Maximo you can display information virtually through a relationship. Sometimes there are situations in which you may want to display a value from a child table, for the user to see during the session when they are viewing the record. But, the user doesn’t need it to be saved to the parent table.
However, in an Mbo object you can retrieve the related records using Maximo object relationships as defined in the Database Configuration application.
Maximo relationship elements
In Maximo, relationships have the following elements:
- Parent Object/Table
- Child Object/Table
- Where a Clause is simply a snippet of an SQL statement, it joins the Parent and Child MBOs/ Table.
How to create a relationship in Maximo
- Use the List tab to select the table for which you want to create a relationship, and then click the Relationships tab.
- Click New Row.
- In the Relationship field, specify a name.
- Create a WHERE clause.
- Select a Child Object.
- Optional: Type comments in the Remarks field.
- Click Save Object.
What are the benefits of Maximo relationships?
- Ability to retrieve data from Maximo tables without recreating the table attributes in the table.
- Ability to restrict the data that can be visible to User(s) or User group.
- Multilevel relationships can be defined to retrieve data.
- You can display the related attribute value in the Maximo UI without writing complex code or customization.
- The relationship can be defined in the Maximo database configuration without stopping the Maximo services.
- You can display additional Information through a Relationship in Maximo.
- Mbos obtained via relationship are included in the same transaction as the parent MBO.
Finally, things to consider
Before you create a relationship, review the relationships defined in the database to determine if you can reuse an existing relationship. However, if the definition of a relationship does not match your needs, do not modify the relationship. Instead, create an additional relationship.
Displaying the Users Supervisors Email and Phone Number
For example, use this scenario:
Firstly, display the Person’s Supervisor primary email and phone number next to supervisor name in the Maximo Person application.
Secondly, you can meet the requirement by using the following relationships:
Thirdly, add Phone and Email attributes in People Application:
In conclusion, I hope you learnt some practical applications through this example. If you would like to learn more about Maximo or what BPD Zenith has to offer, contact us at: https://www.bpdzenith.com/contact