CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
- 2 Answers
- 7382 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 |
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
how will you move the universe/report from development to production?
How many universes can be created in a project?
What is the short cut join?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
how many times can use the union operator in a report?
Why do we need metrics and sets?
What is metrics?
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?
Hi ,how many shortcut joins used in a single universe? Thanks in Advance
5.what is slowly changing dimension ?
Teradata 
