Category: Training

Automation Scripting Tutorial

Got a request from someone overseas to teach him on configuring automation script in Maximo. All of my previous tutorials posted have been in Vietnamese.

I have always wanted to do this but haven’t found the time. So here it is, the first one in English.

Useful small features in Maximo

As Technical Consultants or Maximo Administrators, we often
have high level of proficiency in using the software. Because of that, we often
overlook the many basic or simple features that can be extremely useful to the end-users.
In many cases, when I mentioned one those features to the end-users, whether they are beginners
or long time Maximo users, it is often received with much
excitement. So I think it may be a good idea to collect a list of those small features like that and share them here in this post:
Default Table Data:
in several standard applications such as Purchase Requisitions
or Purchase Orders, in the PR/PO Lines tab, at the bottom of the tab, below the Detail
section, there is a section called “Default Table Data”. This section allows a
user to enter default data values that will be automatically filled every time when he or she adds a
new line.
For example, when creating a new PR, the requester may create requests for a list of many different items, all of them will be received into the same storeroom,
charged against one same GL Account, and requested by the same person. By entering
these default values, every time the user hit “New Row”, these values are
populated automatically, and the user only has to enter the item number and the
requested quantity. For a large PR with a few dozen or hundreds of lines (it is not
unusual for PR/POs acquiring parts for large turn-around project to have few
thousand lines), this feature can be a huge time saver. For implementers and Maxadmins, the Receiving or Work Order’s Planned Material tab can be great
candidates to add this feature. The users will fall in
love with you after you added this “Default Table” feature to the apps. Sit down and ask them
what are the fields that they have to enter the same data again and again.
Spend 10 minutes to implement the feature and you will be the real hero.
 

Default Data section in Purchase Requisition app


Search record by
Itemnum (Advanced Search)
: here is one typical scenario: a user raised a PR
to purchase several items. These items later get copied to a PO and the PR
is closed. A few weeks later, the person wants to know the status of the items
he requested but unfortunately he forgot the number of the PR he raised, he
doesn’t know what is the PO number which the item got copied to. In this case,
the quickest way to find out is to open the Advanced Search, and search for the PR or PO records which contains the item he wants to find. This is the quickest way to find a main entity record which contains an Item Number. These records can be Work Order,
Inventory Usage, Contract, RFQ, PR, PO or Invoice. Obviously, as a Consultant
or Admin, you can add this feature to any application that contains a child
table to allow the end-users to search for the main record based on an
item/object contained in the Lines tab.
Find all PRs which contain a specific Item

Customized Advanced
Search
: given this scenario: due to regulation requirements, many of my
clients use a custom “Issue Date” field for Work Order. For reporting, this
field is used to determine the reporting period for different reports such as
“Completed work” or “Over-due work”. The “List” screen on every Maximo application
is very effective for filtering/finding record with a specific criteria such as
looking up for all Work Orders on an Asset with Work Type = CM for example. However, this screen does not allow the user
to search for all Work Order created within a period (i.e. Issue Date between
1/Dec and 31/Dec). Users who are more familiar with Maximo know that they can
use the standard Advanced Search feature to search for Work Orders which has Report
Date or Scheduled Start Date between a From Date and a To Date values. However,
customized fields, like the “Issue Date” in this case, are often neglected by
the implementers and thus are not added to the Advanced Search pop-up screen. In
many cases, when I conducted refresh training class, the users often greatly
appreciate after I point this out to them and add the missing fields to the
Advanced Search screen (which only takes me less than 5 minutes). A one- or
two-minute change to the software like this sometimes is a big time saver and makes life a lot simpler for the end-users. Ability to add small stuff like this and seeing these changes make a positive impact to the end-user’s workflow is also a great emotional reward to the consultant too.
Use Advanced Search’s Dates section to find all Work Orders in a period.

View Item Availability pop-up menu
View Item
Availability
: In any Maximo application which displays material-related
information, you can click on the “Detail Menu > View Item Availability”
menu to see all important information related to the item including the current
inventory balances, quantity reserved, and other detailed information such as
which are the alternate items, whether the item has been requested or being
purchased in a PO. This information is quite helpful when you make work plan or
intend to raise new purchase requisition. It’s great to know that you can use an
alternate item instead rather than raising a request and have to wait several months
for the whole procurement routine to be processed.
All item’s related information is shown in one pop-up

Classification/Attribute
Search
:  Maximo is one of the very
few CMMS software that allow cataloging and tracking assets or spare-parts’ classifications and technical specifications in a structured way. If your company
records such information, it becomes very handy when identifying inventory item
codes using the Classification/Attribute Search function. Next to any Item
Number field, you can click on the “Detail Menu > Classification” menu to
open the Classification Search pop-up where you can browse your inventory
catalogs to search for the item code that you want. Only a handful of companies
in this market records inventory item’s technical specification in
Maximo. As such, searching items using technical attributes is often not
possible. However, classifying items can be done pretty quick and many companies already have the data in Maximo. With the item already
classified, using the Classification Search to find item can be very easy and
efficient.
Browse and find items by Classification

