Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between derived table and views?
which one gives better performance?
- 2 Answers
- 24799 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / prasanna.ramesh1
a derived table is dynamic,virtual table that you create
within universe structure.it consists of set of sql
statements that you create in designer and you can use it as
a logical table to create objects.
in the derived table sql set,you can put a select statement
in place of table name in the from clause.sql set can also
contain embeded prompts and you can create joins between
embeded physical tables ,just as you can with other tables.
derived tables can be used in place of database
views,aggregate tables,lookup tables.
by using derived table we are processing load from the
report server to the database.
views are also virtual tables which are created in database
level and can make use in universe.but we can not create
them in universe structure.
| Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
How to schedule the report in b.o?
Differences between business objects and web intelligence reports?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain when to use local filter and when to use global filter?
What is the difference between slice and dice and cross tab report?
What are the join problems comes appart from loop,chasm & fan Traps
Explain the data types present in bo and what happens if we implement view in the designer and report?
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 what is the difference between slice and dice and cross tab report?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
How can you first report in Business Objects by using broadcast agent?
how get the grand total in master-detail report?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
