Dec 2, 2009 · Try to see in the Config pane, select BusinessObjects application and enable “Edit Query SQL” under “Query Technique”. Another way is to use the report function DataProviderSQL (…) which will give you a very long string containing the SQL, this can be placed within a cell on a report (e.g. on a separate report tab in the document). Hi,

With QuerySurge BI Tester for SAP Business Objects WebIntelligence, data testers can use familiar SQL syntax to retrieve query data from WebIntelligence reports and validate it against any QuerySurge-supported Source or Target.

Web Intelligence allows you to view and edit the SQL generated by a query, and even copy and paste it to another application. From the homepage, navigate to a report folder and choose a report to modify. In the report toolbar, from the Query section, select edit.

When you build a query, Web Intelligence automatically generates appropriate script (such as SQL) to retrieve the data from the relevant database. You can view and edit this SQL, and copy it to another application if you have the rights to do so.

Jun 17, 2013 · Query Builder is one of the essential and interesting tools in BusinessObjects. Using Query builder one can easily query the BusinessObjects repository and get the required information which cannot be found even in CMC.

To help you phrase your business question correctly, the query uses elements called objects that contain pre-defined data. In your company, the data are stored in databases to which you go to find specific and meaningful information

Jul 22, 2015 · I'll assume that you're using BusinessObject BI4 and Web Intelligence. You will need the following rights to view the SQL statement (assuming that the source is a relational database): Application Right, Web Intelligence: Query script - enable viewing (SQL , MDX...)

Mar 22, 2004 · I generally use Crystal, so I'm new to Business Objects. Can somebody point out to me how to see the actual SQL code used by a BO report? In Crystal is is data , show SQL query .

The studio enables you to execute queries for SAP business objects and custom business objects to help you better understand the business object data model. For custom business objects, you can execute the QueryByElements query, which is …

Jun 25, 2018 · You can get summary information about universes, including their objects but not SQL, by using the Semantic Layer REST API. To get all of universe objects' info, including SQL, you will need to use another SDK.