Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Alternatives to BIRT?

    Posted Tue November 24, 2020 08:50 PM
    Edited by System Admin Wed March 22, 2023 11:53 AM

    For those of us who aren't totally satisfied with BIRT (performance, functionality, aesthetics, ease of development, error handling), what are our options for alternative reporting platforms?

    A. Cognos
    B. Ontrack's SQL SSRS Plugin / SRSS
    C. MS Access/Excel via ODBC (a surprisingly appealing option)
    D. ArcGIS Online dashboards, etc. (not just for maps)
    E. Other?

    It would be great to have a reporting platform that matches the strength of core Maximo (and sufficiently shows off our multi-million dollar investment).

    Thanks


    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Alternatives to BIRT?

    Posted Wed November 25, 2020 01:32 AM
    Hi,

    We used MS Power BI and Qlik very successfully. It is vey easy to install and use.

    ------------------------------
    Arnoldas Zukauskas
    TPAIM
    ------------------------------



  • 3.  RE: Alternatives to BIRT?

    Posted Wed November 25, 2020 08:18 AM
    Hi. Cognos Analytics entitlement is included with Maximo.  Depending on your specific version of Maximo, Cognos Analytics 11.0.11 or 11.0.13 licensing is available free of charge starting with the Maximo 7.6.1.0 releases.   (Earlier versions of Maximo entitled earlier versions of Cognos)

    More details can be found in this guide
    https://www.ibm.com/support/pages/node/741619

    and the Maximo Cognos install guide for 11.0.11 is here
    https://www.ibm.com/support/pages/node/719711

    Cognos Analytics is super powerful, and you can also register for a free, 30 day trial to give it a try before installing/committing
    https://www.ibm.com/products/cognos-analytics

    Thanks!

    ------------------------------
    Pam Denny
    ------------------------------



  • 4.  RE: Alternatives to BIRT?

    Posted Wed November 25, 2020 09:11 AM

    Seconding Arnoldas that Power BI tends to be a popular option, especially for organizations that already use Office 365. It's extremely cheap (if not free based on the plans you're using) and you can make some pretty interesting dashboards in it. We also see quite a few still use the ODBC approach with Excel as well. 

    Power BI/Cognos (and probably ArcGIS Online dashboards based on the name) serve a different purpose than BIRT reporting in my opinion. Power BI/Cognos are all about analytics of your data (time to completion, number of records without proper failure codes recorded, etc.), whereas BIRT is geared more towards transactional reports (what was done on WO 1234). None of those other reporting frameworks can do transactional reporting well based on our experience.

    I'll agree the aesthetics aren't the greatest, but BIRT in some ways is very similar to Maximo. The power and flexibility of what IBM has done with BIRT is impressive. For example, if you need to support multi-language there is a comprehensive process for doing that in BIRT where you can configure labels with a properties file so they're automatically translated into the user's language. You can choose to hide/display columns based on a variety of conditions, including the type of file being exported to. For example, in Excel the width isn't really an issue but in a PDF document that is going to be printed you're typically more constrained. Direct print is extremely powerful, from handling concepts such as duplex printing (including ensuring each record is on its own paper) to including specific attachments that are relevant for performing the work. And there is functionality to restrict reports to certain time windows, record limits, etc.

    The learning curve is tough and it's not going to replace a dashboard like tool. But I wouldn't try to avoid BIRT. Use it for the transactional style reports (especially where out of the box examples exist that you can modify) and find an alternate for more analytical reporting. 



    ------------------------------
    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH
    ------------------------------



  • 5.  RE: Alternatives to BIRT?

    Posted Thu November 26, 2020 05:39 PM
    Hi User1971

    As you are an Esri user, you should also consider reviewing ArcGIS Insights Location Analytics Software | ArcGIS Insights.

    Esri also provides plugins for MS Power BI which may be of interest - ArcGIS Maps for Power BI https://www.esri.com/en-us/arcgis/products/arcgis-maps-for-power-bi/overview.

    Cheers
    David

    ------------------------------
    David Lestani
    Professional Services
    Clarita Solutions
    ------------------------------



  • 6.  RE: Alternatives to BIRT?

    Posted Wed November 25, 2020 11:41 AM
    We've seen success with using MS PowerBI utilizing direct query option to SQL and establishing the PowerBI gateway to publish reports and dashboards.

    ------------------------------
    Clyde Waters
    ------------------------------



  • 7.  RE: Alternatives to BIRT?

    Posted Mon November 30, 2020 09:48 AM
    We are using Tableau, the users that have been exporting to excel from BIRT now have a similar environment to excel, but lots of bells and whistles. It is supported by a number of divisions here, so I just have to develop the dashboards etc.

    #AssetandFacilitiesManagement
    #Maximo