CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
Answers were Sorted based on User's Feedback
Answer / ramesh
No.We cannot create view in BO universe.view is similar to derived table in BO where we can create our customised columns involved complex calclutions from already existing tables and columns and make the joins to normal tables and we can create objects and classes for any other table in universe structure pane.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / 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 |
you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1
Tell me the difference between cmc and cms?
Explain how to schedule the report in b.o?
tell me about aggregate awareness in detail?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
How would I achieve Traffic Lighting in Business Objects
could you please give me the diagram of BO 6.5 Architecture or explain about the tires?
What is the difference between absolute and relative div positioning?
How do you restrict access to rows of a database?
Can anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?