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,

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. 

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,