The default value for the filter must have been 'ALL' instead of number. So, change the default value to number in 'ADMIN_FILTER_DEFINITION' table in the admin database.
1. Go to Select the 'ADMIN_FILTER_DEFINITION' table in the admin database. 2. Ensure that the 'Default Value for the Filter' is a numeric value, and not 'ALL'.
This problem can occur due to the presence of special characters. Please check and clear the special character from the field SALE_INVOICE_TYPE_DESC of the table DIM_INVOICE_TYPE to solve the problem.
The reason might be the measures selected in the KPI are dimensional measures, and there are no base measures to display week wise. If you add one base measure, the same crosstab KPI will work properly. If you require further help, please contact the ...
Upload Users functionality does work fine if we key-in the Role ID and Department ID in the downloaded template. You can obtain the information of these IDs in ADMIN_MST_ROLE.
Perform the following steps to create an additional hierarchy for Tree View Manual KPI: 1. Create a new hierarchy in 'ADMIN_TREE_HIERARCHY' table 2. Create hierarchy levels for the newly created hierarchy in 'ADMIN_TREE_HIERARCHY_LEVELS' table 3. ...