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]
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]
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]
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]
I need to set limits when faced with these. Knows as Fluffernutters, smooth, decadent peanut butter and sticky marshmallow topping on plain white bread form the ultimate comfort sandwich. With a cold glass of milk, the number I can toss down is crazy high.
You may also need to stop your users from over-indulging by setting records limits when they create Ad Hoc or QBR (Query Based Reports.) The creation process of ad hoc reporting is where users select the fields, application query,... [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]
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]
March Madness – two marvelous words with multiple meanings. It may have you rooting for your favorite team in the NCAA Basketball Tournamen t or waiting impatiently for your iPad 3 to arrive. It may have you joined in mass with others celebrating St Patrick’s Day , or anxiously waiting for Spring to finally arrive. Whatever your March Madness may involve, let's take a step back and review another March event - Pulse 2012. During the Reporting presentation at Pulse, we delved into the details of BIRT and Cognos reporting functionality,... [More]
Veterinary Poison Control for Humans – How can I help you? This wasn’t the phone call I had planned to make early this morning when I accidentally swallowed my dog's arthritis medicine - instead of my daily vitamins. The folks at Pfizer were extremely non-judgmental and assured me that many other ‘humans’ had made this same mistake. They encouraged me to drink extra fluids today, and to work on more clearly separating the dog’s medicines from the human vitamins. As I was re-visiting this adventure on my drive into work – I thought... [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.