search

billchen198318 / bamboobsc

next version move to https://github.com/billchen198318/hillfog, bambooBSC is an opensource Balanced Scorecard (BSC) Business Intelligence (BI) Web platform. BSC's Vision, Perspectives, Objectives of strategy, Key Performance Indicators (KPIs), Strategy Map, and SWOT, PDCA & PDCA report, Time Series Analysis.
Apache License 2.0
227 stars 109 forks source link

Size of field Target/Actual value #16

Closed giacomozzi closed 8 years ago

giacomozzi commented 8 years ago

I do not know if this is a bug or if I do not know how to use the system. I have a KPI called 'Cost of acquisition'. The goal is 3,250,100.25. But the Target/Actual value fields support only 3 digits. What can I do? Am I doing right?

billchen198318 commented 8 years ago

Solutions-1: KPI unit enter "million" 3250100.25 / million = 325 masure data acutal value input 325 or 325.01

billchen198318 commented 8 years ago

Solutions-2: Fix file: fix_measure_data_field.zip

  1. Download the zip file. unzip it.
  2. stop bambooBSC with apache-tomcat, if it running.
  3. overwrite gsbsc-standard.jar to gsbsc-web/WEB-INF/lib/gsbsc-standard.jar
  4. run SQL command change bb_measure_data table field. SQL-command: ALTER TABLE bb_measure_data CHANGE COLUMN TARGET TARGET FLOAT(11,2) NOT NULL DEFAULT '0' AFTER DATE, CHANGE COLUMN ACTUAL ACTUAL FLOAT(11,2) NOT NULL DEFAULT '0' AFTER TARGET;
giacomozzi commented 8 years ago

I applied successfully solution 2. Thank you very much!

billchen198318 commented 8 years ago

not to input value over min: -9999999.00 , max: 9999999.00 , because float value characteristic