Answer Posted / mayur
hi,
see i would like to answer it through on example:
consider the case where u retrive the data from the table xyz
by writing the "SELECT STATEMENT" & get the output ( say 5 rows) now their is the condition ....where u need this output(5 rows) for report/query..etc..
now, in such condition you can create an object of the above statement i.e "Select Statement" and store it in Derived table
& hence next time u will not require to write sql again...
& even a complex sql is effectively implemented...
finally this will enhance ur performance & a effective development logics ....
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Explain is there any default username & pwd for bo designer & supervisor?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What is Indexing? how did u implement indexing?
Explain what is the difference between slice and dice and cross tab report?
What is the difference between condition & filter?
Explain about a task that really tested your analytical abilities?
What is object stores?
What are all difference between business objects 6.5 and xi r2?
Explain what three things do you consider to be the most important factors for a manager?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Give some information on report bursting?
how get the grand total in master-detail report?
What are the data types present in bo? What happens if we implement view in the designer and report?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?