Capturing last PO change date

[sk_kamaruzzaman]

Hi,

I want to capture the PO changes date into my view where as I will consider only one rows with last change date as highlighted below into my graphical calculation view .

Example

     PO -      item -     changedate -      time

     1000     10          20150623           1:00:00

     1000     10          20150623            2:00:00

     1000     10          20150624            1:00:00

is there any option using any calculated column / expression in graphical view without Script view for getting one row.

This report is already running & using by user, just new field addition .

Regards,

Kamruz

[former_member226419]

Hi,

I think you can do with help of graphical view also. take aggregation node and put change_date as aggregated column i.e. Count change_date based on PO, Item and change_date.

For above 2 line items count will be 2 and last line item count = 1.

Filter based on count = 1 and get desired result.

BR

Sumeet

[sk_kamaruzzaman]

Thanks for the reply.

We are using SP09.

I will try & update the same.

Data Set is as below: I want the 3rd row

PO -      item -    changedate -      time  

1000    10          20150623            1:00:00    

1000    10          20150623            2:00:00    

1000    10          20150707            2:00:00   

1000    10          20150624            1:00:00

Regards,

Kamruz

[sk_kamaruzzaman]

Hi,

we didn't get any solution for this. SO we created one new sql script view & joined with the main view able to fetch the last record.

V1 = select the fields ROW_NUMBER() OVER ( PARTITION BY.....DESC ) AS RW FROM...

VAR_OUT = SELECT ......FROM :V1 WHERE RW = 1;

issue solved. closing this thread.

Thanks ,

Kamruz

[Former Member]

Hi kamruz,

If your SAP HANA version is SP9, then you can make use RANK node available in graphical calculation View.

This works as RANK function in SQL.

Define Partition column as PO and order by columns as DATE and TIME with descending order.

Keep the thresh hold value as 1. This will give the desired result.

Regards,

Venkat N.