Hi Jason Good to hear form you, I hope you are well. I agree, that is a good solution and it works very well when you implement it as a function you can call form a SQL View, then you can use the API to setup a cron job or use other means to take care of the frequency. There is a lot you can do with this approach. I was also able to setup the indicator using the API, but we want to allow the user to create these indicators. Both SQL and the API are a little beyond what they can or want to do. I think the indicator editor is due for an face lift ;-) there are other things to consider, for example having 20K constants to choose from or formulas that requires a data element with an option combination that is not part of the category combination assigned to the data element.
Best regards, JM > El 29/04/2016, a las 8:30 a.m., Jason Pickering <jason.p.picker...@gmail.com> > escribió: > > 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 > <jmalcanta...@gmail.com <mailto:jmalcanta...@gmail.com>> 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 > > <https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm%E2%80%A6cZiZ%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 > > <https://test-data.ippf.org/api/expressions/description?expression=%23%7BcIm%E2%80%A6eFqW%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 <l...@dhis2.org >> <mailto:l...@dhis2.org>> 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 >> <jmalcanta...@gmail.com <mailto:jmalcanta...@gmail.com>> 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 >> <https://launchpad.net/~dhis2-devs> >> Post to : dhis2-devs@lists.launchpad.net >> <mailto:dhis2-devs@lists.launchpad.net> >> Unsubscribe : https://launchpad.net/~dhis2-devs >> <https://launchpad.net/~dhis2-devs> >> More help : https://help.launchpad.net/ListHelp >> <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 > <https://launchpad.net/~dhis2-devs> > Post to : dhis2-devs@lists.launchpad.net > <mailto:dhis2-devs@lists.launchpad.net> > Unsubscribe : https://launchpad.net/~dhis2-devs > <https://launchpad.net/~dhis2-devs> > More help : https://help.launchpad.net/ListHelp > <https://help.launchpad.net/ListHelp> > > > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com <mailto:jason.p.picker...@gmail.com> > tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
