Home

 

Site of the day

MAXIMO/Training: Projetech Inc.
Location: Cincinnati, Ohio, United States.

Projetech Inc. helps you make the most of MAXIMO. We offer MAXIMO training at our Cincinnati office or we can deliver any class at your site. We also specialize in customizing classes to meet your needs. Contact us by visiting our web site or by dialing 1-800-611-2884.


MAXIMO – Tip of the week

Submitted by: Chris Winston, Projetech. Cloned apps can get cloned queries. For example, let’s say you clone the purchasing app 10 times for different requirements and groups in the organization. Somewhere along the way, you get a request for a saved query to find an order by the item number entered (or something else on the line). Here are a few standards to try to live by:

Instruct all users that if they are to use a public, saved query, they can execute, but not edit it to their liking and save it; they can make their own version and save it under their own userid.

Give a unique name to a saved query in a cloned app, that is unique across all the clones at minimum (you may wish to use it later as you will see).

When you know it is a good query to have in each of the clones, publish it with the same clause name, description and syntax, owner = ‘*’ and just change the app name for each of the clones.

For example, let’s say you create the query ORDERSBYITEMNUM, described as ‘Find orders for certain item numbers’ and syntax

WHERE PO.PONUM IN
(SELECT PONUM FROM POLINE
WHERE
POLINE.ITEMNUM IN (‘ITEMNUM1’, ‘ITEMNUM2’))

where ITEMNUM1…. can be altered to allow entry of 1 or more item numbers as part of the query.

Last but not least, feel free to back up the query table redundantly, rather than with rolling backups that overwrite old versions. Just save it in a format like QUERY_YYYYMMDD to keep it simple, at minimum, and if possible, just use one backup table with all the fields in the query table and a date and simply append the table each time using the current SYSDATE. This will allow you to go back in time if needed, and has saved me on more than one occasion, usually in the middle of the night when few people are around.


Recommended reading/learning

Total quality management: Quality Maintenance : Zero Defects Through Equipment Management

More...by Seiji Tsuchiya, Seiji Tsuchiva. Achieve zero-defect product quality by eliminating the root causes of your equipment defects. An easy-to-read case study of TPM, TQC and JIT at a world class manufacturing plant.

 

 

Training and skills: McGraw-Hill Machining and Metalworking Handbook

More...by Ronald A. Walsh. This benchmark guide to techniques and procedures essential to achieving the highest quality machining and metalworking contains thousands of machining and metalworking facts and techniques in a logical user-friendly format.

Comments are closed.