on 04-24-2014 10:28 AM
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
You can do this by following these ideas:
For step by step approach on the same you can refer this blog.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You need to do this in the data model level. Query level manipulations won't give you the output you seek.
Regards,
Suhas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.