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
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
How to restrict password to a user while sending a document in .pdf format
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
How would you format some text using css to be verdana and bold?
Differences between business objects and web intelligence reports?
Explain what is the difference between business requirement document and use case document.
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
What is package in BO
What is a bo repository?
can anybody tell me about complicated object you have created
how get the grand total in master-detail report?
What are all difference between business objects 6.5 and xi r2?
How to open a universe with out using the Designer ??
Explain is there any default username & pwd for bo designer & supervisor?
