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.

How we drill up week to month?

1048

---

Can more than 1 metric be applied on an analytic in business objects?

2140

---

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

1332

---

Give some information on report bursting?

977

---

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1022

---

any difficulitis have you phase while creating bo reports and how did u solve it

3432

---

What is the profile and package?

2278

---

Explain how to schedule the report in b.o?

1033

---

What is report template in b.o?

997

---

What is aggregate table and aggregate fact table ... Any examples of both?

1049

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1815

---

Explain how we drill up week to month?

1076

---

What is the dense rank?

1199

---

What is the difference in creating filters in designer and business objects?

1010

---

Explain is there any default username & pwd for bo designer & supervisor?

988

---