Maximo Open Forum

 View Only

  • 1.  BIRT Training For Maximo

    Posted 09-21-2023 12:28

    Our company is relatively new to Maximo, and we are looking to start developing our own BIRT reports. I have been searching for any online courses that cover BIRT reporting for Maximo and was wondering if anyone had ever heard of or taken any. It you have, I would be most interested in finding out about them and what your experiences with them were.

    Thanks in advance for your help with this.

    Jim


    #Customizations
    #Reporting

    ------------------------------
    Jim Dutton
    Battle Lumber Company
    ------------------------------


  • 2.  RE: BIRT Training For Maximo

    Posted 09-22-2023 08:43

    I took BIRT report writing training from edi (edatai.com) but it was over 10 years ago.  They still offer some training.  The training was very helpful and I still use the IBM manuals I received for training.

    Regards,

    Jim



    ------------------------------
    James Robb
    NASA
    ------------------------------

    Original Message


  • 3.  RE: BIRT Training For Maximo

    Posted 09-22-2023 09:16

    Anne Antonelli with Technology Training & Consulting is another good one to reach out to. I've taken some great training with her in the past. 



    ------------------------------
    Kristina Strozzo
    Great Dane
    ------------------------------

    Original Message


  • 4.  RE: BIRT Training For Maximo

    Posted 09-22-2023 12:20
    Edited by Scott Guzman 09-22-2023 12:22

    Best way I can describe the initial writing process is to use QBR report on a base table at a very simple level. So, if its WORKORDER, build a query on the List page of whatever you might look for and then create a QBR report to just include the wonum, description, status, statusdate for instance. This will create a report with the imported search criteria and the base report. Save the report and go to Report Administration to find and export it. Save it to your BIRT report folders and refresh to see it and open it in BIRT. From there find the Data Set and look at the Open and Fetch scripts. In the Open you will see the SQL, and in Fetch you see the field definitions. Now that you can see the SQL you can build out whatever else you want to look at, including adding joins to other tables. Just remember whatever fields are in your select, needs to be defined in the fetch as well as on the Data Set > edit > output columns. After that, it's just an awkward GUI to figure out to drag the fields over to it and groupings. So doing it this way, if you want to be fancy with formulas and such, do it in SQL first. Just import it back in Report Admin and generate the request page.

    Good luck!



    ------------------------------
    Scott Guzman
    NASA JSC
    ------------------------------

    Original Message


  • 5.  RE: BIRT Training For Maximo

    Posted 09-22-2023 19:34

    Helpful hints when starting out with BIRT/Maximo report development:

    • Setup a development report environment first.  BIRT Designer is a stand-alone tool that does not need to be connected to Maximo.  A Database connection to a Maximo development database is all that is needed.
    • Download the Maximo Report Booklet which has all the Out-Of-Box BIRT report designs and a PDF sample of the reports. This listing of reports are in an Excel spreadsheet.  Here is the link:  https://www.ibm.com/support/pages/maximo-76-report-booklet
    • A good example to start with is woprint.rptdesign, Workorder Details report.  This report is full of examples of how Maximo and BIRT 'talk' to each other to pass information from Maximo database to BIRT to execute a report design. 
    • This report will provide examples :
      • "where" clause parameter used to pass Maximo data to BIRT for query building
      • multiple datasets 
      • how to use cascading parameters to build additional datasets
      • performing additional queries in the Fetch() to simplify main dataset query by avoiding JOIN clause. 
        • i.e. retrieving Asset long description
      • pagination used in report
      • displaying only tables with data and hiding those with no data.  Makes for a more compact report.
      • Most important with the Workorder Details report is an example for all the applications in Maximo. All the tabs in the Workorder Tracking application are represented in the Workorder Details report.  This is the same for all the detail reports for all applications.
    • For basics on report parameters any of the OOB reports in Inventory.
    • Using Ad Hoc or QBR to learn basic Maximo SQL is a start.



    ------------------------------
    NORMA RAMEY
    Maximo/BIRT Reporting Specialist

    ------------------------------

    Original Message


  • 6.  RE: BIRT Training For Maximo

    Posted 09-23-2023 20:47

    Hi Jim,

    I am one of the people who delivered the BIRT training when at MRO Software/IBM.  The course is usually 3-days and the content is:

    Day 1

    Day 2

    Day 3

    To assist or to get the most out of the course and BIRT, I would say there should be some familiarity (it does not teach the full skills of each) with:

    • HTML
    • JavaScript
    • Maximo
    • SQL

    You should also download and be familiar with the Maximo 7.6 BIRT design guide.  If nothing else, it does take you through the core that's also in the course, but as we know having someone teach you can be far quicker to learn than to do it yourself.

    The Maximo/BIRT set-up and interaction is not really compatible with a straight Actuate BIRT training and it's best to do any learning that is Maximo-centric in this case.  Some of this is because the linkage does not really take advantage of the advanced features that BIRT has and Maximo's version of BIRT that it uses also lags the real world.

    The only training I can see at the moment is from Innovent Solution, however, there seem to be no classes.

    Whilst there are some changes between Maximo 7.6.x and MAS, the fundamentals are still the same of BIRT and report writing.  So any investment is carried forward.

    ISW is able to run an online course if requested.



    ------------------------------
    Regards,
    Craig Kokay
    ISW
    Maximo Practice Manager
    eMail: ckokay@isw.net.au
    Phone: +61-411-682-040

    #IBMChampion2023
    ------------------------------

    Original Message


Related Content