Within the Maximo and Version 7 product lines, there are numerous ways you can analyze your data. As a Balderdash lover and an IBMer immersed daily in a sea of acronyms, these data options are listed below in increasing range of data analysis capability. QBE – Query By Example. Using your application’s filter and/or query, you can immediately download your results for additional analysis in Microsoft Excel. KPI - Key Performance Indicators. Visual indicators displaying status against predefined targets. RS – Result Sets. ... [More]
QBE (Query by Example) is an excellent way for you to quickly take the results of your application query and/or filters and export them to Microsoft Excel. You can then view each of the list tab fields, and perform additional analysis, combine the data with other queries, print, or save. However, often users want to see additional fields in the exported data. And the fields that one user may want to see are not the same as fields another user may want to see. You can modify the list of fields that displays with the Application Designer. ... [More]
How many custom reports do you have? Do you have 25, 50 – or is your number in the
range of 100 to 250 custom reports? Or
are you in the category where you don’t know how many custom reports you have
because your users are creating their own uncontrolled reports in tools like
The topic of custom reports leads to a myriad of questions
- Is each custom
- What determines if
a custom report is approved, and then developed?
- Should super users be given database and... [More]
As the building blocks to Version 7’s Ad hoc reporting tool,
QBR (Query Based Reporting), Report Object Structures (ROS) enable you to select fields
from multiple categories (objects) for your ad hoc reports. Additionally, ROS enable you to visualize application
categories and their parent/child relationships. These categories are displayed via a category
tree drilldown in the Select Tab of the QBR window in the top left hand
Depending on the products you are licensed for, you will
receive over 20 ROS out of the box.... [More]
The previous BiLog entry discussed
the key items to consider when defining maxrelationships in your ROS.
One of its major components is c ardinality, which is used to define
the type of the database relationship.
In the case of reporting, there are two types: One-to-one (1:1) or single relationships, or One-to-many
(1:N) or Multiple Relationships.
To highlight the differences in cardinality, let’s use an
example from the Purchase Requisition application.
The relationship between a Purchase
Requisition and a Company... [More]
Coming in on a Monday morning after a great Red Sox win over
the Yankees last night…I can’t help wonder what is the biggest team win you’re
recently experienced. Was it the 2004
Red Sox World Series Championship? Or maybe a political lobby you have been
involved with for something like the approvals of Wind Turbines? Or maybe something simpler like your child’s music,
baseball, or lacrosse team win this weekend?
One of the biggest team wins I’ve recently been involved
with is with the release of our latest software, Maximo... [More]
…the tools that give us the power
of change. From the Faber Castell Eraser
that lets us fix the mistake on our college math test, the whiteout we use to
correct information on a form or the magical F2 and backspace keys that let us
fix our occasionally turbulent keystrokes.
Sadly, some things in life can’t
be edited. We can’t go back 25 years
ago to 1986 with our eraser and correct Bill Buckner’s fielding error with the
Red Sox that cost them the World Series, or buy oodles of Microsoft Stock when
it went public at... [More]
Have you ever encountered or built
a cairn ? Cairns
are stacks or formations of rocks that you can often see on hiking trails or
parks. Some believe they are used as
trail markers, while others state they are artistic monuments celebrating
nature. I saw a number of cairns while taking a break from teaching a course in Arizona last week, and added
my own interpretation while heading back from Squaw Peak Trail.
As I thought about this week’s
blog – I couldn’t help but think back to those really cool cairns and how they... [More]
Choices. Every aspect
of our lives is packed with them.
Firefox, Chrome or IE? Small,
Medium, Large or Jumbo? Mouse or
touchpad? Blueberry pie – with or
without ice cream? Shoes, Sneakers or flip flops? To tweet or not to tweet? Keeping with that trend, we are now enabling you additional
choices for your development of V7 reports with the delivery of Portrait Report
Report Templates are one of a few different ways your report
developers can create custom reports in the Version 7 Report Design Tool.... [More]
Clear. Cold. Refreshing. Three words which could describe anything from a glass of water, a plunge in the Arctic Ocean, rice noodles, a class mint Mojito, or a run thru a sprinkler on a hot July Day. Maybe another image comes to your mind...and you may quickly see where I'm going with this. Text descriptions can often lead much to the imagination . Visual ambiguities however, can lead to serious issues in our work environments, as everyone must have the same, consistent understanding of assets, items, or work orders. A solid way to enable... [More]
Do you remember the feeling when you put on a pair of pants that you
haven’t worn in awhile, and find money in your pocket? Whether its $1, $5 or even sometimes $20 –
its an unexpected surprise – finding this great treasure that you didn’t
know you had. Over 4 million Facebook
users agree with this amazing feeling of ‘Finding Money In Your Pocket’! This same feeling holds true to the Business Intelligence (BI) features in Maximo. We often spend so much time talking about the new features in each release, that we neglect the... [More]
When disasters like the massive earthquake earlier this year in Japan, or the deadly earthquake that hit Haiti in 2010, people and organizations from all over the world work together to help and rebuild these devastated areas. I am very lucky to have the opportunity to help locally by rebuilding houses for people in need through Habitat for Humanity. This weekend I worked with an amazing team of individuals, including power company employees, a school teacher, a housewife, a retired architect, and high school teenagers, in rebuilding a... [More]
During the last week of July, over
800 individuals gathered for IBM Tivoli’s Pulse Conference in Melbourne, Australia. At the second largest Tivoli Pulse Conference, attendees networked and interacted to learn from IBMers and Business partners on the latest functionality and products and from other
attendees on implementation best practices. This blog post has more details: Australian Pulse Conference. I had the amazing opportunity to present on Maximo Reporting at this conference, and a key topic that came up with a number of clients was... [More]
In last week’s BiLog , we talked about report usage, and how
you can utilize a variety of mechanisms, including reports, KPIs or result sets
to monitor which reports your users are and are not using. Report usage information is also critical in identifying
your reports which take to longest time to execute, as you want to insure these
are optimized for report performance.
Why is this important?
Like so many things, reports follow the 80/20 rule, where 80% of your
report processing is done by only 20% of your reports. So as... [More]
Do you ever find yourself stuck in car or airline traffic? If you have, do you find yourself deeply sighing or groaning in agony thinking of where you need to be? Or do you become a pounder – pounding your fists on the steering wheel or your feet thru the airline concourse while a number of choice words come muttering out of your mouth?
Living in the Boston Area for the last 12 years, I’ve encountered a number of car and airline traffic jams. My most recent traffic jam was last night... [More]