Answer / host

for each-add all objects to the contex
for all-delete all objects from the context
we use forall for summary purpose and foreach for
detail purpose

Answer / narsi

forall : -- while using measure objects will inserted(o/p
context)
foreach:- while using diamension object will inserted (I/p
context)

these above 2 conditions are using in calculation context.

= sum(<revenue> foreach(<year>,<city>)) forall(<year>)

How do u Receive requiremnts from the client?

3 Answers  

---

without creating the business view is there possible to create & generate the Crystal reports?

3 Answers   TCS,

---

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 the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

2 Answers   HCL, IBM,

---

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

0 Answers  

---

---

Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

0 Answers  

---

Explain how to schedule the report in b.o?

0 Answers  

---

1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

2 Answers   TCS,

---

How to create Universe using Flat file in BO6.0

1 Answers  

---

What is the difference between the Bo 3.0 and 3.1?

1 Answers  

---

How maually can i define ? If thousends of records exists in a table?

1 Answers   Infotech,

---

Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva

1 Answers  

---