This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Brand new to Maximo!
Company has had the product for a few years now, only ever using canned reports. Management has decided to use through company and wants to expand on reporting.
Just learned it uses BIRT, starting to learn that now, we have an ODBC connection setup and working with Crystal Reports 2008 (v12).
I need help finding fields that the end user group is using to build reports for them. I have a database schema guide however it does not help me determine where to start.
I have been asked to collect data on the hours spent by building and the cost associated.
Any guidance on what tables to use or where to start would expedite my time attempting to navigate.
Thank you in advance.
Log onto the front end of Maximo. Go to the application that they want you to report on. Bring up any record.
Select a field and click on Alt and F1 at the same time. That will give you the field name (table name or relationship name followed by the field name).
This should allow you to find the main tables and fields that they want as if they cannot enter the values into the fields via an application they cannot expect to report on it. (Although there are exceptions to this, as some data might get loaded via sql or MIF and is not displayed.)
Als, there used to be a link to the erd for Maximo 6 (an maybe 7) on the yahoo groups site. I do not know its exact location and am not in a position to search for it right now. You should also have this in the documentation in the downloads (zip files) or CDs that you received from IBM. I have some on external drives also, but do not have them with me. Maybe someone else can post the link.
Pat Morrow
pmorrow8@yahoo.com
________________________________
From: id07192008 <dsampson@stlouisco.com>
To: MAXIMO@yahoogroups.com
Sent: Monday, March 19, 2012 1:42 PM
Subject: [MAXIMO List] Database Setup/Finding Tables & Fields
Brand new to Maximo!
Company has had the product for a few years now, only ever using canned reports. Management has decided to use through company and wants to expand on reporting.
Just learned it uses BIRT, starting to learn that now, we have an ODBC connection setup and working with Crystal Reports 2008 (v12).
I need help finding fields that the end user group is using to build reports for them. I have a database schema guide however it does not help me determine where to start.
I have been asked to collect data on the hours spent by building and the cost associated.
Any guidance on what tables to use or where to start would expedite my time attempting to navigate.
Thank you in advance.
As mentionsed before, use alt-F1 on any field for table and field. It is great and can help your ODBC reporting.
Work with somebody to set up the information objects within Maximo reporting. These are that base objects to make and save ad hoc reports right in Maximo. If these are set up well, report writing will be a joy for everyone. If they are slapped together, they are more than useless and will turn user against Maximo.
--- In MAXIMO@yahoogroups.com, "id07192008" <dsampson@...> wrote:
>
> Brand new to Maximo!
>
> Company has had the product for a few years now, only ever using canned reports. Management has decided to use through company and wants to expand on reporting.
>
> Just learned it uses BIRT, starting to learn that now, we have an ODBC connection setup and working with Crystal Reports 2008 (v12).
>
> I need help finding fields that the end user group is using to build reports for them. I have a database schema guide however it does not help me determine where to start.
>
> I have been asked to collect data on the hours spent by building and the cost associated.
>
> Any guidance on what tables to use or where to start would expedite my time attempting to navigate.
>
> Thank you in advance.
>