Answer Posted / gs2kumar@gmail.com

Assume fact tables as F1, F2 and dimensions are D1, D2.

D1--<F1>--D2--<F2>--D1 like this we can connect, here loop and traps also will occurs. To resolve we can use context.

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?

970

---

What is the difference between business requirement document and use case document.

959

---

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?

3518

---

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4673

---

in sap bi we have wad, then why we go for sap bo

3326

---

Explain what are the steps to be taken to schedule the report?

1044

---

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

1971

---

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

948

---

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

977

---

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2099

---

Explain about a task that really tested your analytical abilities?

1190

---

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

998

---

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

1304

---

Can we create universe with no cache??

2443

---

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

942

---