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 thru Habitat thru Humanity. Recently, I worked with an amazing team of
individuals, including Power Company Employees, a school teacher, housewife,
retired architect, and high school teenagers, in rebuilding a... [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 wow surprise – finding this great treasure
that you didn’t know you had.
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 hidden treasures.
What are these hidden treasures
that you already have... [More]
Choices. Every aspect
of our lives is packed with them.
Firefox, Chrome, Safari or IE? Small,
Medium, Large or Jumbo? Mouse or
touchpad? Apple pie – with or
without ice cream? Shoes, Sneakers or
flip flops? To tweet or not to
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... [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... [More]
This BiLog entry discusses
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... [More]
In a new entry in the Asset Management blog, the new
features of Migration Manager in the 7.5 release are detailed. Each new feature is listed, along with ideas
of how you can best take advantage of it in your unique environment. For more information, see the original blog entry .
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
Microsoft Access or Microsoft Excel?
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... [More]
During last week’s reporting web conference , one question that was asked was how you could
configure your favorite reports to display directly on the Start Center. These might be reports you frequently access, or that you
want your users to focus on as they contain critical information.
One way you can do this is by using the Report List
Portlet. Within this portlet, you can select
any number and types of reports to display on the Start Center,
including detail, ad hoc and reports enabled thru report integrations.
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]
QBE (Query by Example), also known as Data Download, 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 your 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... [More]
the Version 7 product lines, there are numerous ways you can analyze
your data using the Business Intelligence tools. Each analysis mechanism has its own set of unique attributes, and can be used in a variety of situations.
As an IBMer immersed daily in a
sea of acronyms, I've listed these data options for you here with their identifying acronym - - in order of increasing data analysis capability.
– Query By Example. Often referred to as Data Download, this functionality uses your application’s filter... [More]