[Page last updated on 06 May 2021]
HEALTH Lab on Maximo Application Suite (8.3)
Disclaimer
This Lab is provided as-is and does NOT represent formal IBM documentation in any way. Please send any feedback directly to Christophe Lucas.
TIP: If the images seem too small to read, just right-click them, open in new tab and zoom in/out. I have tried to make all images readable with clear 1., 2., 3. etc references to the corresponding instruction steps.
0. Prerequisites & Objectives
Prerequisites
There are no prerequisites if you just plan to go till section 9. Update the Health Scoring Method - you will generate all the data that you need in this Health lab which is self-contained.
But if you plan to also complete the last section 10. [OPTIONAL] Map IoT Devices & Readings to Assets & Meter Readings, then you will need to have completed the first section of the Monitor lab: 1. Generate IoT data. This is because - and that is the beauty of the fully-integrated suite - the IoT data that we created in the first Monitor Lab steps of these APM labs is the exact same data that is used in these last Health Lab steps - thus enabling true, near real-time monitoring and condition-based maintenance of your assets !
Objectives
In this Module you will:
- set up the required Assets and Meter Groups in Manage (aka Maximo)
- create a sample Health Scoring Method, a Criticality Method and a Risk Method in Health
- populate all Cards (i.e. Health Score, Criticality, Risk, RUL, Age, Next PM, MRR) on your sample
CL_Asset_1
in Health - [OPTIONAL] finally, associate the IoT Devices we defined in the first Monitor Lab steps of
1. Generate IoT data
to the
CL_Asset_1
and set up the required mappings between your IoT readings and Maximo Meter Readings.
Note that in this section, we will alternatively mention Manage or Maximo - both names refer to the 1 same thing.
1. Setup initial Manage data
Important Note on Naming Conventions: in this lab, you will create Assets which we name here CL_Asset_1
, CL_Asset_2
etc (CL
standing for Christophe Lucas).
In a classroom setting, make sure every student replaces the CL
by their initials throughout the lab e.g. XY_Asset_1
,
AB_Asset_1
etc.
1. Launch Manage from MAS Suite Navigator
- Login to your MAS homepage. Click
Launch
on the Manage card. This will open Maximo in another browser tab. Login with your Maximo ID/pwd.
2. Create 3 Assets & 1 Query
- In Maximo, click the
Go To Applications - Asset
Menu. Click the+
button to create an Asset, enterXY_Asset_1
- whereXY
are your initials. Note that for the rest of this lab, we will useCL_Asset_1
(e.g. CL for Christophe Lucas).CL_Asset_1
in both the Asset ID & Description fields. ClickSave
. Repeat this step forCL_Asset_2
andCL_Asset_3
. - Click the
List View
menu. In the Asset field, enterCL_Asset*
, click enter. This should return the list of your 3 just-created CL_Assets. Click the Save Query button, enterCL_Assets
in both the Query Name & Description. Tick thePublic
box.
3. Create a Meter Group
In this section, we will create a Maximo Meter Group containing 8 Meters that we will later associate to the IoT readings that we defined in the first section of the MONITOR lab.
- In Maximo left
Find Navigation Item
box, enter theMeter Groups
application. - Click the + button to create a Meter Group, enter
CL_Asset
in both the Meter Group & Description fields. - Click
New Row
and in the Meter field, clickSelect Value
. In the Select Value window that opens, enterTemp
in the Meter field, hit Enter, selectTEMP-C
. - Repeat previous step with the following Meters:
VIBRATIONH
,PRESSURE
,SPEED
,ACCELERAT
,LOAD
,TORQUE
,STARTS
. Click theSave
button.
Note that, although Meters like PRESSURE
often exist in Maximo installations out-of-the-box,
some of the Meters appearing in step 4. might not exist in Maximo yet. In which case, do the following:
(a) Go to the Meters
menu via Find Navigation Item
, (b) click Create
new Meter, enter e.g. ACCELERAT
(the maximum name length is 9 ),
select GAUGE
as Meter Type
, then Save
. That newly created Meter can now be added to the Meter Group in step 4.
4. Associate Meter Group to Assets & create Meter Readings
- In Maximo, click the
Go To Applications - Asset
Menu. In the Asset field, enterCL_Asset*
, click enter. This will return the list of you 3 CL_Assets, clickCL_Asset_1
. - Go to On CL_Asset_1, go to its Meters tab, click
Meter Group - Select Value
. In the Select Value window,CL_Asset*
, click enter, select theCL_Asset
Meter Group. ClickSave
. This has loaded all the Meters we defined in the Meter Group. - In left Find Navigation item box, enter
Enter M
, clickEnter Meter Readings
. For each Meter, enter values within the ranges that we defined for the IoT readings at the beginning of the Monitor lab in 2. Create IoT Simulation. For example:TEMP-C
=37
,VIBRATIONH
=4
,PRESSURE
=22
,SPEED
=17
,ACCELERAT
=9
,LOAD
=100
,TORQUE
=12
,STARTS
=1
. ClickOK
. - Repeat steps 1. to 3. for
CL_Asset_2
andCL_Asset_3
with whatever Meter values you want.
5. Create a Condition Monitoring Rule
We are now going to define a Condition Monitoring rule where
we will create upper and lower limits for the Meter Readings corresponding to TEMP-C
, for Asset CL_Asset_1
.
-
In Maximo, click the
Go To Applications - Condition Monitoring
Menu. Click the+
to create a new Condition Monitoring. Name itCL_Asset
. In the Point and Description fields, enterCL_Asset*
. Next to the Asset field, clickSelect Value
, search forCL_Asset_1
, select it. Next to the Meter field, clickSelect Value
, search forTEMP-C
, select it. -
In the Upper Warning Limit field, enter
40
, in the Lower Warning Limit field, enter35
. In the Upper Action Limit field, enter45
, in the Lower Action Limit field, enter30
. Note that those values roughly correspond to the"temperature": random(35,40),
values we originally defined in our IoT Simulation. With those limits defined, Condition Monitoring should pick-up those anomalous"temperature": random(46,48),
we generated ! -
In the Upper Limit Job Pan field, click
Select Value
and select whatever existing Job Plan you want (we're just doing a demo here !). Do the same for Upper Limit Job Pan. ClickSave
. Your final screen should look like picture below.
2. Setup Health
1. View your Assets in Health
- From the MAS homepage, Click
Launch
on the Health card. - Go to the top-left Assets menu. Enter
CL
in the Search bar. This will return the 3 Assets we just created in Maximo. - Click on
CL_Asset_1
, and observe the various cards that appear out-of-the-box - they are all empty for the moment. Let's populate them !
NOTE: it is normal that you see Predict in the top middle menu, even though you accessed this screen via the Health card. As you can see, Health & Predict actually appear on the same UI (i.e. Predict corresponding to the Predictions section just below the Health details section). When a user is entitled to both Predict & Health, Predict is always displayed. With a user only entitled to Health and NOT Predict, the top-middle menu would display Health.
2. Create Factors in Health associated to Meters in Manage
Before we create our Scoring Methods, let's first check that the Meters we associated to the 3 CL_Assets in 4. Associate Meter Group to Assets & create Meter Readings exist (or not) as Factors in Health already - if they already exist, good, if not, we'll just create them.
- Go to the top-left Scoring menu, then go to the Factors tab.
Check which ones of the Meters you earlier defined already exist as Factors in Health, e.g. typically you will see that
VIBRATIONH
,TEMP-C
are already defined, but NOT e.g.Speed
. Let's addSpeed
as a Factor. On the Factors tab, clickCreat Factor
. - Name your Factor
Speed
, selectMeter
in theCalculate a score from
box. Then selectSpeed
in the pop-up box. In the Score Normalization's Upper & Lower Limits, enter20
&15
(corresponding to the upper & lower limits we originally defined in 1. Create IoT Simulation).
3. Create a simple Health Scoring Method and associated Drivers
Let's first create the Health Method itself:
- Via the Scoring menu, go to the
Methods
tab and clickCreate method
. Name your methodCL_Asset_Health
, and selectHealth
in the Type drop-box. - Under the
Scored Assets
field, clickSelect
and select theCL_Assets
query we defined in 2. Create 3 Assets & 1 Query section.
Let's now add Drivers to this Method:
- Staying on the
CL_Asset_Health
Method, click the+
top-right icon to create a Driver. Name itMeter Readings
, selectOne or more factors
in theCalculate a score from
tick-box. ClickCreate
. - The
Meter Readings
Driver now appears in the Drivers list, but is still empty. Let's add all the Factors (associated to Meter Readings) we just created to this Driver. Click the+
top-right icon to select those Factors. - In the opened
Select factors
window, select the 8 Factors relevant to our CL_Assets and clickAdd to driver
. The 8 Factors are now added to the Meter Readings Driver. - Click the top-right pencil to give a Weight to the 8 Factors.
Note the total of the 8 Weights must be 100%. Enter
10%
for all Factors, except forTEMP-C
for which enter30%
.
4. Check your Health Score card and make it change
We are now going to first check that the Health Scoring Method we just defined results in a Health score being calculated for our CL_Assets, based on the Meter Readings we entered in earlier section. Then, we will enter new Meter Readings for CL_Asset_1 and notice that its Health Score automatically changes.
- Go to the top-left Assets menu. Enter CL in the Search bar. This will return the 3
CL_Assets
. SelectCL_Asset_1
. Notice how theHealth
card displays a score of 70%. Going into theHealth details
card, notice how you can see the values of all the Meter Readings we entered, and how, based on the Factors and Method we defined, each Meter either shows red or green. Note that you can also see all Meter Readings in theOperational status
section. - From Health, access Manage by clicking on the top-left
IBM Maximo Application Suite
banner, then by clicking the Manage card. - Go to Maximo's Asset menu, enter
CL*
in the Asset field and click enter. This will display the 3CL_Assets
, select yourCL_Asset_1
. In theFind Navigation Item
menu, writeEnter Meter Readings
, click Enter and just enter a value of55
forTEMP-C
. This means thatTEMP-C
is going to move above the normal operating conditions we originally defined in the IoT Simulation (i.e. between 35 & 40 Celsius). - Go back to Health. Select your
CL_Asset_1
row. Top-rigt, clickRecalculate Health score
. Observe how your Health card gets updated from70%
(orange) to40%
(red).
5. Create Criticality & Risk Scoring Methods and populate Criticality & Risk cards
We now are going to create another type of Method, i.e. a Method of type Criticality
which will feed the Criticality
card on a given Asset.
- From the top-left
Scoring
menu,go to theMethod
tab and clickCreate method
. Name itCL_Asset_Criticality
. In theType
, selectCriticality
. In theScored Assets
, select theCL_Assets
query as we did in section 3. ClickCreate
. - Click on the just created
CL_Asset_Criticality
link. Click the to-right Edit pencil. In theFormula
field, just writePriority
. NOTE: in this case, we are simply defining the Health Criticality score of a given Asset as the value of the Asset'sPriority
field - which we will populate in Maximo in next steps. We will see in next sections how more advanced formulas can be defined, where pretty much any other field associated to the given Asset in Maximo can be used. - As a final step for this Criticality card, make sure you tick the
Active
checkbox to activate ourCL_Asset_Criticality
method.
Let's now create a Risk Method and populate the Risk card.
NOTE: Because the definition of Risk might vary from an organisation to another, this Risk Method is fully configurable. You can use these Formulas references to have an idea of what custom formulas you can construct. By default, the Risk Score in MAS-Health is defined as follows: By default, risk is calculated by dividing the remainder of the health score by 100 and then multiplying the resulting number by the criticality score.
- From the top-left
Scoring
menu, go to theMethod
tab and clickCreate method
. Name itCL_Asset_Risk
. In theType
, selectRisk
. In theScored Assets
, select theCL_Assets
query as we did in section 3. ClickCreate
. - Click on the just created
CL_Asset_Risk
link. Click the top-right Edit pencil. In theFormula
field, writeIF((ISNULLF(ASSETLOCSCORE("health")) || ISNULLF(ASSETLOCSCORE("criticality"))), NULLVALUE(),((100-ASSETLOCSCORE("health"))/100)*ASSETLOCSCORE("criticality"))
. That is the code translation of what we just wrote in earlier Note. Make sure you tick theActive
checkbox to activate ourCL_Asset_Risk
method. - Go back to
CL_Asset_1
, open it and top-right, clickEdit source aset record
, that will open the asset in Maximo. There, simply enter3
in thePriority
field, clickSave
, go back to Health. - Wait a minute (for some Manage-Health background process to complete),
go back to your
CL_Asset_1
, click top-rigtRecalculate Health score
and observe how both yourCriticality
andRisk
cards now display data !
6. Populate the RUL & Age cards
The Age
card displays the current system date minus the installation date of an asset.
The RUL
card is calculated as follows: The remaining percentage of the asset's useful life. The remaining useful life (RUL) is calculated by subtracting the age from the manufacturer’s expected life. If the age exceeds the expected life, the RUL is 0%..
So back to CL_Asset_1
in Maximo, simply set a value in Installation Date
(set it e.g. > 5 years in the past),
and a value in Expected Life
(make it > 15 years). Go back to CL_Asset_1
in Health, click top-right Recalculate health score
button, and ... there you go: the Age
and RUL
cards are now populated !
7. Populate the Next PM & MRR cards and the Asset Timeline
The Next PM
card displays the time until the next scheduled preventive maintenance (PM) event.
To populate it, we must therefore associate a preventive maintenance to our asset. To do that:
- Go back your
CL_Asset_1
in Maximo. In the top-leftFind Navigation Item
menu, writePreventive Maintenance
and click enter. That will take you to thePreventive Maintenance
menu. - Click the
+
top button to create a newPreventive Maintenance
. Leave the PM ID as-is, and writeCL_Asset_1_PM
in the PM Description field. In theAsset
field, select yourCL_Asset_1
. - Go to the
Frequency
tab. In the sectionTime Based Frequency
, enter3
inFrequency
, and in theEstimated Next Due Date
, enter a date e.g.55
days in the future. - In
Find Navigation Item
menu, writeChange Status
, click enter, and set the Status toActive
, click OK. - Wait a minute, then go back to
CL_Asset_1
in Health. ClickRecalculate health score
in top-rightActions
menu ... and you should now see aNext PM
value !
The MRR
card displays: The maintenance-to-replacement ratio (MRR) for the asset. The MRR is calculated by dividing the current total cost of all maintenance for the asset, including parts and labor, by the replacement cost.
To populate it, we must therefore create work that has costs associated !
- In Maximo, open
CL_Asset_1
. In the left menu, clickCreate - Work Order
, name itCL_Asset_1_WO_1
. - Go to the
Work
tab, you will see the just createdCL_Asset_1_WO_1
. ClickGo To Work Order Tracking
. - On the opened work order, from left menu, click
Change Status
and set the status of the work order toApproved
.
- Go to the
Actuals
tab and at the bottom of that tab, click theSelect Labor
button. (NOTE: Here we expect that your Maximo instance has a least 1 existing Labor already). Select e.g.BALL
. Extend theBALL
row. - In the
Details
section, enter aStart Date
in the past, and enter e.g.10
in theRegular Hours
field. Note theRate
value (i.e.22
in this case) and how theLine Cost
=Hours x Rate
(e.g. 220 = 22 x 10 in our case). - Click
Change Status
and set the status of the work order toComplete
. - In the left menu
Find Navigation Item
, type then launchRun Reports
. In theReports and Schedules
window that opens, navigate to theMaintenanc Cost Rollup Update
. ClickCreate Report
. On theRequest Page
, select aSite
(e.g. =BEDFORD) and set theSchedule
toImmediate
. ClickSubmit
.
Finally, we can see our last card populated !
In this case, the MRR now equals 27.5%
- which indeed is the result of this calculation:
Total Cost / Replacement Cost = 220/800 = 27.5%
.
9. Update the Health Scoring Method
As a last exercise, we are going to update the Health Scoring Method we earlier defined. This will give you a glimpse at how configurable health scores are.
- In Health, go back to the left
Scoring
menu. Open theCL_Asset_Health
Method andDeactivate
it (top-right). Click the+
top-right icon to add a newDriver
. EnterYear to Date vs. Replacement Cost
in the Name and tick theA custom formula
tickbox. In the formula field, enterIF(ytdcost>(replacecost/50),20,20-PCT(ytdcost,replacecost))
. This is another calculation involving theYear to Date Cost
andReplacement Cost
associated toCL_Asset_1
. In theBest Score
enter100
, and inWorst Score
enter0
. ClickCreate
. - Similarly to what we just did, create another
Driver
, call itOpen Work Orders
. In theCustom formula
field, entercount$openwo
. In theBest Score
enter0
, and inWorst Score
enter5
. ClickCreate
. - On the Drivers list, click the top-right pencil, and give weights to the 3 Drivers,
e.g.
Meter Readings
at60%
,Year to Date vs. Replacement Cost
andOpen Work Orders
at20%
. - This is what your
CL_Asset_Health
Drivers list should look like.
Finally, come back to your CL_Asset_1
, click Recalculate Score
and ...
contemplate your work - well done and congratulations !
10. [OPTIONAL] Map IoT Devices & Readings to Assets & Meter Readings
In this last optional section, we will map the IoT Devices & Readings we defined in the first steps of the Monitor Lab to the Assets & Meter Readings we defined in the earlier 1. Setup initial Manage data step of this Health Lab. This will enable the automated synching of the IoT Readings to Manage Meter Readings - in this case, we will take an hourly average of the IoT readings and transform them into 1 new Meter Reading every hour. That is what will ultimately make real condition-based maintenance a true possibility !
Go to your Manage - Health integration page (typically set at: http://MANAGE-URL/maximo-x/#/administrator/integration
),
and to the IoT Connector
tab.
- On the
IoT Connection Service
tab, tick theIBM Maximo Asset Monitor
tick-box. ClickNext
3 times. NOTE: For these labs, we assume that theConfigure IoT Service
andConfigure End Points
were already set by your instructor. - On the
Register Device Types
tab, selectCL_Asset_LI
(which corresponds to the Logical Interface you defined in 4. Create Physical & Logical Interfaces). Click theRegister as asset
button. -
That will move you to the
Map Data Schema
page. On theCL_Asset_LI
row, click the right Edit pencil. On the openedSchema
tab, clickDetect from a connected device
andFrom first available
. ClickGet Now
. Assuming data is flowing to yourCL_Asset_1
device, that should populate the box below the button with a json corresponding to your IoT readings. ClickSave changes
. -
On the
Device Type mappings
tab, clickAdd Mapping
button.
Let's now do the associations between the IoT Device Readings and Manage Meter Readings.
- Click
Select meter
and selectTEMP-C
. In theIoT Device Type Property
, selecttemperature
. In theData collection
section, tick theAgregated
thenDetect from a connected device
andFrom first available
tick boxes. ClickGet now
thenSave changes
. Selectavg
(i.e. average) in theValue
field, andHOUR
in theTime Period
field. In theDat Synchronization
section, make sure you tickCron Task Instance Active
. - Repeat step 1. for the 7 other readings. Select
avg
for all, except forSTARTS
for which selectcount
. - Your final
Device Type mappings
tab should look like this.
Finally let's associate the IoT Devices and Manage Assets.
- On the
Associate Devices
tab, click theAssociate Assets
sub tab. TypeCL_
in the Search field. On the first row whereCL_Asset
=CL_Asset_1
andMeter =
PRESSURE, select
CL_Asset_1_LIin the
Device Typecolumn, and
CL_Asset_1in the
Device ID` column. - Repeat step 1. for the other 7 Readings. Do not forget to click the
Save
icon. That wil move you to theManage Assets
tab which should look like this.
Thats' it ! To check that the associations worked well, just wait a couple hours, then
back in Health, open CL_Asset_1
, go to the Operational Status
tab, click TEMP-C
and observe that every hour,
a Meter Reading entry has been automatically created taking the average of the past hour IoT readings.
Well done again - you are now ready to consider a move to a real Condition-based maintenance regime for your (critical) assets.