Skip to Content
0

custom sql parsing

Apr 10 at 04:13 AM

27

avatar image

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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jawahar Konduru Apr 10 at 12:35 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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.

0