Answer Posted / subramanyam

Derived table is nothing but logical table like view.it
doesn't carry out any data in the database.It is the
function in the designer. You can use the view as the table
in the universe design and you can create the class objects
and conditions based on that derived table.

What we need to discuss with designer before starting the universe designing.

2231

---

Is there any other repository domains rather than universe, security, document?

1039

---

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

990

---

How would you format some text using css to be verdana and bold?

1059

---

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

965

---

What three things do you consider to be the most important factors for a manager?

1067

---

What is the difference between slice and dice and cross tab report?

1029

---

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1010

---

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2210

---

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3055

---

Explain in detail about type 1?

1576

---

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1002

---

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2306

---

Can we configure two instances of CMS pointing to two different CMS system databases?

2007

---

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1152

---