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.

What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?

2 Answers   CTS,

---

HOW TO PUBLISH A REPORT IN BO?

1 Answers   Polaris,

---

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

0 Answers  

---

HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?

5 Answers   HCL,

---

Difference between Object varification and validation

1 Answers   Cognizant,

---

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

---

How do u get requirement from the client? in what format?

1 Answers   TCS, Wipro,

---

There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance

1 Answers  

---

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,

---

Hi any done business objects certification.i am expecting some help from them.

6 Answers  

---

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

0 Answers  

---

When to use local filter and when to use global filter?

0 Answers  

---