Answer Posted / kiran

Drill By and Drill Across functionalities are same-
drilling by another dimesion or different view(viewing data
from different view of dimention).

Drill Down: is drilling within the same dimension,but with
diffrent levels of it.

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

1106

---

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

1915

---

What is difference between custom hierarchy and report based hierarchy?

1054

---

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)?

1258

---

How to open a universe with out using the Designer ??

7720

---

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

1090

---

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3633

---

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

1397

---

How we drill up week to month?

1110

---

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

1072

---

What is the dense rank?

1315

---

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

2079

---

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

1438

---

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

2400

---

Explain how to schedule the report in b.o?

1118

---