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

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1582


WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

1691


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3289


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

818


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1432






Did you face any problems while creating reports? Name? Solutions?

3260


What sort of existing documents should business analysts refer to when starting on a new project?

624


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

2221


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

607


Explain in detail about type 2(scd),

596


Can Bo generates the Report from the cubical data Explain?

1628


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1910


Explain what are the steps to do to use alerts in bo?

615


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

602


Give some information on report bursting?

571