Interested to Buy Any Domain ? << Click Here >> for more details...
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
- 2 Answers
- 8026 Views
- I also Faced
- E-Mail Answers
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 |
Difference between b.o 5.1 and 6.1b?
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?
why do we use crystal reports rather than webintelligence reports ?
When we can use multiple sql statement for each measure? and multiple sql statement for each context?
HI, can anybody explain me how performence will decrease if we create objects using derived tables ?
WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?
Can anybody explain me ? without creating the alias can we resolve the fantrap?
What is the Difference b/w Server based Ranking and normal Ranking?
What are the different types of Filters available in BUSINESS OBJECTS?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
What are the security level used in BO?
Teradata 
