← Back to team overview

dhis2-users team mailing list archive

Re: Indicator - Maximum number of data elements in the expression

 

@ Peter: This sounds quite similar to what we have done  in the PEPFAR
system as well, except we have about 1400 data element + category option
combos in one of the bigger indicators. It was not of course possible to
define these through the user interface, but worked fine through the API.

@Jane : Good to hear that it works for you. We'll be sure to include a
regression test for this to be sure this continues to be "supported".

Regards,
Jason



On Thu, Jul 26, 2018 at 10:37 AM Jane Greig <jane.greig@xxxxxxxxxxxxxx>
wrote:

> Hi Jason,
>
> Thanks, your hint solved a problem for us too where we had a large number
> of data elements needing to be included in denominators of indicators – now
> we can make indicators to insert into other indicators. We are working in
> 2.26 and hoping this will not break in the newer versions when we update.
>
> Regards
>
> Jane
>
>
>
> *From:* Dhis2-users <dhis2-users-bounces+jane.greig=
> london.msf.org@xxxxxxxxxxxxxxxxxxx> *On Behalf Of *Peter D Lubambi
> *Sent:* 26 July 2018 18:31
> *To:* jason.p.pickering@xxxxxxxxx
> *Cc:* dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 developers <
> dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> *Subject:* Re: [Dhis2-users] Indicator - Maximum number of data elements
> in the expression
>
>
>
> Hi Jason,
>
> My indicator expression consist a total of 220 data elements (1
> Positive*11 age bands *2 Sex*10 Testing points ), Alternative is, since I
> have created POS Male and POS Female so adding these two indicators would
> serve the purpose.
>
> Regards,
>
>
>
> Peter Dotto Lubambi,
>
> Skype: plubambi
> Mobile: +255 786 087 087
>
>
>
>
>
> On Tue, Jul 17, 2018 at 1:57 PM Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
> Hi Peter,
>
>
>
> I believe the limit to the number of expressions which are included in an
> indicator is that of the underlying database field which stores the
> expression, which should be very large. I think in practice, you may reach
> a limit where the indicator may be too complex to calculate quickly enough.
> We have created indicators with many hundreds of data elements, and while
> they do work, it can be a bit slow.
>
>
>
> You may also encounter a limit in the user interface when defining the
> indicators, but if you are creating one with many dozens or hundreds of
> expression elements, you are probably not going to want to use the UI
> anyway, and would script the creation of the indicator.
>
>
>
> While not supported through the user interface, adding together indicators
> will work it seems.
>
>
>
> Would be interested to hear what your experience is if you create a
> "large" indicator, or one which consists of multiple indicator components.
>
>
>
> Best regards,
>
> Jason
>
>
>
>
>
> On Tue, Jul 17, 2018 at 11:11 AM Peter D Lubambi <plubambi@xxxxxxxxx>
> wrote:
>
> Dear All,
>
> Is there a maximum number of data elements to be included in the
> Numerator/Denominator expression?
>
> If so, is it possible to include another indicator in the indicator
> calculation expression?
>
>
>
> Regards,
>
> Peter Dotto Lubambi,
>
> Skype: plubambi
> Mobile: +255 786 087 087
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
> --
>
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049 <+46764147049>
>
>

-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049

References