Can we overwrite the SQL query after creating the report

Questions by selvakumarn

Showing Answers 1 - 20 of 20 Answers

Guest

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

  Was this answer useful?  Yes

anil devireddy

  • 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

  Was this answer useful?  Yes

kkreddy

  • Jan 5th, 2007
 

NO, we can not overwrite the sql query after generating the  repot

  Was this answer useful?  Yes

tryrstyd

  • 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

  Was this answer useful?  Yes

lionskashif

  • Aug 30th, 2012
 

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

  Was this answer useful?  Yes

Sumesh

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

  Was this answer useful?  Yes

chandra

  • Mar 28th, 2014
 

Yes we can override SQL Query if option "Allow other users edit the Query" is enable in the Edit Query Properties.

  Was this answer useful?  Yes

Akhil Rawat

  • Nov 12th, 2014
 

Yes, we can over write the query after creating a report from the universe. There is an option in Desktop Intelligence and Web Intelligence of Business Objects where we can make the changes in the SQL generated from the Universe and just tick mark the option "Do not generate SQL". By doing this the required changes will be saved in the query.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions