MySQL stored procedure to precalculate indicator values

HI,

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.

regards,
murod

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