Extract SQLs used in a webi reports

building reports webintelligence
1

Hi,

We have 350 webi reports in our Production. We did some test and changed sql in UAT enviroment for the same 350 reports. Now I need to compare the SQL of PROD and UAT for all the reports.

At present, we are using a java script which extract the SQls of all the report when provided in a particular format. I,e providing report ids as input,getting sqls as output.

Is there a way we can do the same in Business Objects XIR3.1.

Can we get the SQLs of all the 350 reports at one go?

D.bhat (BOB member since 2010-06-04)

2

Have a look at this WID scanner

.

haider :es: (BOB member since 2005-07-18)

3

THanks,
Above document provided following information from CMS

Author
Filename
Path
Description
Keywords
Folder
Foldertype
Instance Yes/No
Universes used
Objects and Predefined Conditions used**

However I need to know the SQL of the webi reports. Please help if you have any information.

D.bhat (BOB member since 2010-06-04)

4

It was just a pointer for a headstart.
You need to do further search in the thread I gave or in the BOB downloads area

.

haider :es: (BOB member since 2005-07-18)

5

Alright… Thanks for the information.
I would check and update the theread in case I

find anything

D.bhat (BOB member since 2010-06-04)

6

Well, I guess from the lack of update to this thread, that you didn’t find anyting.

I am having the same issue myself.

I am trying to find a way, to extract/dump the WebI generated SQL in some flat files, using BOXir3.1 SP5.

Any ideas?

Verakso :denmark: (BOB member since 2011-06-29)