Free Maximo Training Resources

Our company employees usually wear the T-shirt that has IBM Tivoli and Maximo logos on it. Because of that, for many times, I was approached by random guys on the street to talk about Maximo. In a few cases, they mentioned that they want me to provide materials to learn about Maximo or give them basic Maximo training. I have a few friends who work in IT and like to learn about Maximo too. So I think it would be helpful for some of you out there to know that you can learn and practice with the software completely free with the resources provided by IBM. In this post, I’ll provide some information and links to some of these sources:
Access to Maximo training environment:
You can access and play around with Maximo using the IBM’s preview environment using the following links or googling “Maximo Asset Management Preview Site”. Accessing this environment is completely free and open to the public.

          Maximo 7.5: http://www-01.ibm.com/support/docview.wss?uid=swg21499350 
The core functionality of the two versions are exactly the same, so any version would be ok for you to learn and play around.
(One side note: if you are serious on being a consultant or need to install your own Maximo system for advanced implementation training or for integration purposes, you can purchase the IBM Software Value Package ($999) to get access to the Software Access Catalog where you can download almost all software provided by IBM including all Maximo versions, industry solutions and add-ons. If you are a business partner and want to have access to different Maximo industry solutions and add-ons such as Oil & Gas, Scheduler, Anywhere etc., you can contact IBM to provide you access to their Skytap environments too.)
Free Online Training courses:
IBM recently created a website at www.iot-academy.info to provide free interactive online training courses. The Asset Management courses provided here cover all Maximo core modules and applications. This should be the first place to visit if you want to learn the basic functionality of the software. The courses available on this site provide both trainings on the functionality and business processes of the software and training for implementer and administrator.
 

Several courses available on iot-academy.info

Besides the two main sites above, there are many training resources made available by IBM, business partners and individuals that you can access too:


