Guest
Answered On : Oct 13th, 2006
Yes, we can overwrite the SQL queries.
After overwriting the SQL queries, select the option "Do not generate SQL before running" in SQL Viewer.
Login to rate this answer.
anil devireddy
Answered On : Oct 25th, 2006
Hai u can edit the sql query in the edit query panal...sql button is ther u can click it ..then u can modify that ...then save ..after that run the query...byeanil kumar.d
Login to rate this answer.
kkreddy
Answered On : Jan 5th, 2007
NO, we can not overwrite the sql query after generating the repot
Login to rate this answer.
tryrstyd
Answered On : Aug 19th, 2011
Yes, we can over write the queries in the SQL query option
There are generally two options ion that SQL
SQL and
Custom level
if we want to update it by our own developer then click
custom level option to overwrite SQL automatic generation
Login to rate this answer.
Yes, My Man you can write or overwrite SQL in Webi.
Go to Edit Query and On your left top you will see the SQL Icon. Click on it window will open along with gray out.
If you want to read that OK or if you want to rewrite/do Change then you click on Custom SQL. and then you can start change after finished click on apply/Generate then OK.
Here you go......lionskashif
Login to rate this answer.
Sumesh
Answered On : Apr 25th, 2013
Yes you can overwrite the Query in Webi,but with restriction.
please note that free hand sql in not supported in Webi, all you can do is play around with the Where clause, or change the select condition in such a way that, no of columns in select statement matches the numbers of objects pulled into the query panel of the report.
Login to rate this answer.