IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

Answer Posted / sahil

Although view is faster than derived table, but if we want
to filter out the data from select query of derived table
then we can use @prompt in derived table. but it cant be
done in views.

Is This Answer Correct ?    11 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1126


8. How much supervision have you typically received in your previous job?

2003


Explain what is the difference between business requirement document and use case document.

757


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1726


What is the difference between slice and dice and cross tab report?

812


What is package in BO

2905


How were the reports scheduled and how to resolve unexecuted documents?

2421


what is document design in boxi,have u participate in that

1831


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3311


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

802


How we drill up week to month?

803


Difference between b.o 5.1 and 6.1b?

868


Explain the difference between union and group?

818


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3192


Explain the difference between detect alias and detect context?

799