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]
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]
I dissected our kitchen junk drawer this weekend. Although I’m not a hoarder , I did find a 41 golf pencils , $1.53 in Change and and 3 postcard stamps! While on this clearing spree, today’s Bilog dissects how QBR reports are stored in the database to clear up any confusion you may have. QBR, or Ad Hoc reports, enable you to create reports ‘on the fly’ without technical database or report development skills. In this previous BiLog entry, best practices were reviewed to detail which specific users you may want to grant QBR security... [More]
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]
“Seemed like a nice round number”. These were the words Paul Newman
spoke as he committed to eating 50 hard boiled eggs in an hour in the infamous scene from the movie “Cool Hand Luke” While recently watching this classic movie – and Paul Newman’s stomach extend uncomfortably with the onslaught of the eggs – I couldn’t help but relate his adventure on how you can also extend QBR reports in Version 7 – comfortably. In previous Bilog entries, I’ve detailed how you can extend QBR reports to include long descriptions ,and audit enabled... [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]
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
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]
One W separates brownies from bronies. Brownies are incredible, delectable chocolate goodness, while bronies are followers of a children's TV Show. Bronies and their collections of Little Ponies have become increasingly popular in the Software Development world thru their features in Wired Magazine . While I’m not a bronie, whenever I hear about software and collections, my mind jumps over to data collection. Last week, I talked to a client about long descriptions, which are available in the various Maximo applications to collect large... [More]
Do you collect coins? In a gargantuan container that once held a supersize collection of cheese puffs? My mammoth 24 x 8 inch plastic container was so packed full of coins, it broke thru its bottom when I recently tried relocating it... Maybe relocating wasn’t the best plan for the coins….which is just one of the many collections I’ve shared with you this year. Others included post cards , National Park Stamps , photos , and BiLog entries! Yes! BiLogs are a collection of Maximo Business Intelligence Blogs detailing reporting... [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]
Got Game – Holiday Game? Game
from cheering on the Packers, maximizing your consumption of apple or pumpkin
pie, or Game from braving the crowds on Black Friday? My game came into play last week in a
Lasertron Match with over 40 family members after an incredible Thanksgiving
Day Feast. While my phaser accuracy would cause teammates
to cry for trades, our family had an amazing time in our annual, Buffalo tradition.
As we turn from holidays back to the work week, we change from
Got Game to Got Audit Requirements.
…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]
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]
I found my eyeballs in the attic. They were waiting for me this weekend as I waded thru a box of festive Halloween decorations. The eyeballs screamed ‘clone’ to me….cloned alligators , cloned ostriches and cloned Maximo applications. When you clone a Maximo application, you may want to enable QBR (Ad Hoc Reporting) functionality for a new or cloned application. The steps below detail how you can do this. 1. Verify that the RUNREPORTS Security Option is enabled for your cloned application. (This is a Prerequisite sigoption to the QBR... [More]