Skip to Content
avatar image
Former Member

custom sql parsing

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 10 at 12:35 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.