we have a field in our cube that determines if a sales order position is closed in ERP system and will not be changed anymore (KPOSSTAT = 'X').
In the cube this might look like :
What I want to do now, is to archive all sales order position records that are older than 01.01.2014 and where the position has been closed at some point in time before 01.01.2014, so basically all records for position 100. If I use KPOSSTAT = X and CALYEAR <= 2014 in my archiving process selection profile I'm going to archive only the third record for position 100. If I'm selecting only for CALYEAR <= 2014 I'm also going to archive position 200 which is not wanted.
Is this way of archiving possible at all?
Help would be appreciated.