How to restrict the number of weeks displayed in the Week range filter?

• Related Articles

• 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 ...

• How to increase the number of weeks visible in 'Weekly' TIME filter?

  You can configure the number of weeks to appear in the 'weekly/week range' filter. This option is available under: Administrator -->Configuration-->ARC Parameters -->Analytical Configuration. Once you have made changes, re-cache changes for the ...

• How do I increase the number of Weeks appearing in the Weekly TIME filter?

  If a user intends to view previous week's data, then the following property needs to be increased in "arc.properties" file. For example, week Range =14 and if you increase one number then you are able to see one additional week previous to the one ...

• Why is the order improper, while using the Month Range option? For example, I selected Nov 2010-Jan 2011. Week 1 of Jan 2011 got displayed first.

  Modify the 'OrderBy' column in the crosstab area of the KPI as 'DATE_KEY - Ascending' to get the month range in the ascending format. After doing the changes, if you select Nov 2010-Jan 2011, then the Week1 of Jan 2011 appears at the end.

• Why is week range starting from week 35?

  This issue can occur if there is a problem in queries of admin_mssql_warehouse.xml. Check and modify the following queries in admin_mssql_warehouse.xml. Query ID's: 1. WEEKMINRANGE 2. FILTERDAO1 3. FILTERDAO7 Please note that only administrators can ...