custom sql parsing

[Former Member]

i have a question on custom sql parsing in webi reports. i have a sql which is around 200 lines and is embedded in a webi report. so whenever the report is called how and where will the sql parsing happen ? will the sql parse at the webi report or it will sent to db for parsing and the results are sent back ?

[former_member185603]

SQL parsing happens at DB using the relational connection to DB.

[Former Member]

so you mean to say that the 200 lines of custom query will be sent to db for parsing and then the result is sent back to webi ? if that is the case then if i create a view in the db and call the view as a custom sql from webi the performance of my webi report will improve ?

please answer both questions

[former_member185603]

Business objects uses the DB connection to send the query to DB and results will be send back to Business Objects WEBi to display the results.

Regarding the performance, it will be the same if you call the view or using the SQL in WEBI report. Not much difference.