Cannot add dimension attribute and measures to an existing KPI Inventory Movement Report . What should I do?

Cannot add dimension attribute and measures to an existing KPI Inventory Movement Report . What should I do?

This problem can occur if you drag and drop a computed measure then, the associated base measure will also be accompanied along with the computed measure irrespective of whether you drag the base measure or not. On dragging a computed measure, the base measure, by default will be invisible. You can either enable/disable viewing, by selecting the visible icon. Alternatively, you can make use of the ‘show/hide column’ grid utility to either show or hide the requisite measures. Also if you are unable to drag additional measures in the KPI and view them in the published mode, then it is because the character length of the table ‘ADMIN_KPIVIEWDETAIL’ is set to a standard length of 5000. Increase this to about 9000. Execute the below query in admin DB to increase the character length. ALTER TABLE `merc_dsp_uat`.`admin_kpiviewdetail` MODIFY COLUMN `VIEW_DEFINITION` VARCHAR(9000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL, ENGINE = InnoDB;