Maximo User Group - UK & Ireland

Maximo-ICON.png

Maximo

Learn how to increase the operational efficiency of the assets you manage, and improve overall equipment effectiveness by using IoT data and AI.

Maximo-ICON.png

TRIRIGA

Reduce the operational costs of the facilities you manage, and create more engaging occupant experiences through the application of IoT data and AI.

Maximo-ICON.png

Engineering

Learn how IoT data and AI are being applied to transform the end-to-end engineering lifecycle.

Expand all | Collapse all

New to Maximo - Question regarding Enterprise wide multi instance reporting on Maximo (SQL Server)

  • 1.  New to Maximo - Question regarding Enterprise wide multi instance reporting on Maximo (SQL Server)

    Posted Fri May 03, 2019 10:48 AM
    Hi there community,
    I am new to Maximo as a product, and sit in architecture space. My org has several instances of Maximo on differing versions with differing backend SQL Server databases. What is the best architectural way (that people have done) for consolidated operational reporting for some fairly hefty size databases?
    My first thought would be a SSAS (Analysis Services DB) with some form of cube - what has anyone else done that has worked well/badly?
    Is there a recommended IBM best practice architecture for this scenario?
    Excuse the novice questions. I come from an Enterprise DW background but we dont have one of those and this org....
    Many thanks & regards
    Tom Gregory

    ------------------------------
    Thomas Gregory
    ------------------------------


  • 2.  RE: New to Maximo - Question regarding Enterprise wide multi instance reporting on Maximo (SQL Server)

    Posted Thu May 23, 2019 04:07 AM
    Hi Tom,

    Welcome to the group. Hopefully one of our fellow users, partners or IBM members can shed some light on your request.

    Come on community let's help Tom out.

    Cheers
    Rich

    ------------------------------
    Richard Barber
    Maintenance Systems Lead Engineer
    Drax Power Limited
    Selby
    01757 612187
    ------------------------------



  • 3.  RE: New to Maximo - Question regarding Enterprise wide multi instance reporting on Maximo (SQL Server)

    Posted Thu May 23, 2019 09:59 AM
    Tom - 

    Hi!  Welcome to Maximo!

    On your question - you noted that you had multiple instances of Maximo.   Few thoughts on this -

    1.  Are each of these instances on different versions of Maximo?   Or are they a variety of development, test and production instances?

    2.  Have you evaluated the Cognos Analytics option that is available with Maximo 7.6.1.x?   With this option - you can combine multiple Maximo instances into a single data set for analytics.

    More information on Maximo and Cognos Analytics can be found with this video series
    Maximo 761 Cognos11 Video 1: Overview
    YouTube remove preview
    Maximo 761 Cognos11 Video 1: Overview
    Don't miss out on the stellar new features of Maximo 761 with Cognos Analytics! This is the first in a series of 13 videos - ranging from 5 to 10 minutes - providing an overview of the tremendous features available with Maximo 7.6.1 and Cognos Analytics!
    View this on YouTube >



    ------------------------------
    Pam Denny
    Sr Analytics Architect
    IBM
    Littleton MA
    978-899-2533
    ------------------------------



  • 4.  RE: New to Maximo - Question regarding Enterprise wide multi instance reporting on Maximo (SQL Server)

    Posted Tue September 24, 2019 05:36 AM
    Hi All,
    Thanks for the replies.
    We have looked at the Cognos capabilities and I think its worth investigating further. What I am confused on is whether we are allowed to have a separate consolidated Cognos instance fed by the source Maximos (1), and does that separate consolidation instance require licensing (2)?  Whilst I have viewed the licensing material its still seems particularly vague and open to misinterpretation - ie on a concurrent user license does a Cognos user count as a concurrent maximo user? Is that usage case allowed?

    Essentially the choice seems to be down to feeding a central SQL Server and hooking in Power BI or a the option above which is only a goer if the licensing allows and I dont have to go and purchase a plethora of Cognos licenses for users and/or servers - what has anyone else done or heard of other customers/partners doing?

    Can someone put me in touch with the UK or EMEA product lead for maximo so I can explore further?
    Thanks & Regards
    Tom

    ------------------------------
    Thomas Gregory
    ------------------------------



  • 5.  RE: New to Maximo - Question regarding Enterprise wide multi instance reporting on Maximo (SQL Server)

    Posted Mon July 22, 2019 08:50 AM

    Hi Tom,

    Not sure if you got an answer to this question but one idea that I have seen working is a separate SQL data warehouse which sucks in the data from all the Maximo databases using SSIS.

    Using SSIS you can the transform the data so that all the different data structures from each database can all fit into the same data warehouse database. Then using SSRS to create all the reports you need from that.

    If you want to take if further, you could then add products such as Power BI to allow the users to create their own reports/cubes that don't have any detrimental effect to Maximo or Data Warehouse performance.

    Then create a custom app in the Maximo systems that directly links to each SSRS report if needed. That way the users don't have to leave Maximo to run the SSRS reports.

    Thanks,
    Matt



    ------------------------------
    Matthew Atkinson
    Maximo Consultant
    ------------------------------