Answer / padmalatha0923

we can create objects using derived tables
if derived tables increses then only performance decreses
but if we include one object form this table the entire query from this table is executed.we can see this in query panel

Answer / gowthami

In some scenario’s we cannot meet the requirement. In that case using derived table we can create own query with needed objects and can write the formula to achieve the requirement which cannot be done in general.
If there is no other way to achieve the requirement only the derived table can do. We can go for derived table. But it will decrease the performance of universe (more no of derived tables)

Answer / raj

Use only when you need complex joins and calculations between tables in the BO universe then go with Derived table.To Update / Change the derived table structure in the universe is very easy

what is fantrap and chasmtrap ?

5 Answers   Tech Mahindra,

---

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

1 Answers   Emphasis,

---

bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?

7 Answers   PCS, TCS,

---

what r the universe connection types?

4 Answers  

---

1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

3 Answers   Hexaware,

---

---

Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?

6 Answers  

---

what is universe null

0 Answers   TCS,

---

How many universe dfi you create if you have 2 years of experience in BO

6 Answers   IBM,

---

What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?

1 Answers   NSE,

---

WHAT DOES SQL TAB CONTAIN?

1 Answers   Polaris,

---

Example of how the fantraps and chasm traps works?

1 Answers   IBM,

---

every reports have docid,when i export a report docid will change or not?

4 Answers   Zensar,

---