Why is the month name repeating in monthly filter?

• Related Articles

• On selection of 'monthly' filter, the month names get repeated twice. What could be the reason?

  Verify DIM_DATE table for the following case: ----------------------------------------------------------------- In "DIM_DATE" table, the "month_in_year" column might be different for different years. Ensure that "month_in_year" column in "DIM_DATE" ...

• What is the configuration/changes required to order the column (for e.g. Monthly values to appear in a specific order) when Monthly filter is chosen?)

  Please follow the below steps for the changes and consult Support team before making these changes: Update the existing column "MONTH_NAME_THIS_YEAR" in the table DIM_DATE. Execute the below query in warehouse: A) update DIM_DATE set ...

• When drilled down from 'Quarter' to 'Month', KPI shows the error - 'java.lang.Exception: Query Execution Failed ! :Invalid column name #DATE_KEY#'. Why?

  It happens when the 'OrderByDes' column for MONTH and WEEK levels of TIME dimension is specified as 'OrderByDes="#DATE_KEY#", in the dbmodel.xml file. Modify that to 'OrderByDes="DATE_KEY". Note: This is advanced configuration and affect whole ...

• The KPI doesnot execute when drilled-down from 'Quarter' to 'Month'. It throws the error - 'java.lang.Exception: Query Execution Failed! : Invalid column name '#DATE_KEY#' in the log. How can the issue be solved?

  If the 'orderByDes' column for MONTH and WEEK level in TIME Dimension in 'dbmodel.xml' file is specified as 'orderByDes="#DATE_KEY#" then, the KPI will fail. In such cases, ensure that the 'orderByDes' column of the individual levels are specified as ...

• Why is the KPI not showing Daily data and always referring to Monthly aggreate table?

  If the KPI is a cross tab KPI, the KPI must be configured in such a way that the 'Month' is used in the cross tab. Therefore, it always refers Monthly level aggregate table irrespective of the filters you select in the KPI. In short, in order to view ...