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
- 7192 Views
- I also Faced
- E-Mail Answers
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 |
Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.
wat is difference b/w break and section?
what is universe
CAN A REPOSITORY CONTAINS REPORTS?
Can We customize the Business Object infoview in BO?
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
What is meant by multiple data provider.How to use it in universe as well as reporting environment?
HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?
What are the Users and Usergroups?
What is mean by stored procedure ? and how we can generate stored procedure universe?
what is difference between global filter an query filter in web intelligence?
what is a Micro cube?
Teradata 
