Advance search is not working for description in Vendor and Promotion dimensions.
This problem can occur if the 'showColumn' is not defined for both Vendor and Promotion dimensions in the mssql_dbmodel.xml file. Place the showColumn attributes for both these dimensions and re-cache changes, the advance search for description for both these filters should work fine.
Related Articles
In Vendor/Promotion, Advance search does not work for 'Description'. Help me to solve this.
This issue can occur if the 'showColumn' is not defined for both Vendor and Promotion dimensions in the mssql_dbmodel.xml file. Place the showColumn attributes for both these dimensions and re-cache changes, the advance search for description for ...
Why is search in grid not working for digits other than zero?
Search in the grid works only for letters and zeros. This is the functionality of the application.
I cannot modify Dimensions properly. Why?
This problem can occur if 'Orderbydes' column and 'Level' column are defined in different DB columns. For any Dimension defined in the data model, both the 'Orderbydes' column and the 'Level' Column should be defined with the same DB column. We ...
Why can't I rename Dimensions and Hierarchies?
You cannot rename Dimensions and Hierarchies, as they will be used in more than one KPIs. Renaming may disturb the functioning of some of the KPIs. But you can try the following instead: 1. Create a new dimension and hierarchy. 2. Link all the KPIs ...
Parameter not working fine.
In "admin_db2_warehouse.xml", for the queryid "WWCAL14", we need to change the database name as highlighted below: SELECT (SELECT MONTH_IN_YEAR FROM DIM_DATE WHERE DATE_FLD = ?) - (SELECT MONTH_IN_YEAR FROM DIM_DATE WHERE DATE_FLD = ? ) AS MONTH_DIFF ...