Last X period filter is not working properly. How can I rectify it?
Verify and alter the LASTX WEEKS,LASTX MONTHS,LASTX QUARTERS & LASTXDAYS queries in the 'admin_oracle_warehouse.xml' accordingly to rectify the problem. For example: wdifT = (eWeekNoTY - sWeekNoTY) + 1. Where: sWeekNoTY = ("WEEK_NUMBER_THIS_YEAR")); eWeekNoTY = ("END_WEEK_NUMBER_THIS_YEAR")); As per the LASTXWEEKS query defined in the 'admin_oracle_warehouse.xml', the eweekNo is a lesser number (for e.g. 7) and the sWeekNo is a greater number (for e.g. 14). Therefore, the result generated will be a negative value. So making required changes in the queries should fix the issue.