Time filter for Week shows future weeks. Why?
Following Queries are referred by the Application. Please verify and change as per the requirement. File : warehouse.xml Path-(Tomcat\webapps\MA\config) MAINMENU4 SELECT MAX(DATE_KEY) FROM DIM_DATE WHERE WEEK_NUMBER_THIS_YEAR = (select Week_number_this_year from DIM_DATE where date_fld =?) AND YEAR = (select year from DIM_DATE where date_fld = ?) WITH UR WWCAL6 WWCAL8 WWCAL25