# MySQL stored procedure to precalculate indicator values

**URL:** <https://community.dhis2.org/t/mysql-stored-procedure-to-precalculate-indicator-values/13195>\
**Category:** Support - Assistance technique\
**Created:** [1 November 2011 11:09 UTC](https://community.dhis2.org/t/mysql-stored-procedure-to-precalculate-indicator-values/13195 "2011-11-01T11:09:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Murod\_Latifov](https://dhis2.b-cdn.net/letter_avatar_proxy/v4/letter/m/ac8455/32.png) [@Murod\_Latifov](https://community.dhis2.org/u/Murod_Latifov)\
**Post date:** [1 November 2011 11:09 UTC](https://community.dhis2.org/t/mysql-stored-procedure-to-precalculate-indicator-values/13195/1 "2011-11-01T11:09:26Z")

</div>

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](https://dhis2.b-cdn.net/uploads/default/original/2X/9/971cdd185aed324f8be4b9320747126098f63d9f.txt) (5.9 KB)
