Hoo. Yes...Not Yahoo...Yoo Hoo. I was introduced to this chocolate
milk type drink last week when I hosted over 40 girls from my daughter's
high school swim team for a pasta dinner. After a long day of school
and practice, the girls descend onto a parent's house to refuel
themselves with pasta and Yoo Hoo's before heading off to their next
activity of another swim practice, work or homework. I quickly lost count of how many cartons of Yoo Hoo's were consumed at our house....but couldn't get that marvelous, celebratory... [More]
On Tuesday, September 20 th , I had an amazing
opportunity to host a web conference for our Maximo and Version 7 clients. This session shared the latest information on Business Intelligence and Reporting, but most importantly - was opened up for over 60 minutes to give you - our clients - the opportunity to ask questions. With representatives from over 15 companies, you asked tremendous, detailed questions on reporting strategy and functionality. Your questions led others to ask questions -- so you quickly learned information and best... [More]
In the Version 7 releases, you can create very powerful ad hoc reports in within the various Maximo applications - without requiring developer's technical skills or database knowledge - to meet your individual business and project needs. This functionality is often referred to as QBR, or Query Based Reporting. Throughout the BiLog (Business Intelligence) entries, I've touched upon some of the features of QBR reporting including
Using an application's query and extending thru QBR at http://ibm.co/hzh70D
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]
…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]
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 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]
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]
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]
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]