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 would you consider as your biggest achievement and why?
How would you format some text using css to be verdana and bold?
Explain the data types present in bo and what happens if we implement view in the designer and report?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
In banking domain how many Fact tables,Dimension table are present?
how to create metric universe ?
Explain about a tricky situation for which you found a very simple solution?
Explain what are the steps to do to use alerts in bo?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain in detail about type 2(scd),
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
explain in detail about type 3?