Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Characteristic restriction with another characteristic

Hello and good day to you guys, I have a quite uneasy problem and need your wise help on this.

I need to restrict a characteristic with a date so I can get to display the last value of that characteristic only even when the original selection involves several dates

Here are my facts:

I'm reporting on an ODS level and in the ODS I have:

Project__Month__Amount__Status

PR1______01_____100_____A

PR1______02_____150_____B

PR1______03_____600_____C

Now in the query I have a selection variable for the date (on month = 03 in the example) and I need to show:

Proyect__month__Amt.__Amt.previous month__Status

PR1_____03_____600___150_________________C

As you see I am displaying the amount for the selected month, the amount for the previous month and the status of the selected month as well.

I have a variable for selecting the wanted month and then via an offset I actually do the select on the selected month + the previous month-1, so then by restricting the KF amount I get the current and the previous amount but I'm not able (because of the initial selection of the 2 months) to display the last status ( as I canot restrict the characteristic by another (month) characteristic so I end up getting 2 lines displayed with the diferent status B and C and I need just C.

Any ideas on how to achieve that ?

Thank you very much

Herny

Former Member
Not what you were looking for? View more on this topic or Ask a question