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
- 7085 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 |
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
When to use local filter and when to use global filter?
What sort of existing documents should business analysts refer to when starting on a new project?
without creating the business view is there possible to create & generate the Crystal reports?
How to get two dimension objects in a same block which are comming from two different contexts ?
What is the profile and package?
Approximatly how many enduser can use the each bo project?
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
Tell me about linked universe ?
What are the Input and Output Context Operators.
can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?
I have only 1 dataprovider and using that i have to create 2 tabular report on Webi on same page. One report will display all the salary details and other report will display only max salary. How will you achieve this.
Teradata 
