MySQL stored procedure to precalculate indicator values


I have created mysql stored procedures to precalculate indicator values and store them in a table similar to aggregateddatavalue. It might be useful for some. I am using them to generate indicator values, which will be accessed via OLAP (XMLA) from remote openoffice calc spreadsheet for slice and dice/drill down.


stored procedures for indicator value calculation.txt (5.9 KB)