Hello, I have a few questions about BIRT reports in Maximo. I need to do BIRT report for Asset hierarchy. Are there any examples out there which I could take for a template. Generally the idea is that hierarchy is procedually generated.




------------------------------
Blaz Rakar
------------------------------
#Maximo
#AssetandFacilitiesManagement

IBM includes a similar report for Locations out of the box (loc_hierarchy.rptdesign - Location Hierarchy by System) that would be a good starting point. I've seen some other more sophisticated ones that use DB-specific SQL designed for hierarchy data as well.

------------------------------
Tim Ferrill
Solutions Consultant
Intelligent Technology Solutions
tferrill@webuildits.com
www.webuildits.com
@tferrill/@webuildits
------------------------------

Hi thanks for help. I was almost successful. Here is my BIRT report file rptdesign in my dropbox link --> https://www.dropbox.com/s/pno15aybz9q1bri/asset_hierarchy.rptdesign?dl=0

My problem in my report is only that I get correct hierararchy like this below:



But problem is that If there is only one asset document is empty, this is because of this code here:


But if I change this to asset.assetnum there I get correct result in report for one item then, but if I have more items I get result like this just for one which is different like picture before.



Any help?


------------------------------
Blaz Rakar
------------------------------

Original Message:
Sent: Wed March 17, 2021 10:39 AM
From: Tim Ferrill
Subject: Asset Hierarchy in BIRT

IBM includes a similar report for Locations out of the box (loc_hierarchy.rptdesign - Location Hierarchy by System) that would be a good starting point. I've seen some other more sophisticated ones that use DB-specific SQL designed for hierarchy data as well.

------------------------------
Tim Ferrill
Solutions Consultant
Intelligent Technology Solutions
tferrill@webuildits.com
www.webuildits.com
@tferrill/@webuildits
------------------------------

On a side note:

This isn't what you asked for, but if you're looking for ideas for querying hierarchical data in Maximo, then these two posts might be of interest:
(they're about querying hierarchical WOs, not hierarchical assets, but the same principles might apply)
 - Select WOs' top ancestor (top work package)
 - WHERE clause WOs: Get children too

Cheers.

I uses sub queries in loop like that:

with assetstruct (a,b,c) as (
select ... from <STRUCTTABLE> where ...
union all 
select ... from <STRUCTTABLE> child, assetstruct
where child.xxx = assetstcruct.yyy)
select * from assetstruct where ...

------------------------------
Andrey Ilinskiy
------------------------------