Answer / ritesh

If you have to the results give the results in days then
you can use BO function 'DaysBetween' or 'MonthsBetween' if
you want it in months.
If you want to break it down to hours, minutes and seconds
then you can get your answer in this link

http://www.forumtopics.com/busobj/viewtopic.php?t=117814

if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..

1 Answers   TCS,

---

Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

2 Answers   Cap Gemini, Infinity, TCS,

---

what is crosstab reporting,slice and dise and drill mode??

3 Answers  

---

What is shortcut join?could give any one example?

8 Answers  

---

Is it mandatory to give a cardinality ? If cardinality is not given what will happen?

4 Answers   Infotech,

---

what are the roles and responsibilities of BO Administrator ?

1 Answers   OCS Infotech, TCS, Wipro,

---

What is the use of AFD? Where it can be stored?

1 Answers  

---

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  

---

How to hide the table s in webi?can any one tell me plzzzzzzzz

9 Answers   Accenture, TCS,

---

Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?

2 Answers   CSC,

---

what is aggregate navigation?

3 Answers   Countrywide, CTS, HCL,

---

how to do scheduling in desktop intelligence in BO XI R2

3 Answers  

---