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

• Related Articles

• Why is the month name repeating in monthly filter?

  This problem can occur if the month_in_year column in DIM_DATE is not unique for a given month. Please check and provide a unique name to solve the issue.

• Unable to select certain store codes from Store filter. What could be the reason?

  This might be due to the duplicate store codes present in DIM_STORE. For e.g., Store code = 13. It contains two store codes (13) as active (i.e., column->active=1). Among the two, one is an old store(column->latest=0) and the other is the latest ...

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

• On dragging an attribute into filter section, the entire filter section disappears. What could be the reason?

  One of the possible causes: --------------------------------------- Verify the parameter name used in the attribute. For e.g. Credit Customer_CUSTOMERPRICEBOOK" should be defined as "Credit_Customer_CUSTOMERPRICEBOOK". Ensure that all parameter names ...

• How do we get the pagination in the filter pop-up page?

  Set the filter style as 'Advanced Pop-up Filter' in the metadata management for the particular dimension Path: Administrator-->Metadata Management, for the pagination to get displayed in filter pop-up page.