Re: [Dhis2-users] dhis 2.29: postgresql only

[Lars Helge Øverland]

A correction to my own statement here - DHIS version 2.29 requires
PostgreSQL *9.4* (not 9.1 as previously stated).

You can find a section in the install docs here which clarifies it:

https://docs.dhis2.org/master/en/implementer/html/install_software_requirements.html


Apologies for the confusion.

Lars


On 26 March 2018 at 12:05, Lars Helge Øverland  wrote:

> Hi,
>
> in dhis version 2.29 we require PostgreSQL as the database platform,
> together with the PostGIS spatial extension. This means that MySQL is no
> longer supported.
>
> The minimum version required is PostgreSQL 9.1. However we recommend
> upgrading to a later version as we plan to take advantage of some of the
> useful features part of PostgreSQL 10 such as logical replication and
> native partitioning in future versions of DHIS 2.
>
> You can read more here:
>
> - What's new in PG 10
> 
> - Install PG 10 on Ubuntu
> 
> - DHIS 2 installation guide
> 
>
>
> best,
>
> Lars
>
>
> --
> Lars Helge Øverland
> Technical lead, DHIS 2
> University of Oslo
> l...@dhis2.org
> https://www.dhis2.org
>
>


-- 
Lars Helge Øverland
Technical lead, DHIS 2
University of Oslo
l...@dhis2.org
https://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Indicator based on previous year's output

[Edward Robinson]

Thanks Jim, I’ll look into predictors and see if they’re able to meet my 
specific need.  I suspect they might be ideal for setting the targets, though 
we will likely set an annual target once a year and average that for quarterly 
targets – maybe once a year create quarterly target indicators based on the 
annual target elements / 4.  I’ll put something more comprehensive together for 
a Jira ticket to explain exactly what we’re doing – I suspect it will be very 
useful for the whole community.
Regards
Ed

From: Jim Grace 
Sent: Wednesday, 28 March 2018 10:23 PM
To: Tlohang 
Cc: Edward Robinson ; DHIS Users 

Subject: Re: [Dhis2-users] Indicator based on previous year's output

Hi Edward,

1. You might consider using predictors. Define additional data elements (with 
disaggregations if you like) for your targets. Use predictors to populate those 
data elements in the new period based on values from the old period(s). You can 
use a predictor formula to sum past data, and even add 5% if you like. Then you 
will have predicted (target) data in the same period to compare with your 
results in that period. For details see 
https://docs.dhis2.org/master/en/user/html/manage_predictor.html

2. We are considering possible future enhancements to analytics expressions 
including things like pulling data from past periods into an indicator. If this 
would be more useful to you than using predictors, please write up a DHIS2 Jira 
ticket that describes your use case (the kinds of things you've said in this 
email thread would be just fine), and reference the Epic at 
https://jira.dhis2.org/browse/DHIS2-3187 (or let me know and I will reference 
it -- I'm not sure what privilege is required for this.)

Cheers,
Jim


On Wed, Mar 28, 2018 at 4:05 PM, Tlohang 
mailto:moekets...@yahoo.com>> wrote:
Hi Edward

I see that I was on a different page altogether.
Well, I think your situation can still be addressed within DHIS 2 but you may 
have to do some java scripts to manage the data that has to be retrieved from 
the previous periods. We've done something close to this with one of our 
programmes.

Regards,

Tlohang

On 28 Mar 2018 19:53, Edward Robinson 
mailto:erobin...@projectbalance.com>> wrote:

Thanks Tlohang, yes, I’m aware that we can produce a cumulative number of x 
over a period, but I need to then use those numbers to compare data from 
another period as covered in my last mail, hence I assumed I may be able to 
achieve it using an indicator.  Sorry that I was a bit brief in my initial mail,

Regards

Ed



From: Tlohang mailto:moekets...@yahoo.com>>
Sent: Wednesday, 28 March 2018 7:18 PM
To: Edward Robinson 
mailto:erobin...@projectbalance.com>>
Cc: DHIS Users 
mailto:dhis2-users@lists.launchpad.net>>
Subject: Re: [Dhis2-users] Indicator based on previous year's output



Hi Edward



You probably don't need an indicator for that. The knows how to analyse that 
data element in that cumulative manner once you choose that period during 
analysis.



I hope this helps.



Regards,

Tlohang



On 28 Mar 2018 17:34, Edward Robinson 
mailto:erobin...@projectbalance.com>> wrote:

What’s the best approach to creating an indicator that’s based on a cumulative 
total of a data element captured monthly, for a set timeframe?



E.g. I have an indicator called “Number of patients” captured monthly.

I need an indicator that will give me the total number of patients for the set 
period October 2016 – September 2017.



Thanks in advance!




___
Mailing list: https://launchpad.net/~dhis2-users
Post to : 
dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Jim Grace
Core developer, DHIS 2
HISP US Inc.
http://www.dhis2.org
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp