Answer / pradeep mishra

Always View is better than Derived Tabels because it
fetches the Data Directly through the Database So as per
the Performance related it's too good.
But,When we want to use @Function (@variable,@prompt) in
your Query that time it's only possible in Derived
Table,not in the VIEWS.

Answer / 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.

whats the Diffrerence between business objects and cognos?

1 Answers  

---

how can i add two different reports in the same document?

5 Answers   TCS,

---

HOW TO INSTALL BOXI

1 Answers  

---

What is the difference between Boxir2 and Boxir3?

1 Answers  

---

What is broad cast agent?

5 Answers  

---

what is the difference between Ranking and sort-out in bo?

2 Answers   iNautix, TCS,

---

why we use aggregation in lower level

1 Answers   TCS,

---

WHAT KIND OF TOOL BO IS?

7 Answers  

---

Any body help me...what are challenges did u face in Business object project?

1 Answers  

---

Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

2 Answers   Wipro,

---

Which versions are used in the bo dashboard work?

0 Answers  

---

Explain how to schedule the report in b.o?

0 Answers  

---