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:





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


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


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