SpagoBI - Rotation
Parameters Description Default
value The name of the value attribute value
paramWidth Set table width 300
paramHeight Set table height 300
refreshRate Set the delay between two consecutive request to server 15000
dataurl Specify the URL of the servlet that returns data http://localhost:8080/openlaszlo/OpenLaszloEngineDash
minValue Set the min value displayed by the dashboard 100
lowValue Set the value that corresponds to the upper edge of the first arc and the lower of the second one 295
highValue Set the value that corresponds to the upper edge of the second arc and the lower of the third one 340
maxValue Set the max value displayed by the dashboard 400
numOfDivisions Set the number of the main divisions 10
showMainDiv Set the main divisions visible true
showSecDiv Set the secondary divisions visible true
showMainText Set the main division label visible true
showSecText Set the secondary division label visible 10
colorArc1 Set the color of the first arc (between minValue and lowValue) 0x9cff00
colorArc2 Set the color of the second arc (between lowValue and highValue) 0xfff999
colorArc3 Set the color of the third arc (between highValue and maxValue) 0xff5454
How to feed this movie
Using a script The script must return a String like: "<rows><row {value parameter}='{numeric value}' /></rows>".
Script example (assuming that the value parameter is as default):
StringBuffer buf = new StringBuffer();
buf.append('<rows>');
buf.append('<row value=\'');
float f =
.... [numeric value calculation]
buf.append(f);
buf.append('\' />');
buf.append('</rows>')
return buf;
Using a query The query must return a row with an attribute with the key represented by the value parameter and with a numeric value:
select {something} as {value parameter} from {table} ....
Query example (assuming that the value parameter is as default):
select store_efficiency as value from stores where store_id = 3