Maximo Open Forum

Hello all I received this error when trying to add the Last Reading from Asset Meter to a PM report.

I had to add it as a grandchild of PM because no relationship existed between Asset Meter and PM directly.  

Is it possible to see this information on this report?

Here is my report REP_PM structure:

Thank you,

#Administration
#Assets
#EndUser
#EverythingMaximo
#Reporting

------------------------------
Danny Richardson
Maximo Administrator Manager
Technimark LLC
------------------------------

In this scenario, I would typically create a new relationship from PM to ASSETMETER in the Database Configuration object to bypass the asset object. Your where clause can be simply:

assetnum=:assetnum and siteid=:siteid

This would enable you to query the assetmeter since it would be a one to many from the parent object (PM).

It's worth mentioning that these types of changes will prevent modifications of existing QBR reports. I don't create a lot of QBRs but if there are other reports referencing the object structure, I'll typically create a new object structure for this type of change rather than modifying the existing object structure. 

------------------------------
Steven Shull
Naviam
------------------------------

Thank you @Steven Shull.  This is very helpful information.

------------------------------
Danny Richardson
Maximo Administrator Manager
Technimark LLC
------------------------------

Original Message:
Sent: 09-11-2025 10:48
From: Steven Shull
Subject: Asset Meter on Preventive Maintenance Report issue

In this scenario, I would typically create a new relationship from PM to ASSETMETER in the Database Configuration object to bypass the asset object. Your where clause can be simply:

assetnum=:assetnum and siteid=:siteid

This would enable you to query the assetmeter since it would be a one to many from the parent object (PM).

It's worth mentioning that these types of changes will prevent modifications of existing QBR reports. I don't create a lot of QBRs but if there are other reports referencing the object structure, I'll typically create a new object structure for this type of change rather than modifying the existing object structure. 

------------------------------
Steven Shull
Naviam
------------------------------