IBM Sustainability Software - Ideas Portal


This portal is to open public enhancement requests against the products and services belonging to IBM Sustainability Software. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas

  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Add a new idea Subscribe
Status Future consideration
Workspace IBM MAS - Manage (Base)
Categories System Admin Config/Security
Created by Guest
Created on Oct 29, 2021

RELATED IDEAS

Replace the MAXDEMO database

It would be helpful if IBM could invest in a new MAXDEMO database where the data has actually passed through the MBO business logic and dates are not 30 years old.

The existing MAXDEMO data isn't very useful because the data is messy. The demo data often causes confusion when trying to demo Maximo to prospective users/clients. The system doesn't behave as expected and this makes Maximo look bad.

It would really help if we had a well populated and accurate MAXDEMO database.

Related post: Errors in labor actuals data

For example, this query reveals a lot of erroneous data in the MAXDEMO database:

--WO actual labor hours vs. LABTRANS regular hours
select
    wo.wonum,
    wo.istask,
    round(wo.actlabhrs,1)   as wo_actlabhrs,
    round(lab.regpremhrs,1) as lab_regpremhrs,
    round(wo.actlabhrs - nvl(lab.regpremhrs,0),3) as hrs_difference
from
    maximo.workorder wo
left join
    (
    select
        refwo,
        sum(regularhrs + nvl(premiumpayhours,0)) as regpremhrs
    from
        maximo.labtrans
    where
        genapprservreceipt = 1 --aka "Approved"
    group by
        refwo
    ) lab
    on wo.wonum = lab.refwo
where
    abs(wo.actlabhrs - nvl(lab.regpremhrs,0)) >= 0.1
Idea priority Medium
  • Post comment
  • Guest
    Reply
    |     Feb 21, 2023

    Adding requirements to an update of the demo data I would in addition to the already provided comments (mainly Nov 5) add:

    • Clean up the amount of user that accumulated over the years to less than 15 and give the users indicative names on what purpose in the demo data they are assigned to e.g. "Sara Scheduler" or "Peter Purchase"

    • Add additional demo data with industry modules - bringing in vehicles with Transport, Planes with Aviation, Grids with E&U etc. and provision new users that are dedicated to the industry module e.g. "Cynthia Civil" has access to the CI industry solution

    • Consider that the demo data within the Manage continues to other modules and in case they're installed that the pump 11430 provides also an corresponding Monitor demo (simulator) that delivers meter readings, and an according Health&Predict model and a visual inspection.

    • Reduce the amount of assets that come with H&P into manage and fill up the database, reduce the amount and modernize the IT assets to current technology

    • Improve the data quality on the assets that are provided. Each should have an asset history, WO history, service address, purchase and vendor information, image and base data filled, so the views are populated especially when used with Mobile

    • Introduce few highly complex assets e.g. wind turbines with a assembly structure that allows to demonstrate advanced use cases and e.g. integration with an engineering solution

  • Guest
    Reply
    |     Dec 8, 2021

    It would also be great if the demo database contains a greater # of records in it in all useable tables to provide a more realistic feel. When testing is done you would will find out that performance is an issue as time goes on due to the way queries are use the select * against tables, missing index's etc. It would also be good when vendors/IBM run demo's for mobile\industry solutions\addons etc. It would also be good to verify "What is the expected use case/functionality type questions that arise) .


    An option may be a flag to setup an 'Expanded' demo database at the time of install.

  • Guest
    Reply
    |     Nov 21, 2021

    Regarding "Needs more information":

    Please refer to the comment from Andrew(Guest) at 5 Nov 09:24am.

  • Guest
    Reply
    |     Nov 7, 2021

    Adding a comment to also support the points raised in relation to this by guest on 05 Nov 09:24

  • Guest
    Reply
    |     Nov 5, 2021

    I do not think that the content itself needs to be changed, as people are used to the assets and locations, etc. The content needs to be brought up to date to show examples of functionality and for it to be able to be used as demo data or used in training courses.

    The three main reasons for reworking the MAXDEMO Database are:

    • Dates are embarassing. If we reveal dates like PO's with a required date in 1997 it will make prospects wonder what sort of product they are buying.

    • There are several areas where you couldn't demo without having to do something first. Calendars finishing before today, for example.

    • Some data could not be loaded through the current MBOs. For example Labor with multiple default crafts. Even yesterday I raised an IBM Support Case for SLA 1021, you would not be able to create the four commitments for applies to object ASSET (Case TS007429177).

    The MAXDEMO database could be a much more useful resource. It should include data for Industry Solutions and add-ons, even if as a consequence there is a much larger database.

    • It should be used as the basis for product demonstration. Perhaps it still is to some extent, but many including myself would create their data from scratch.

    • It is essential for training materials, so that others can use the same data if they ran through the same examples.

    • It should be a useful resource for IBM Support. Some of the Industry Solutions do not have data, consequently you have to enter data in many places before being able to run the test you need to do.

    • It should be a useful self learning tool. It used to be that to understand how a function worked in Maximo you would query for the record in the MAXDEMO database. For example Lease/Rental Contracts - Contract 1002 (expired nearly 15 years ago), often that would give you a clue to how a feature might be working.

    The MAXDEMO data should be regularly (every couple of years) loaded through the MBOs as this is likely to reveal either an incorrect fix, or something where core functionality has been tweaked and the data is now incorrect.

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.