I need to view my "BO report SQL" in database rather from web through edit query. How can I achieve this? Please help me out and provide me the steps.
It may be in BO repositry OR
views:
118answers:
1
A:
Assuming you're using SQL Server (most if not all DBMS platforms have similar facilities) you can use the profiler tool and run a trace that captures the SQL. Interesting events to capture are 'SQL Statement Complete' and 'Showplan XML' (if you want to see the query plan).
You will get a lot of irrelevent rubbish in the traces, so you may wish to filter the trace. To do this you can add a clause 'Application Name=foo' to the connection string used by the Business Objects server, and use that to filter the trace on the 'ApplicationName' column.
ConcernedOfTunbridgeWells
2010-03-13 09:14:45
Hey Sorry if i have confused. My aim is to view the BO report SQL in the data base that we use. For e.g. oracle databases. I knew that i can view the report SQL thru BO webi (thru EDIT SQL) but its difficult for me to check for lots of reports. Reason i'm looking for this is, Whenever there is a universe change there is a chance for a change to report though there no impact. In this case i need to verify all the report SQL and make a document for each release. If i'm able to get the report SQL of a BO from database it will me more easier to acheive my process.
vivek
2010-03-15 05:26:29
I don't know if BO documents the data model on its repository. You might want to check the docs and find out if there is any documentation for the repository. IIRC the repository also has an API that you can use to query this sort of metadata from it.
ConcernedOfTunbridgeWells
2010-03-15 08:29:58