Explain the difference between union and group?
No Answer is Posted For this Question
Be the First to Post Answer
it is possible to link two universes of separate functional domain ?
what are the day to day activities of BO administrator ?
Hi, How to navigate one report to another report in webi? Thanks in Advance
What is object stores?
. User wants to modify a report and wants to add additional data. How will you approach.
What is the difference between user and versatile user?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
what is document design in boxi,have u participate in that
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what is the difference between business requirement document and use case document.
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:)
Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....