Jason Verly, IBM Champion with Davisco Foods International, gave a great presentation to the TUC community members yesterday on Using Ad Hoc Reporting and How to Leverage the Maximo Where Clause. He was gracious enough to stick around 20 minutes after schedule to answer member questions and demonstrate live via demo how to do certain requests. You can check out the replay here in the TUC! Please remember to login to view the replay. If you're not a member of the TUC, you may register here to join and find a Group. www.tivoli-ug.org The... [More]
TUC Webinar - come learn with us!
Please join the Tivoli User Community for a live Webinar
and opportunity for questions, today, Wednesday, April 18, 2012 11:00
am, ET, USA
There are still "seats" available for today's complimentary TUC webinar with Maximo user, Jason Verly. Subject: Using Ad Hoc Reporting and How to Leverage the Maximo Where Clause
Reserve your Webinar seat now at: https://www1.gotomeeting.com/register/115202680
Overview: Jason will focus on how they use Ad Hoc... [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]
Single, Married or It's Complicated. Those are a few of the eleven choices Facebook gives us to define our Relationship Status. With V7 Reporting, we've made it easier to define your maxrelationships by offering you two clear maxrelationship types - simple and complex . In a http://ibm.co/j5e5av earlier this year, ROS (Report Object Structures and maxrelationships were discussed. ROS were highlighted as the building blocks of Version 7's Ad hoc reporting tool, QBR (Query Based Reporting). The ROS provide a collection of the... [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]
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]