Ranking on a date prior to switchover
I have a number of versions in my model with different switchover date.
I also have ranking function on the last date prior to Switchover. For instance, I set the swithcover to Aug 17 then I need ranking to be ran in July; If swithover = Sep17 then ranking on Aug17 etc.
For specific period it is easily done by using SELECT (ex.SELECT: TIME.'Aug 17'), but i couldnt figure it out for dynamically system.
Hopefully, you might suggest something.