I am new and this is my first post so forgive me if I am putting it in wrong place or if there is solution for it already but I couldn’t find any yet.
I need to list all BO Webi reports names and the SQL code use in the query of them to find those reports which uses tables from wrong data base schema.
I know that I can open manually each report and click on view SQL in edit query but it is not really possible for few thousand reports to check.
I tried already query builder and I was able to find universes and reports related to it but I cannot find sql code to check the actual tables used from the universe in relevant reports.
In the repository server the data are encrypted so I am not sure what I can find there. There is legend somewhere on web which help to decode it but it not contains Turkish letters…
I just saw a post (in the SDK forum) where a poster had done this - I’d dig in that forum… You’re into opening each report with the SDK, then getting the sql from each dataprovider - no small feat.
Yes you are right the solution for now is to open each report in Bo Info view to check SQL in edit query. No fun at all…
We don’t have access to SDK as I presume it is extra charge?
It’s basically free - you can write code against the BO libraries with ASP, JSP, Java, and VBS - I have done stuff in Excel, based on code here. Login, query documents, open, get dp, repeat - the individual pieces are mostly all done on the SDK forum for you.
Documentation is on the SAP site, and you can get great examples here and by looking at the BO web pages.
This would not be horrible - if the shutdown drags on much longer, I’ll have time to mess with stuff like this >: /
Guys thank you for helping out it seams to have data needed for me
I need now to works with performence of retriving that data as the audit tabe is quite huge.
Thanks and all best.
(BOB member since 2002-08-29)
(BOB member since 2008-10-09)