You can get the required results by using RANK function. Create an obje

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 / rajitha praburam

3 Answers
7036 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

Please Help Members By Posting Answers For Below Questions

any difficulitis have you phase while creating bo reports and how did u solve it

3432

What is top business?

1049

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2014

What is thumbnail?

957

When we use aggregate awareness function in designer?

956

What is a fantrap in business objects?

1161

How to restrict password to a user while sending a document in .pdf format

2329

What is a bo repository?

1034

is it possible to export the webi reports to crystal reports?with out using businessview?

2269

Can more than 1 metric be applied on an analytic in business objects?

2141

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1098

Is there any other repository domains rather than universe, security, document?

1039

Explain is there any default username & pwd for bo designer & supervisor?

990

What Is The Difference Between Oltp And Olap?

1102

Differences between business objects and web intelligence reports?

1196