dhis2-users team mailing list archive

[Greg Rowles <greg.rowles@xxxxxxxxx>]

Hi Laura

It sounds like you need an ETL developer to write custom scripts. We were
required to do similar aggregations for our MomConnect project in South
Africa. At the end of the day (with guidance from Jason Pickering) we wrote
a single (complex) script which was saved as a postgreSQL function inside
the DHIS2 database. Our function was referenced in a custom SQLview (in
DHIS2) and with help from Pierre Dane the SQLview was scheduled to run
right before the analytics process. Unfortunately it's not possible to
create this type of solution through the interface but we'll happily assist
where possible...

Kind regards,
Greg
On 21 Mar 2016 6:48 PM, "Laura E. Lincks" <laura.lincks@xxxxxxxxxxxxxxxxx>
wrote:

> Hello, all,
>
> I am posing a general question to the groups which does not necessarily
> pertain to any specific version of DHIS.
>
> We have a need to perform rather complex calculations to create
> indicators. One current need of ours can be summarized as follows:
>
> IF facility data exists for this list (A) of data elements, sum these (A)
> data elements
> ELSE
> IF facility data exists for this list (B) of data elements, sum these (B)
> data elements
> ELSE
> IF facility data exists for this list (C) of data elements, sum these (C)
> data elements
> ELSE
> sum these (D) data elements captured at the SUB-facility level
>
> We don't think native DHIS can accommodate the above example. (If it can,
> please enlighten me.) We are exploring alternatives that can function with
> DHIS, such as calling and external application from DHIS to perform the
> calculation and returning the result to DHIS for reporting needs.
>
> I imagine we are not alone in needing more robust formula creation and was
> hoping the members of the DHIS community could share with us their
> solutions. Has anyone incorporated a work around for complex formulas to
> create indicators or validation rules?
>
> Thanks in advance for your input.
>
> *Laura E. Lincks*
> Database Manager/Developer
> ICAP - Columbia University
> Mailman School of Public Health
> 60 Haven Ave, Floor B1
> New York, NY 10032
> Tel: 212 304 7132
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>