YouTube: search for those keywords “IBM” “Maximo” “Demo” you can find a tone of webinars, demonstration, and training video recordings uploaded by IBM and other business partners. Some go quite deep into the functionalities of various applications and modules. (If you prefer to learn the software in Vietnamese, check out my previous post: Maximo Immersion Training
For customization, you should go to Bruno Portaluri’s blog. His Java Customization tutorial series is definitely the best and most comprehensive source that you can find on the web. Simply by spending some time to go through his tutorials, you will master Maximo customization in no time.

All of the training resources provided in this post are free. However, the content of these sites are quite organized and will be enough to make you a competent power user, administrator or consultant, depending on what are you looking for. So don’t bother looking elsewhere and spend a lot of money on expensive classes unless you prefer to learn more advanced topics. 

The most effective way to learn Maximo core concepts

After several years training Maximo end-users and
consultants, I believe there is a right way to learn Maximo and also there is a
wrong way to do it. Contrary to what many may think, to me, the wrong way to
learn Maximo is through the job. This can take a lot of time, several full
cycle green field projects for a consultant, or many months or years for
end-users. By the time the person understands the software, it is often too
late. For a consultant, it could mean many bad implementations or advice had
been given to the customers; for an end-user, it could mean a lot of bad data had
been entered into the system over time.
So what is the right way to learn Maximo? I believe it is
through intensive, comprehensive training right at the beginning when a
consultant starts the job; or for an end-user, it is before he/she starts to use
the system.

But, you may argue, “how can I learn all of those modules and
applications, trying to remember all the menus, buttons, text fields and check boxes
and not spend a huge amount of time on it? Eventually, I have project (for
consultants) or a ton of other daily work (for end-users) to do. I simply
cannot spend several months to learn everything about this software”. Well, I
didn’t say you have to spend months to learn Maximo. It only takes a few days
if you know how to do it in the most effective way.

From my experience, the most effective way would be a guided
training through the key concepts and trying to relate those concepts with real
world examples. In the case of training new consultants for our company, I
would give the guy a real world problem to solve by drawing a motorbike on a
whiteboard. I’ll have the guy to enter information of the motorbike into Maximo
including: the asset – the bike, then the components and sub components such as
the engine, the wheels etc. Then I’ll have him to enter spare-parts information
such as tire, bearing, seal by creating Item codes for them and linking those item codes to the related asset (bike). Balances of the items also need to be
managed in the Inventory app too. The motorbike needs to have an odometer where
the end-user can enter the number of kilometers the bike runs each day. From
that, I’ll ask the guy to enter a preventive maintenance plan to inspect, clean
and change oil the motorbike for every 1000 km it runs or for every 3 months whichever
comes first.

When the guys can carry out all of those activities in Maximo, I’ll
review and ask questions to verify his understanding of the concepts and make
sure that he understands almost all advanced functions related to each concept too.
For example, when creating a new Item record, I’ll ask what is LOT? When should
somebody want to manage an item using this feature? What is KIT? Give an
example of how it is used.  When the “Add
as spare-part” check-box is checked, how does it work in Maximo?

This exercise will
extend to covers all core modules including Asset, Planning, Preventive
Maintenance, Work Management, Inventory, Purchasing and Contract. Although it
sounds a lot, I have seen many people, who have no prior experience with asset
management software, managed to pick up all of the knowledge and able to answer
almost 90% of my advanced questions only after 4-5 days of self-training. Very
few people require more than 10 days to fully understand all Maximo key
concepts This amount of time already includes the time to read books and watch through the training video recordings I provided in this earlier posts.

For the end-users, they usually have to learn on one or two modules,
and only require practical experience in the main processes; it only takes one
or two days of intensive training to get deep understanding of the concepts and
able to use the software effectively without much problem.

Maximo Immersion Training Video Recordings (Vietnamese)

When I started working with Maximo, my supervisor gave me a bunch of training books. The books are created by MRO (the company which owns Maximo before it was acquired by IBM) to provide its customers and business partners basic training to get started with the software. 
The first book I had to read is “MED 0146 – Immersion Training for EAM” written in 2008 for Maximo v7.1. This book is 900+ pages long and is provided as the material when you take the 5-day immersion training course. The problem with following tutorials in the book is that it starts with the basic applications on the first few days, and only at the 4th or 5th day, it starts to connect different concepts to build a complete picture of how an O&M organization can organize its data and processes in the software.

So for the first few days, I was doing the tutorial one by one without any understanding of the whole high level concept.

Later on, I realized that many of my colleagues who joined the company before me had to take a lot more time, some took several months, some took a few years through real project experience to really pick up all of the core concepts in Maximo. There are two reasons for that: first, some of them are not very comfortable reading such a large book in English all day long with all of the technical IT and Engineering terms that they are not familiar with; second, with a huge amount of detailed information and fragmented content, it is more difficult for them to relate the concept to real world examples.
After a year working for the company, I took on the responsibility to recruit and train new technical consultants. So to speed-up the learning process for the new employees, I created a 2-month training plan which covers key objectives as follow:

  1. Able to install the software
  2. Know all core software functions (core processes & concepts such as asset, work, inventory, job plan, preventive maintenance, purchasing, and contracts)
  3. Know how to configure the software (organization /site configuration, security administration, DB configuration, application design, and workflow configuration
  4. BIRT report design & development
  5. Java customization
To help the trainees with having a basic understanding of the core concepts first before they have to dive in into the detailed information covered in the book, I had to setup workshops to run through with each guy to show them the software. It is a condensed version of the core team training class which we usually given to our customers during the first phase of a Maximo implementation project.
Later on, I found that this method takes up a lot of my time because in most cases, we only hire one or two new guys at a time. And I simply cannot find the time give them a few days one-on-one training session every time. Finally, I came up with the idea to record myself giving a presentation to various software functions and how it can be applied in practice. For each of the new employees that we recruited, I simply give him the copies of the recording to watch and learn at his own pace. For each objective, I only have to setup a review session which normally takes a few hours to review and make sure the learner understood the core concepts and be able to relate with real world examples. By doing it this way, after only two months, we were able to formalize the training process and able to bring new employees with no previous experience with Maximo up to the level of competency that we are comfortable to assign them to real implementation project and able to give customer professional level consulting service.
Below is the links to the recording of me giving introduction to Maximo business functions. It corresponds to Objective 2 which I considered the most important topic that every technical consultant must have deep knowledge on. It can also be used by Maximo users or people who are interested in knowing what the software can do.

Links:
01 Basic Navigation: https://youtu.be/1yYXam_mKIg
02 Asset Management: https://youtu.be/hlnU-bmOU74
03 Preventive Maintenance: https://youtu.be/PYs2CDzdPoc
04 Work Management: https://youtu.be/ob0OnJ7jw0o
05 Work Request: https://youtu.be/FS7KUZT19dw
06 Inventory management: https://youtu.be/523qaQeL7LQ
07 Inventory Issue, Transfer: https://youtu.be/CCBVSYlc6zs
08 Purchase Requisition: https://youtu.be/Yr2vx3ZqyuE
09 Request for Quotation: https://youtu.be/E-NTu1xZ6EQ
10 Purchase Order, Receipt: https://youtu.be/hl1OSsIp4Cg
11 Invoice Payment: https://youtu.be/swKUm7m6uAY
12 Blanket (Framework) Contract: https://youtu.be/Trqsfb-m7do
(Bonus) Full End-to-End Process of Maximo: https://youtu.be/uq3MCOjD41M

The links below are for basic training on how to configure the software to address specific client requirements. This part corresponds to Objective 3 of the training course. This targets the implementers or administrators who need to modify the software to address specific requirements from end-users.

Links:
01 User & Security Administration: https://youtu.be/qmrq2hSQk2Q
02 Database Configuration: https://youtu.be/hp7rbNGdwrY
03 Application Designer: https://youtu.be/BN9mAbmnfFk
04 Application Designer (advanced): https://youtu.be/xZWeK3XMMnE
05 Workflow Designer: https://youtu.be/lL22WwOYD8I
06 Automation Scripting: https://youtu.be/K7SJkatMOvA
(Bonus) All Maximo standard functionality: https://youtu.be/GB6n7oprP5A

*NOTE* for tutorials in English, please read this newer post