Answer / 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.

Answer / rekha

Because it will be bit confusing for the users to select
which context to use if they don't have the knowledge of
how BO works

what is canned universe and canned reports in bo?

1 Answers  

---

HOw do u migrate from old version to the new version?

1 Answers   AOL,

---

What is shortcut join?could give any one example?

8 Answers  

---

what is the difference between Ranking and sort-out in bo?

2 Answers   iNautix, TCS,

---

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers   Polaris,

---

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  

---

What is thumbnail?

0 Answers  

---

While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.

0 Answers   Emphasis,

---

how to coneect to a server in a business objects

1 Answers  

---

How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible

2 Answers  

---

can u create report to connect oracle and sqlserver at a time?

2 Answers   Zensar,

---

What is drill across ? can anybody explain me in detail?

1 Answers  

---