Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6936 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Did you face any problems while creating reports? Name? Solutions?
Can we configure two instances of CMS pointing to two different CMS system databases?
What is the profile and package?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
How many universes can be created in a project?
What are the steps to do to use alerts in bo?
U r project in which stage in implementation?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain about alerts in bos, under what situation we need to use alerts?
What is a fantrap in business objects?
