From blogs to case studies to news, we love sharing our tips and tricks for asset management, cloud, IoT and smarter operations.

by | Nov 4, 2021

Maximo Relationships

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:

  1. Parent Object/Table
  2. Child Object/Table
  3. 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

  1. Use the List tab to select the table for which you want to create a relationship, and then click the Relationships tab.
  2. Click New Row.
  3. In the Relationship field, specify a name.
  4. Create a WHERE clause.
  5. Select a Child Object.
  6. Optional: Type comments in the Remarks field.
  7. Click Save Object.

What are the benefits of Maximo relationships?

  1. Ability to retrieve data from Maximo tables without recreating the table attributes in the table.
  2. Ability to restrict the data that can be visible to User(s) or User group.
  3. Multilevel relationships can be defined to retrieve data.
  4. You can display the related attribute value in the Maximo UI without writing complex code or customization.
  5. The relationship can be defined in the Maximo database configuration without stopping the Maximo services.
  6. You can display additional Information through a Relationship in Maximo.
  7. 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:

Left Image: Supervisor
Right Image: Primary email

Primary phone

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:

Saravanaperumal Sankaranarayanan

Saravanaperumal Sankaranarayanan

Saravanaperumal is a Principal Consultant at BPD Zenith. He has gained IT industry experience encompassing a wide range of skill set, roles and industry verticals. He was involved in business analysis, process designing, requirement gathering, data loading, data mapping, user training and user/system testing. His passion for MRO pushed him towards Maximo. He has implemented and enhanced Enterprise Asset Management systems (IBM Maximo) in Oil & Gas, Nuclear Energy, Transportation Industries clients in America, Europe and ANZ. Out of office, he enjoys spending time with family, long-distance drives, and of course, he follows Cricket and AFL. His favourite home teams are Perth Scorchers and West Coast Eagles.


Submit a Comment

Your email address will not be published.

Asset Management for Net-Zero Futures

Asset Management for Net-Zero Futures

Sustainability is not a new concept and BPD Zenith have always strived to be socially responsible, however, it is a critical imperative for today’s business operations – and for the planet... There has been a shift from using digital to improve the bottom line, to...

The Hidden Value of CMMS Master Data

The Hidden Value of CMMS Master Data

Having made a significant investment in your CMMS, advances in Data analytics are prompting rethinks about the Master Data that underpins your ability to launch programs such as Asset performance management, Monitor Asset health and enhance Predictive Maintenance. A...

BPD in Offshore: When the wind blows, our assets perform…

BPD in Offshore: When the wind blows, our assets perform…

London Array Limited (LAL) maintain a critical electricity production wind farm in the Outer Thames Estuary.   Lucy Horner (then Maintenance Strategy Engineer) joined the AiTalks podcast last year to discuss her world of offshore wind provision, the levels of...

Happy International Woman’s Day 2022 – Woman in Tech

Happy International Woman’s Day 2022 – Woman in Tech

International Woman’s day, which is celebrated globally on the 8th of March, commemorates the cultural, socioeconomic and political achievements of woman across the globe with a strong focus on gender equality, and on preventing violence and abuse against woman. The...

Sign up to our free newsletter to explore emerging technologies, industry events and Maximo best practice.

Come with BPD Zenith to the future of Asset Management

Partner Ecosystem

BPD Zenith partners with a diverse array of the world’s top Technology, Business and Solution Integration leaders.