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.
We currently have a scheduled job in Actuate running the asset cost rollup nightly. The performance of the report leaves something to be desired. Has anyone customized/modified the asset cost rollup report in a 6.x environment for performance improvments? Are there any alternatives like a PL/SQL proc.?
I would like to know how others handle updating the asset Total and YTD costs.
Thanks in Advance,
Todd
Well I didn't hear back from anyone, but I have made some progress with the Select Statement in the Actuate Report.
The Original Report has something like this...
(
select 1 from labtrans
where labtrans.assetnum=asset.assetnum
and labtrans.genapprservreceipt = 1
and labtrans.siteid=:mroSite and labtrans.rollup = 0
)
Well if you add the following line right after rollup = 0 you get a significant performance improvement. You have to edit the tables for each of the first 4 exists.
and exists( select 1 from asset where asset.siteid = :mroSite and asset.assetnum = labtrans.assetnum)
I'm still having trouble improving the ASSETHIERARCHEY section of the code... if you can help here I would appreciate it.
(
select 1 from servrectrans,assethierarchy
where servrectrans.rollup=0
and servrectrans.refwo=assethierarchy.wonum and servrectrans.siteid=assethierarchy.siteid
and servrectrans.assetnum is not null and assethierarchy.parent=ASSET.ASSETNUM and servrectrans.siteid=:mroSite
)
Thanks in Advance Everyone!
Todd
--- In MAXIMO@yahoogroups.com, "foundationboarder187" <todd.bellamy@...> wrote:
>
> We currently have a scheduled job in Actuate running the asset cost rollup nightly. The performance of the report leaves something to be desired. Has anyone customized/modified the asset cost rollup report in a 6.x environment for performance improvments? Are there any alternatives like a PL/SQL proc.?
>
> I would like to know how others handle updating the asset Total and YTD costs.
>
> Thanks in Advance,
>
> Todd
>