I need to select the rows based on the latest 'Payment_due

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:)

Question Posted / mysticbo

3 Answers
6937 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I need to select the rows based on the latest 'Payment_due_date' column value. Let'..

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

I need to select the rows based on the latest 'Payment_due_date' column value. Let'..

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

I need to select the rows based on the latest 'Payment_due_date' column value. Let'..

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

Post New Answer

More Business Objects Interview Questions

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

4 Answers KPIT, TCS,

how to test reports in businessobjects?

8 Answers TCS,

Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers IBM,

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.

3 Answers

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers

how we improve the performance of report and universe?

4 Answers Accenture, IBM,

GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?

4 Answers

Can we do the slice and dice in webintellegence?

5 Answers IBM,

Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

2 Answers HCL,

Can we link the Universes from two different sourcess?Explain?

2 Answers IBM, Oracle,

can anybody tell me how many classes where there and objects in each class

3 Answers

what is master-detail report

3 Answers Patni, TCS,

For more Business Objects Interview Questions Click Here