cancel
Showing results for 
Search instead for 
Did you mean: 

Last date in report

0 Kudos

Hi All,

I have a requirement where in i need to show the last transaction date that took place at sales org level.

following is my data in the cube
Sales org------plant---------transaction date
S001...........P100...........01.02.2014
S001...........P100...........03.02.2014
S001...........P200...........02.02.2014
S001...........P200...........04.02.2014
S001...........P200............06.02.2014
S001...........P200............08.02.2014
S001...........P300.............03.02.2014
S001...........P300.............04.02.2014

My report should display as below

S001....P100.......03.02.2013
s001....p200.......08.02.2014
s001....p300.......04.02.2014

Actually transaction date is characteristics. So i used formula variable with exception aggregation as last value on 0PLANT. I get X as result.
Any guidance is appreciated

Thanks

Sri

Accepted Solutions (0)

Answers (3)

Answers (3)

anshu_lilhori
Active Contributor
0 Kudos

You can do this by following these ideas:

  1. Convert the transaction date into keyfigure with the help of formula variable with replacement path and make sure to keep transaction date characteristic in rows otherwise it will not work perfectly.
  2. Then you can apply the condition on that date KF with top n =1.

For step by step approach on the same you can refer this blog.

Regards,

AL

former_member976
Active Contributor
0 Kudos

Hi,

you can create the conditions it will show latest record.

please find the below doc, it is smiler your requirement.

Thanks,

Phani.

former_member185132
Active Contributor
0 Kudos

Hi,

You need to do this in the data model level. Query level manipulations won't give you the output you seek.

Regards,

Suhas