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

• Related Articles

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

  Modify 'ARC194' query in the admin warehouse xml file, as follows: ARC194 SELECT DISTINCT YEAR, YEAR_NAME FROM DIM_DATE WHERE YEAR >= (select year-1 from dim_date where date_fld='#lastEtlDate#') AND YEAR <= (select year from dim_date where ...

• Hierarchy Filter Display - Not consistent, why?

  The filter property for hierarchy in the metadata management will be set to 'populateAll = true". We need to set this property to 'populateAll = false". post doing the changes do the re cache changes to take into effect. By doing this, only the ...

• The pop-up filter page does not display any filter values. At the same time, it neither prints the filter query in the log file as well.

  If the database used is SQL server 2008 R2, there might be issues with the specified driver class. The driver class might be suitable for SQL Server 2005. Ensure the following changes are carried out for filter page to show-up filter values: a) ...

• The pop-up filter page does not display the filter values. The filter query is not displayed in log file too. Why?

  You may face this issue if the database is SQL Server 2008 R2. You have to use a driver class suitable for SQL Server 2005. Ensure the following for the filter values to be displayed on the filter pages: 1. Change the driver class to ...

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