dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi JM,

Sounds like a bug, but quite crazy to attempt as well!

Another way to do this, though perhaps not ideal, would be to perform this
calculation through SQL and inject it back into the system as a data
element. We have followed this approach for indicators which cannot be
calculated with relatively simple formulas provided by indicators, such as
those requiring "IF...THEN" types of calculations.

Not ideal, but it might be an approach you wish to consider.

Regards,
Jason


On Fri, Apr 29, 2016 at 3:24 PM, Juan Manuel Alcantara Acosta <
jmalcantara1@xxxxxxxxx> wrote:

> Hi Lars
> Thank you, I looked at the database and the interface and I didn’t see a
> limit imposed by either one. I have a formula that sums 410 data elements,
> I know that sounds impractical but that’s just the way it’s required.
> When I build the formula, with ~300 data elements I get error #1, with the
> 400 I get error #2
>
> Best regards,
> JM
>
>
> Error #1
> jquery.min.js?_rev=20997:2 GET
> https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm…cZiZ%7D%0A%2B%23%7BAV0dSekxPXl%7D%0A%2B%23%7BINM6uMXWoeK%7D%0A%0A%0A%0A%0A
> net::ERR_SPDY_PROTOCOL_ERRORsend @ jquery.min.js?_rev=20997:2p.extend.ajax
> @ jquery.min.js?_rev=20997:2getExpressionText @
> expressionBuilder.js?_rev=20997:82cleanExpression @
> expressionBuilder.js?_rev=20997:111onchange @
> showUpdateIndicatorForm.action?id=65566:584
>
>
> Error #2
> jquery.min.js?_rev=20997:2 GET
> https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm…eFqW%7D%0A%2B%23%7BePqg2GN87Ng%7D%0A%2B%23%7BFTrvVVBrdry%7D%0A%0A%0A%0A%0A
> 400 ()send @ jquery.min.js?_rev=20997:2p.extend.ajax @
> jquery.min.js?_rev=20997:2getExpressionText @
> expressionBuilder.js?_rev=20997:82cleanExpression @
> expressionBuilder.js?_rev=20997:111onchange @
> showUpdateIndicatorForm.action?id=65566:584
>
>
>
> El 28/04/2016, a las 1:40 a.m., Lars Helge Øverland <lars@xxxxxxxxx>
> escribió:
>
> Hi JM,
>
> there is no hard limit (beyond 2gb expression length;).
>
> However data analytics performance (and entry forms if you have indicators
> there) will of course suffer with extremely large indicators.
>
> regards,
>
> Lars
>
>
> On Wed, Apr 27, 2016 at 11:44 PM, Juan Manuel Alcantara Acosta <
> jmalcantara1@xxxxxxxxx> wrote:
>
>> Hi Devs
>> Is there a limit on the number of data elements that can be added in an
>> indicator formula?
>> Regards,
>> JM
>> _______________________________________________
>> 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
>>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org/>
>
>
>
> _______________________________________________
> 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
>
>


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