Maximo

Expand all | Collapse all

Asset Hierarchy in BIRT

  • 1.  Asset Hierarchy in BIRT

    Posted Wed March 17, 2021 08:02 AM
    Edited by Blaz Rakar Wed March 17, 2021 08:02 AM
    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
    ------------------------------


  • 2.  RE: Asset Hierarchy in BIRT

    Posted Wed March 17, 2021 10:39 AM
    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
    ------------------------------



  • 3.  RE: Asset Hierarchy in BIRT

    Posted 10 days ago
    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
    ------------------------------



  • 4.  RE: Asset Hierarchy in BIRT

    Posted Thu March 18, 2021 10:05 AM

    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.




  • 5.  RE: Asset Hierarchy in BIRT

    Posted Thu March 18, 2021 05:05 PM
    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
    ------------------------------