GeekInterview.com
Series: Subject: Topic:
Question: 178 of 275

Can we overwrite the SQL query after creating the report

Asked by: selvakumarn | Member Since Jun-2006 | Asked on: Oct 12th, 2006

View all questions by selvakumarn

Showing Answers 1 - 6 of 6 Answers
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.
lionskashif

Answered On : Aug 30th, 2012

View all answers by lionskashif

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.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.