Maximo List Archive

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.



Re: Tip of the Day #152

From: cbrandon63 (2012-06-14 19:44)

I don't see any report object field within application designer either. Did you figure it out?
--- In MAXIMO@yahoogroups.com, "fowlowt" <fowlowt@...> wrote:
>
> I tried your instructions below, but I don't see any report object field within application designer.
>
> There is a field called Main Object in the top right corner.
>
> Where would I find the report object?
>
> Thanks
> Tim
>
> --- In MAXIMO@yahoogroups.com, "John" <planschd@> wrote:
> >
> > Creating/Extending objects for Adhoc Reporting in Maximo
> >
> > There is often a need in Maximo to add more joins to an existing ADHOC report field selection block. Technically this is called > extending the existing reporting object structures(ROS).
> >
> > This can be done from ¡¥Object Structures¡¦ Module under System Configuration „³ Migration.
> > Ones in this application you can search for the reporting object structures(ROS) by searching with value ¡¥REPORTING¡¦ on ¡¥Consumed By¡¦ column.
> > You can then open an existing object or create a new one from here.
> >
> > In this example we will use: PR connected to PRLINE
> > Create a new structure for PR which is not available OOB and name this REP_PR_CIS.
> > It is necessary that ¡¥Consumed By¡¦ is ¡¥REPORTING¡¦ for the Adhoc Reporting to show this object.
> > In this screen you should create the object structure starting with top Parent, which is PR table.
> > Leave ¡¥Parent Object¡¦ blank and make Object Order = 1 for the first object.
> >
> > Next, associate PRLINE table with the PR. Click New Row and select ¡¥PRLINE¡¦ in the object.
> > Select PR as Parent and select proper relationship for these object from the lookup under Relationship field.
> > In this case, select ¡¥PRLINE¡¦ relationship for this object structure.
> > We can then select Multiple cardinality for this as there can be multiple PRLINES for one PR.
> >
> > Note: you can add other related tables to this object as needed.
> >
> > Once the required structure is built, you attach this new ROS to an application so that it will be available in Adhoc Report.
> > To do this GoTo Application Designer, and select the appropriate application(in this case PR).
> > On the workspace for PR select ¡¥REP_PR_CIS¡¦ in ¡¥Report Object¡¦ field on the top right corner.
> >
> > Now this ROS should be available for adhoc reporting when you click on Create Report button on the Run Reports dialog.
> >
> > w/br
> > john reeve
> > cohesive solutions
> > cell: 423 314 1312
> > http://www.mt-online.com/mtsection/272-mtjune2010/1527-the-business-process-review-redrawing-your-cmms-roadmap.html
> >
>


From: ecirnhoj (2012-06-20 16:07)


I believe pre 7.5x there is a report object field. In 7.5x you designate the application for the object structure in the Application field in the Object Structure application. I'm thinking they did this so more than one reporting object structure can be associated to the application.
John
--- In MAXIMO@yahoogroups.com, "cbrandon63" <cbrandon63@...> wrote:
>
> I don't see any report object field within application designer either. Did you figure it out?
>
>
> --- In MAXIMO@yahoogroups.com, "fowlowt" <fowlowt@> wrote:
> >
> > I tried your instructions below, but I don't see any report object field within application designer.
> >
> > There is a field called Main Object in the top right corner.
> >
> > Where would I find the report object?
> >
> > Thanks
> > Tim
> >
> > --- In MAXIMO@yahoogroups.com, "John" <planschd@> wrote:
> > >
> > > Creating/Extending objects for Adhoc Reporting in Maximo
> > >
> > > There is often a need in Maximo to add more joins to an existing ADHOC report field selection block. Technically this is called > extending the existing reporting object structures(ROS).
> > >
> > > This can be done from ¡¥Object Structures¡¦ Module under System Configuration „³ Migration.
> > > Ones in this application you can search for the reporting object structures(ROS) by searching with value ¡¥REPORTING¡¦ on ¡¥Consumed By¡¦ column.
> > > You can then open an existing object or create a new one from here.
> > >
> > > In this example we will use: PR connected to PRLINE
> > > Create a new structure for PR which is not available OOB and name this REP_PR_CIS.
> > > It is necessary that ¡¥Consumed By¡¦ is ¡¥REPORTING¡¦ for the Adhoc Reporting to show this object.
> > > In this screen you should create the object structure starting with top Parent, which is PR table.
> > > Leave ¡¥Parent Object¡¦ blank and make Object Order = 1 for the first object.
> > >
> > > Next, associate PRLINE table with the PR. Click New Row and select ¡¥PRLINE¡¦ in the object.
> > > Select PR as Parent and select proper relationship for these object from the lookup under Relationship field.
> > > In this case, select ¡¥PRLINE¡¦ relationship for this object structure.
> > > We can then select Multiple cardinality for this as there can be multiple PRLINES for one PR.
> > >
> > > Note: you can add other related tables to this object as needed.
> > >
> > > Once the required structure is built, you attach this new ROS to an application so that it will be available in Adhoc Report.
> > > To do this GoTo Application Designer, and select the appropriate application(in this case PR).
> > > On the workspace for PR select ¡¥REP_PR_CIS¡¦ in ¡¥Report Object¡¦ field on the top right corner.
> > >
> > > Now this ROS should be available for adhoc reporting when you click on Create Report button on the Run Reports dialog.
> > >
> > > w/br
> > > john reeve
> > > cohesive solutions
> > > cell: 423 314 1312
> > > http://www.mt-online.com/mtsection/272-mtjune2010/1527-the-business-process-review-redrawing-your-cmms-roadmap.html
> > >
> >
>