CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?

Answer Posted / pbs

yes.We can't create views in Universe.views are stored as SQL.Derived tables are stored as tables.Exection is faster in case of derived tables as it operates on the new table directly ,but views are SQL and executes and operates on the source table and then fetches te records.Advantage of view is any changes in source table will also get reflected in view,but in derived table it is not possible.

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1687


Explain about a time when you discovered a more efficient way to do a work task?

852


What is the functional & architectural differences between business objects and web intelligence reports?

2138


What is a bo repository?

779


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2173


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4144


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

801


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1786


What Is The Difference Between Oltp And Olap?

857


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

1026


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

1813


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

793


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1976


what are the tables used in health care domain project and columns used in report?

4246


How to generate the report from excel sheet?

829