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:)
Answers were Sorted based on User's Feedback
Answer / rajitha praburam
You can get the required results by using RANK function.
Create an object 'Rank' with Number Data type and the below
select option.
RANK() OVER (PARTITION BY CUST_NAME ORDER BY
PAYMENT_DUE_DATE DESC)
In the report, use report level filter add Rank = 1
condition.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rahul
You can achieve this by having a condition.
i.e put payment_date in condition panel-->select operator
as "equal to"-->operand "calculation"-->follow the
steps"select object(payement_date)"-->select function
(maximum)-->Globally-->for each value of one or more objects
(cust name)--finish
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gs2kumar@gmail.com
Max(Payment_due_date) use this in report level create a variable or in cell.
Is This Answer Correct ? | 0 Yes | 0 No |
what is the diff between etl tool and olap tool
what r the advantages of creating the universe?
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?
what is profile and packages in BOXI??
hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks
Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.
When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?
what is the source for metrics?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is the difference between the Webintelligence and desktopintelligence?
Please Send to my e-mail Interview Questions With Answers , Technical Test Questions With Answers and Code Snippets Of Business Objects - Dev , Business Objects - Reporting Analysis .