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
What is the difference between condition & filter?
what are the day to day activities of BO administrator ?
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?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain is there any other repository domains rather than universe, security, document?
Can we Save (save as) WEBI Doc as DESKI?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What would you consider as your biggest achievement and why?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
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
Explain what task is 98% of the required work of a business analyst?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is object stores?
What is the profile and package?
any difficulitis have you phase while creating bo reports and how did u solve it