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 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]
Throughout the last few BiLog’s
we’ve been introducing you to the new report features in the recently released
7.5 product – while keeping you immersed in acronyms, Boston Red Sox Trivia and
other amazing facts on erasers and how long it took to build Rome .
And while you may expect a trend
here to continue, let me take a slight detour
and introduce a new backronym, RTF. If
you’re not familiar with backronyms, it is where you have an acronym – and then
find the words to form one. So – while you
would expect RTF in this... [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]
On June 10, 2011, a new report option has been made available for Maximo 6 clients in the version 6.2.8 release. This option extends our current suite of reporting tools to enable the user of BIRT reporting thru a Maximo version 7 instance. This new integration is called Version 7 Report Integration, or V7RI.
The V7RI integration utilizes the ERI, External Report Integration to integrate your existing Maximo 6 environment to a version 7 Environment, which is configured for reporting only.
To enable this... [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]
Sitting here in my cube with my stomach growling at a increasingly rapid pace, I can’t help but think of how the Maximo database is like a food buffet. Those huge, long food buffets overflowing with food often found on a cruise ship, in Las Vegas, or if you’re lucky, at a neighbor’s open house. We often overindulge at these buffets, eating well over our capacity – because the food is there and we think we need it.
Like buffets, Maximo users often have access to large amounts of data. And with this access, users may believe they... [More]