Special Periods and Variable Offset
Our fiscal year variant includes 12 periods and one special period (Period 13). I created a rolling 12 month query which uses variable offsets to define each column. If the user enters 3/2006, I would expect to see the next columns to show 2/2006, 1/2006, 13/2005, 12/2005....
Instead the query ignores the special period and jumps directly from 1/2006 to 12/2005 - therefore the postings for Period 13, 2005 are not displayed. From what I've found so far this is standard SAP BW functionality, but has anybody had any luck getting around this?