hello,
Is there any possibility to access the standard report queries through crystal report or MII so by modifing them we can built custom reports easily.
Regards,
Pushkar
Hi,
We are looking those too. So if possible share those.
Br,
Pete
Pushkar,
I doubt you can do that because there should be some collaboration mechanism between ME and e.g. MII to maintain data transfer to external system where you want to see the report. But I do not see any of such implemented in ME for standard reports. What you can do is just to replicate the behavior of each ME report by means of external tool but retrieve the data directly from ME WIP/ODS tables, without calling ME at all.
Regards,
Sergiy
Hi,
Are the queries available somewhere? Some of the reports are using quite complex queries I think. It would save a lot of time if we could get the queries and then we can use those as a base when making custom reports with BusinessObjects.
Br,
Pete
If you are looking for SQLs, you can capture them by enabling SQL trace in ME.
Konstantin
Petri,
Please note that in addition to SQL queries some reports have calculation implemented within their JSPs.
Regards,
Sergiy