Answer Posted / nathan

By having multiple contexts you can utilize the 'multipass'
sql feature. Multipass: Breaking one large SQL into
multiple SQLs.If you are using the star schema with two or
more fact tables,and you enable this feature, BO will
automatically generate two or more SQLs (i.e. one SQL for
each fact table object used in the report). Then the
results will be synchronised in the report. For more on
multipass concept please refer to Ralph Kimball's Lifecycle
toolkit (not modelling)book.

Explain in detail about type 2(scd),

1101

---

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

8801

---

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?

1020

---

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

1061

---

how get the grand total in master-detail report?

2236

---

Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

4321

---

webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4407

---

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1266

---

what is universe null

2424

---

What is the functional & architectural differences between business objects and web intelligence reports?

2412

---

What is Indexing? how did u implement indexing?

2475

---

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

1039

---

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

1050

---

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

2031

---

What is a bo repository?

1045

---