Answer Posted / sourabh

For performance of universe
1. One should never make alias of Fact tables, that
make universe very slow.
2. More number of contexts should be used rather than
creating aliases of tables.
3. Measure function must have projection function set
to Database delegated.

For report performance
1. It is better to make SQL Queries rather then using
sub reports in report.
2. Drill down Dimensions being used on report should
have hierarchy defined.
3. Create index awareness in objects.

Explain about a task that really tested your analytical abilities?

1256

---

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

2171

---

What is package in BO

3204

---

what is the difference b/w the refresh and buffered data?

2347

---

How to restrict password to a user while sending a document in .pdf format

2349

---

What are the steps to do to use alerts in bo?

1399

---

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

1001

---

Which command using Query Analyzer will give you the version of SQL server and operating system ?

5079

---

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

3459

---

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

1030

---

1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6883

---

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

1013

---

Explain what sort of existing documents should business analysts refer to when starting on a new project?

1010

---

What is the dense rank?

1235

---

In banking domain how many Fact tables,Dimension table are present?

8805

---