Why can't I view the value for earlier years say 2009, using Yearly Period filter?

• Related Articles

• In Yearly Period filter, how can I display the value for 2009?

  To view the previous years we need to modify 'ARC194' query in the admin warehouse xml file. ARC194 = 2006 - 1 AND YEAR = ? - 1 AND YEAR <= ? AND year 9999 order by year desc --> SELECT DISTINCT YEAR, YEAR_NAME FROM DIM_DATE WHERE YEAR >= (select ...

• Is there anyway to print a portlet using the Grid view instead of the graph view?

  The print functionality of the individual dashboard portlet will be applicable to the graph and grid portlets only. For graph Portlets, even if you swap the graph to the grid view, you will still view the graph in the print.

• Why is Subdept view not showing in filter properties?

  When you click on the merchandise hierarchy and select 'Filter Details' page, the levels that show up in this section are the actual levels defined and as appearing in the dbmodel.xml file. The class code that you see is your sub-dept, which is its ...

• 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")); ...

• How can I give Portuguese label for filter value 'All' ?

  'All ' is a reserved keyword which is used in the application and hence there is no option to localize. 'All' is referred by the database to fetch all records instead of specific set of records.