Re: [Dhis2-users] [Dhis2-devs] dhis 2.16 upgrade notes

[Morten Olav Hansen]

This looks like caching related issues, please try to either clear out
everything or run it in a incognito window.

--
Morten

On Thu, Sep 11, 2014 at 3:02 PM, sumudu weerasinghe 
wrote:

> Screenshots  are attached here. I am not sure whether your are expecting
> this or some thing else.
>
> Sumudu
>
> On Thu, Sep 11, 2014 at 12:20 PM, Morten Olav Hansen 
> wrote:
>
>> Can you open the web inspector with F12, and give use any output there?
>>
>> --
>> Morten
>>
>> On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe 
>> wrote:
>>
>>> Thanks Jason and Ngoc Thanh!
>>>
>>> I followed you instruction
>>>
>>>- remove old war file and its contents from  webapps directory
>>>- upgrade with new war file (build revision 16414)
>>>
>>> But it is still unable to open a data entry form, in this time log file
>>> does not show any error massage  . Here is my log screen shot is same as
>>> previous.
>>>
>>> Sumudu
>>>
>>> On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering <
>>> jason.p.picker...@gmail.com> wrote:
>>>
 Hi Sumudu,

 I looked through your log, and it looks like you are using an older
 build of 2.16 which is subject to a potentially very serious security flaw.
 This issue was disclosed on the DHIS2 developer  and user list last week
 out last week and a fix has been committed by the developers. You would be
 well advised to upgrade to the latest version of 2.16, available here (
 https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
 ).

 It is a bit hard to say from the logs what might be going on, because
 it is only a quite short snippet. I suggest you shutdown Tomcat, remove the
 old dhis.war file and all the contents of the /dhis directory (or whatever
 you might be calling it), download the updated 2.16 war file as mentioned
 above, restart Tomcat, and then post the logs of where things go wrong.

 Best regards,
 Jason




 On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe <
 sumudu...@gmail.com> wrote:

> Hi Lars and all,
> I used dhis 2.15 for our mental health information system, which
> contain both tracker and aggregate parts. I try to upgrade my instance to
> 2.16 from 2.15. Above mention things has been automatically happened , but
> there is a error
>
>1.  2.16 war file deployed on 2.15 database
>2. then data entry form unable to load
>3. give memory problem
>
> Can anyone advise regarding upgrading in to 2.16 ?
> Detail of log file and screen shot attach here.
> I am using
> *Version: 2.16**Build revision:16410**Database type:MySQL*
> *Java version:1.7.0_04**OS name:Windows 7*
> Regards
> Sumudu
>
>
> On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland <
> larshe...@gmail.com> wrote:
>
>> Hi,
>>
>> a note on how to upgrade to dhis version 2.16:
>>
>> The following changes *require* *action* on the implementer's side.
>>
>>- From data administration > scheduling, scheduling should be
>>deactivated, set according to your needs and finally activated.
>>- A property "encryption.password" should be added to
>>hibernate.properties file if you plan to use the data synchronization
>>feature, see the docs
>>
>> 
>>.
>>
>> The following database changes require *no action* and will happen
>> automatically when running the new WAR file the first time.
>>
>>- Column "completed" of table "programstageinstance" has been
>>removed and is replaced by the existing "status" column.
>>- The values in column "domaintype" of table "dataelement" have
>>been migrated from "aggregate" to "AGGREGATE" and from "patient" to
>>"TRACKER".
>>- A column "lastupdated" will be added to table "datavalue", this
>>might take some time when starting up the system for the first time.
>>
>> This information can also be found here:
>>
>> https://www.dhis2.org/2.16-upgrade
>>
>> We encourage people to upgrade their instances, test the new features
>> and provide feedback.
>>
>> best regards,
>>
>> Lars
>>
>>
>> ___
>> 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
>>
>>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


>

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

[Robin Martens]

Thanks a lot, Jason. I'll consider filing a blueprint for this.

Regards,

Robin

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 10 September 2014 17:55
To: Robin Martens
Cc: Lars Helge Øverland; dhis2-users@lists.launchpad.net; dhis2-devs
Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

Hi Robin,
It has been a discussed, and certainly not a bug. See a related thread here 
(https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar discussion 
on validation rules. It is essentially the same as indicators. What you will 
have to do is to create seperate indicator for each and every combination which 
you need. It can be painful, but the only way really which I know at the moment.

Feel free to file a blueprint here. https://blueprints.launchpad.net/dhis2

Regards,
Jason


On Wed, Sep 10, 2014 at 5:37 PM, Robin Martens 
mailto:mart...@sher.be>> wrote:
Dear all,

I've been testing the indicator calculation algorithm and noticed something 
particular of which I'm not sure if it's a bug or a deliberate development 
choice.

Indicators are not explicitly defined per category such as data elements but 
the reporting tools allow a disaggregated indicator calculation, which is 
definitely very useful. In a specific example, I want to know how many people 
were vaccinated this year and I have 3 kinds of vaccinations: A, B, and C. I 
have two data elements: the total population and the national vaccination 
levels (in %), with a custom category "vaccination type" which can be A, B, or 
C.

My indicator would be "total population" x "national vaccination level 
(total)". That works fine when put in a pivot table.

However, when trying to disaggregate the indicator calculation by adding my 
custom category to the pivot table, I don't have any values anymore. It seems 
the reason is that the "total population" data element does not have the 
"vaccination type" category (which seems logical) and therefore isn't found by 
the calculation algorithm. As a result, my table is empty. It seems useful that 
the algorithm would take the aggregated value (for population) available in 
such cases.

Another example is over the period dimension: my population is a yearly value, 
so when calculating an indicator on a monthly basis, instead of taking the 
available yearly value, he takes zero.

So my question: is this a deliberate choice in the development, a bug, or an 
idea for a future system improvement?

Kind regards,

Robin



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



--
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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] [Dhis2-devs] dhis 2.16 upgrade notes

[sumudu weerasinghe]

Thanks Morten,
I clear all in my chrome browser but is not working. I try it with Firefox
and it *works well*,  thanks, i think it may be problem with my browser.

Sumudu

On Thu, Sep 11, 2014 at 1:37 PM, Morten Olav Hansen 
wrote:

> This looks like caching related issues, please try to either clear out
> everything or run it in a incognito window.
>
> --
> Morten
>
> On Thu, Sep 11, 2014 at 3:02 PM, sumudu weerasinghe 
> wrote:
>
>> Screenshots  are attached here. I am not sure whether your are expecting
>> this or some thing else.
>>
>> Sumudu
>>
>> On Thu, Sep 11, 2014 at 12:20 PM, Morten Olav Hansen 
>> wrote:
>>
>>> Can you open the web inspector with F12, and give use any output there?
>>>
>>> --
>>> Morten
>>>
>>> On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe >> > wrote:
>>>
 Thanks Jason and Ngoc Thanh!

 I followed you instruction

- remove old war file and its contents from  webapps directory
- upgrade with new war file (build revision 16414)

 But it is still unable to open a data entry form, in this time log file
 does not show any error massage  . Here is my log screen shot is same as
 previous.

 Sumudu

 On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering <
 jason.p.picker...@gmail.com> wrote:

> Hi Sumudu,
>
> I looked through your log, and it looks like you are using an older
> build of 2.16 which is subject to a potentially very serious security 
> flaw.
> This issue was disclosed on the DHIS2 developer  and user list last week
> out last week and a fix has been committed by the developers. You would be
> well advised to upgrade to the latest version of 2.16, available here (
> https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
> ).
>
> It is a bit hard to say from the logs what might be going on, because
> it is only a quite short snippet. I suggest you shutdown Tomcat, remove 
> the
> old dhis.war file and all the contents of the /dhis directory (or whatever
> you might be calling it), download the updated 2.16 war file as mentioned
> above, restart Tomcat, and then post the logs of where things go wrong.
>
> Best regards,
> Jason
>
>
>
>
> On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe <
> sumudu...@gmail.com> wrote:
>
>> Hi Lars and all,
>> I used dhis 2.15 for our mental health information system, which
>> contain both tracker and aggregate parts. I try to upgrade my instance to
>> 2.16 from 2.15. Above mention things has been automatically happened , 
>> but
>> there is a error
>>
>>1.  2.16 war file deployed on 2.15 database
>>2. then data entry form unable to load
>>3. give memory problem
>>
>> Can anyone advise regarding upgrading in to 2.16 ?
>> Detail of log file and screen shot attach here.
>> I am using
>> *Version: 2.16**Build revision:16410**Database type:MySQL*
>> *Java version:1.7.0_04**OS name:Windows 7*
>> Regards
>> Sumudu
>>
>>
>> On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland <
>> larshe...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> a note on how to upgrade to dhis version 2.16:
>>>
>>> The following changes *require* *action* on the implementer's side.
>>>
>>>- From data administration > scheduling, scheduling should be
>>>deactivated, set according to your needs and finally activated.
>>>- A property "encryption.password" should be added to
>>>hibernate.properties file if you plan to use the data synchronization
>>>feature, see the docs
>>>
>>> 
>>>.
>>>
>>> The following database changes require *no action* and will happen
>>> automatically when running the new WAR file the first time.
>>>
>>>- Column "completed" of table "programstageinstance" has been
>>>removed and is replaced by the existing "status" column.
>>>- The values in column "domaintype" of table "dataelement" have
>>>been migrated from "aggregate" to "AGGREGATE" and from "patient" to
>>>"TRACKER".
>>>- A column "lastupdated" will be added to table "datavalue",
>>>this might take some time when starting up the system for the first 
>>> time.
>>>
>>> This information can also be found here:
>>>
>>> https://www.dhis2.org/2.16-upgrade
>>>
>>> We encourage people to upgrade their instances, test the new
>>> features and provide feedback.
>>>
>>> best regards,
>>>
>>> Lars
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : http

Re: [Dhis2-users] QGIS...

[Bogere Tonny]

Try downloading a new file for QGIS version 2.4

Sent from my iPhone

> On Sep 11, 2014, at 6:02 AM,  wrote:
> 
> some time you installed wrong QGIS x32/86 or x64 to support your computer?
> 
> channara
> 
> From: Jerome Shaguy
> Sent: ‎Thursday‎, ‎September‎ ‎11‎, ‎2014 ‎5‎:‎56‎ ‎Morning
> To: DHIS 2 Users list
> 
> Hi Friends,
> 
> I am having trouble running my QGIS, it installs okay but does not give me a 
> start up icon on the desktop and does not give me any interface. Has anyone 
> else experienced this? Appreciate some advice.
> 
> Cheers
> ___
> 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
___
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] [Dhis2-devs] dhis 2.16 upgrade notes

[Knut Staring]

What if you try an Incognito window in Chrome (Ctrl+Shift+N)?

Knut

On Thu, Sep 11, 2014 at 12:08 PM, sumudu weerasinghe 
wrote:

> Thanks Morten,
> I clear all in my chrome browser but is not working. I try it with
> Firefox  and it *works well*,  thanks, i think it may be problem with my
> browser.
>
> Sumudu
>
> On Thu, Sep 11, 2014 at 1:37 PM, Morten Olav Hansen 
> wrote:
>
>> This looks like caching related issues, please try to either clear out
>> everything or run it in a incognito window.
>>
>> --
>> Morten
>>
>> On Thu, Sep 11, 2014 at 3:02 PM, sumudu weerasinghe 
>> wrote:
>>
>>> Screenshots  are attached here. I am not sure whether your are expecting
>>> this or some thing else.
>>>
>>> Sumudu
>>>
>>> On Thu, Sep 11, 2014 at 12:20 PM, Morten Olav Hansen >> > wrote:
>>>
 Can you open the web inspector with F12, and give use any output there?

 --
 Morten

 On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe <
 sumudu...@gmail.com> wrote:

> Thanks Jason and Ngoc Thanh!
>
> I followed you instruction
>
>- remove old war file and its contents from  webapps directory
>- upgrade with new war file (build revision 16414)
>
> But it is still unable to open a data entry form, in this time log
> file does not show any error massage  . Here is my log screen shot is same
> as previous.
>
> Sumudu
>
> On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Sumudu,
>>
>> I looked through your log, and it looks like you are using an older
>> build of 2.16 which is subject to a potentially very serious security 
>> flaw.
>> This issue was disclosed on the DHIS2 developer  and user list last week
>> out last week and a fix has been committed by the developers. You would 
>> be
>> well advised to upgrade to the latest version of 2.16, available here (
>> https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
>> ).
>>
>> It is a bit hard to say from the logs what might be going on, because
>> it is only a quite short snippet. I suggest you shutdown Tomcat, remove 
>> the
>> old dhis.war file and all the contents of the /dhis directory (or 
>> whatever
>> you might be calling it), download the updated 2.16 war file as mentioned
>> above, restart Tomcat, and then post the logs of where things go wrong.
>>
>> Best regards,
>> Jason
>>
>>
>>
>>
>> On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe <
>> sumudu...@gmail.com> wrote:
>>
>>> Hi Lars and all,
>>> I used dhis 2.15 for our mental health information system, which
>>> contain both tracker and aggregate parts. I try to upgrade my instance 
>>> to
>>> 2.16 from 2.15. Above mention things has been automatically happened , 
>>> but
>>> there is a error
>>>
>>>1.  2.16 war file deployed on 2.15 database
>>>2. then data entry form unable to load
>>>3. give memory problem
>>>
>>> Can anyone advise regarding upgrading in to 2.16 ?
>>> Detail of log file and screen shot attach here.
>>> I am using
>>> *Version: 2.16**Build revision:16410**Database type:MySQL*
>>> *Java version:1.7.0_04**OS name:Windows 7*
>>> Regards
>>> Sumudu
>>>
>>>
>>> On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland <
>>> larshe...@gmail.com> wrote:
>>>
 Hi,

 a note on how to upgrade to dhis version 2.16:

 The following changes *require* *action* on the implementer's side.

- From data administration > scheduling, scheduling should be
deactivated, set according to your needs and finally activated.
- A property "encryption.password" should be added to
hibernate.properties file if you plan to use the data 
 synchronization
feature, see the docs

 
.

 The following database changes require *no action* and will happen
 automatically when running the new WAR file the first time.

- Column "completed" of table "programstageinstance" has been
removed and is replaced by the existing "status" column.
- The values in column "domaintype" of table "dataelement" have
been migrated from "aggregate" to "AGGREGATE" and from "patient" to
"TRACKER".
- A column "lastupdated" will be added to table "datavalue",
this might take some time when starting up the system for the first 
 time.

 This information can also be found here:

 https://www.dhis2.org/2.16-upgrade

 We encourage people to upgrade 

Re: [Dhis2-users] "future" period as denominator data

[Johan Ivar Sæbø]

Any comments on this? Is it a bug, or have I done something wrong in the 
definitions?


This is version: 2.16
Build date: 2014-09-07 13:11

To clarify: We have a population-based indicator that shows no value for 
any month in 2014 (we don't have population data for 2013). We have 
projected population data for 2014, but these are apparently only used 
when we tick off "This year" in pivot or visualizer.


Johan

On 10.09.2014 10:15, Johan Ivar Sæbø wrote:

Hi,

we have some population-based indicators, and have population-data for
2014 in the database. However, when we look at indicators for any month
in 2014, it appears that the denominator is picked from the last
finished period, i.e. 2013. When we look at 2014 as total by selecting
"this year" in pivot table, the indicator is calculated correctly using
2014 population data.

A point of allowing future data to be entered should be to use this
year's projected population data in indicators. Is there some setting
somewhere I have missed to allow this?

An example indicator is measles coverage:
Numerator: measles vaccination given (monthly)
Denominator: population <1 (yearly)
Percentage, annualized

Regards,
Johan

___
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



___
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] [Dhis2-devs] dhis 2.16 upgrade notes

[sumudu weerasinghe]

Thanks!. yes it is working in new incognito window .


Sumudu

On Thu, Sep 11, 2014 at 4:05 PM, Knut Staring  wrote:

> What if you try an Incognito window in Chrome (Ctrl+Shift+N)?
>
> Knut
>
> On Thu, Sep 11, 2014 at 12:08 PM, sumudu weerasinghe 
> wrote:
>
>> Thanks Morten,
>> I clear all in my chrome browser but is not working. I try it with
>> Firefox  and it *works well*,  thanks, i think it may be problem with my
>> browser.
>>
>> Sumudu
>>
>> On Thu, Sep 11, 2014 at 1:37 PM, Morten Olav Hansen 
>> wrote:
>>
>>> This looks like caching related issues, please try to either clear out
>>> everything or run it in a incognito window.
>>>
>>> --
>>> Morten
>>>
>>> On Thu, Sep 11, 2014 at 3:02 PM, sumudu weerasinghe >> > wrote:
>>>
 Screenshots  are attached here. I am not sure whether your are
 expecting this or some thing else.

 Sumudu

 On Thu, Sep 11, 2014 at 12:20 PM, Morten Olav Hansen <
 morte...@gmail.com> wrote:

> Can you open the web inspector with F12, and give use any output there?
>
> --
> Morten
>
> On Thu, Sep 11, 2014 at 1:47 PM, sumudu weerasinghe <
> sumudu...@gmail.com> wrote:
>
>> Thanks Jason and Ngoc Thanh!
>>
>> I followed you instruction
>>
>>- remove old war file and its contents from  webapps directory
>>- upgrade with new war file (build revision 16414)
>>
>> But it is still unable to open a data entry form, in this time log
>> file does not show any error massage  . Here is my log screen shot is 
>> same
>> as previous.
>>
>> Sumudu
>>
>> On Thu, Sep 11, 2014 at 10:09 AM, Jason Pickering <
>> jason.p.picker...@gmail.com> wrote:
>>
>>> Hi Sumudu,
>>>
>>> I looked through your log, and it looks like you are using an older
>>> build of 2.16 which is subject to a potentially very serious security 
>>> flaw.
>>> This issue was disclosed on the DHIS2 developer  and user list last week
>>> out last week and a fix has been committed by the developers. You would 
>>> be
>>> well advised to upgrade to the latest version of 2.16, available here (
>>> https://apps.dhis2.org/ci/job/dhis-2.16/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
>>> ).
>>>
>>> It is a bit hard to say from the logs what might be going on,
>>> because it is only a quite short snippet. I suggest you shutdown Tomcat,
>>> remove the old dhis.war file and all the contents of the /dhis directory
>>> (or whatever you might be calling it), download the updated 2.16 war 
>>> file
>>> as mentioned above, restart Tomcat, and then post the logs of where 
>>> things
>>> go wrong.
>>>
>>> Best regards,
>>> Jason
>>>
>>>
>>>
>>>
>>> On Thu, Sep 11, 2014 at 3:55 AM, sumudu weerasinghe <
>>> sumudu...@gmail.com> wrote:
>>>
 Hi Lars and all,
 I used dhis 2.15 for our mental health information system, which
 contain both tracker and aggregate parts. I try to upgrade my instance 
 to
 2.16 from 2.15. Above mention things has been automatically happened , 
 but
 there is a error

1.  2.16 war file deployed on 2.15 database
2. then data entry form unable to load
3. give memory problem

 Can anyone advise regarding upgrading in to 2.16 ?
 Detail of log file and screen shot attach here.
 I am using
 *Version: 2.16**Build revision:16410**Database type:MySQL*
 *Java version:1.7.0_04**OS name:Windows 7*
 Regards
 Sumudu


 On Tue, Aug 5, 2014 at 12:33 AM, Lars Helge Øverland <
 larshe...@gmail.com> wrote:

> Hi,
>
> a note on how to upgrade to dhis version 2.16:
>
> The following changes *require* *action* on the implementer's
> side.
>
>- From data administration > scheduling, scheduling should be
>deactivated, set according to your needs and finally activated.
>- A property "encryption.password" should be added to
>hibernate.properties file if you plan to use the data 
> synchronization
>feature, see the docs
>
> 
>.
>
> The following database changes require *no action* and will
> happen automatically when running the new WAR file the first time.
>
>- Column "completed" of table "programstageinstance" has been
>removed and is replaced by the existing "status" column.
>- The values in column "domaintype" of table "dataelement"
>have been migrated from "aggregate" to "AGGREGATE" and from 
> "patient" to
>"TRACKER".
>- 

Re: [Dhis2-users] QGIS...

[Jerome Shaguy]

I'm not sure what exactly happened. I got the download from
https://www.qgis.org/en/site/forusers/download.html. I am using a Macbook
Air with Windows 7 installed on it.

On Thu, Sep 11, 2014 at 4:02 AM,  wrote:

>  some time you installed wrong QGIS x32/86 or x64 to support your
> computer?
>
> channara
>
> *From:* Jerome Shaguy 
> *Sent:* ‎Thursday‎, ‎September‎ ‎11‎, ‎2014 ‎5‎:‎56‎ ‎Morning
> *To:* DHIS 2 Users list 
>
> Hi Friends,
>
> I am having trouble running my QGIS, it installs okay but does not give me
> a start up icon on the desktop and does not give me any interface. Has
> anyone else experienced this? Appreciate some advice.
>
> Cheers
>
___
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] XML ou CSV Importation de métadonnées

[Jørn Braa]

Bonjour Assetta, en franglish:

what exactly do you mean by (c'est quoi exactement)  'déconnecte de ma
base en local et me reconnecte', c'est redémarrage? /are you
restarting the DHIS?

Also make sure you have (il faut avoir) hibernate.hbm2ddl.auto =
update in your hibernate.properties file.

Et il faut avoir hibernate.properties file - sinon, les  métadonnées
importées ne marche que en 'runtime' et rien est conservée,

Do you have hibernate.properties file? Please see
https://www.dhis2.org/development for some guides

jørn

2014-09-11 8:20 GMT+02:00 Assetta BARA :
> Salut chers tous,
> l'importation des métadonnées n'est pas stable j'ai installé dhis2 en
> local (2.16) et importé mes métadonnées de ma base en ligne (2.16 aussi)
> avec succès. Mais à chaque fois, que je me déconnecte de ma base en local et
> me reconnecte, pas de métadonnées!!! Existe t-il une méthode de conserver
> ses variables importées? Merci de votre aide.
> Assetta
> DHIS2-Burkina
>
> ___
> 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
>

___
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] QGIS...

[Adebusoye Anifalaje]

Hi Jerome,

I have QGIS 2.2 installed on my Macbook (Mac OS rather than Windows VM). You 
might find it using Spotlight and QGIS search string.

Busoye
 


On 11 Sep 2014, at 12:48, Jerome Shaguy  wrote:

> I'm not sure what exactly happened. I got the download from 
> https://www.qgis.org/en/site/forusers/download.html. I am using a Macbook Air 
> with Windows 7 installed on it. 
> 
> On Thu, Sep 11, 2014 at 4:02 AM,  wrote:
> some time you installed wrong QGIS x32/86 or x64 to support your computer?
> 
> channara
> 
> From: Jerome Shaguy
> Sent: ‎Thursday‎, ‎September‎ ‎11‎, ‎2014 ‎5‎:‎56‎ ‎Morning
> To: DHIS 2 Users list
> 
> Hi Friends,
> 
> I am having trouble running my QGIS, it installs okay but does not give me a 
> start up icon on the desktop and does not give me any interface. Has anyone 
> else experienced this? Appreciate some advice.
> 
> Cheers
> 
> ___
> 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

___
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] QGIS...

[Jerome Shaguy]

Thanks Busoye, Im actually using bootcamp. I will install QGIS on my Mac
partition then. You think that might be the problem?

On Thu, Sep 11, 2014 at 1:25 PM, Adebusoye Anifalaje 
wrote:

> Hi Jerome,
>
> I have QGIS 2.2 installed on my Macbook (Mac OS rather than Windows VM).
> You might find it using Spotlight and QGIS search string.
>
> Busoye
>
>
>
> On 11 Sep 2014, at 12:48, Jerome Shaguy  wrote:
>
> I'm not sure what exactly happened. I got the download from
> https://www.qgis.org/en/site/forusers/download.html. I am using a Macbook
> Air with Windows 7 installed on it.
>
> On Thu, Sep 11, 2014 at 4:02 AM,  wrote:
>
>>  some time you installed wrong QGIS x32/86 or x64 to support your
>> computer?
>>
>> channara
>>
>> *From:* Jerome Shaguy 
>> *Sent:* ‎Thursday‎, ‎September‎ ‎11‎, ‎2014 ‎5‎:‎56‎ ‎Morning
>> *To:* DHIS 2 Users list 
>>
>> Hi Friends,
>>
>> I am having trouble running my QGIS, it installs okay but does not give
>> me a start up icon on the desktop and does not give me any interface. Has
>> anyone else experienced this? Appreciate some advice.
>>
>> Cheers
>>
>
> ___
> 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
>
>
>
___
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] "future" period as denominator data

[Lars Helge Øverland]

Hi Johan,

make sure you set the aggregation operator of the population data element
to average.

Lars
On Sep 11, 2014 7:23 AM, "Johan Ivar Sæbø"  wrote:

> Any comments on this? Is it a bug, or have I done something wrong in the
> definitions?
>
> This is version: 2.16
> Build date: 2014-09-07 13:11
>
> To clarify: We have a population-based indicator that shows no value for
> any month in 2014 (we don't have population data for 2013). We have
> projected population data for 2014, but these are apparently only used when
> we tick off "This year" in pivot or visualizer.
>
> Johan
>
> On 10.09.2014 10:15, Johan Ivar Sæbø wrote:
>
>> Hi,
>>
>> we have some population-based indicators, and have population-data for
>> 2014 in the database. However, when we look at indicators for any month
>> in 2014, it appears that the denominator is picked from the last
>> finished period, i.e. 2013. When we look at 2014 as total by selecting
>> "this year" in pivot table, the indicator is calculated correctly using
>> 2014 population data.
>>
>> A point of allowing future data to be entered should be to use this
>> year's projected population data in indicators. Is there some setting
>> somewhere I have missed to allow this?
>>
>> An example indicator is measles coverage:
>> Numerator: measles vaccination given (monthly)
>> Denominator: population <1 (yearly)
>> Percentage, annualized
>>
>> Regards,
>> Johan
>>
>> ___
>> 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
>>
>
>
> ___
> 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
>
___
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] XML ou CSV Importation de métadonnées

[Assetta BARA]

Salut Braa et olav,
Oui j'ai le fichier  Hibernate.properties
Ah oui c'est effectivement le problème d'incompatibilité de nom de la base dans 
le fichier Hibernate.properties. j'ai simplement changer le nom de ma base 
locale  ( dans le Postgresql) et redémarrer l'ordinateur et ça marche bien. 
Merci bien
cordialement!!
Assetta


Le Jeudi 11 septembre 2014 14h20, Jørn Braa  a écrit :
 


Bonjour Assetta, en franglish:

what exactly do you mean by (c'est quoi exactement)  'déconnecte de ma
base en local et me reconnecte', c'est redémarrage? /are you
restarting the DHIS?

Also make sure you have (il faut avoir) hibernate.hbm2ddl.auto =
update in your hibernate.properties file.

Et il faut avoir hibernate.properties file - sinon, les  métadonnées
importées ne marche que en 'runtime' et rien est conservée,

Do you have hibernate.properties file? Please see
https://www.dhis2.org/development for some guides

jørn


2014-09-11 8:20 GMT+02:00 Assetta BARA :
> Salut chers tous,
> l'importation des métadonnées n'est pas stable j'ai installé dhis2 en
> local (2.16) et importé mes métadonnées de ma base en ligne (2.16 aussi)
> avec succès. Mais à chaque fois, que je me déconnecte de ma base en local et
> me reconnecte, pas de métadonnées!!! Existe t-il une méthode de conserver
> ses variables importées? Merci de votre aide.
> Assetta
> DHIS2-Burkina
>
> ___
> 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

>___
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] XML ou CSV Importation de métadonnées

[Olav Poppe]

Bonjour Asetta, 
comme Jørn a suggère, c’est peut-être une problème avec le 
hibernate.properties.Veuillez vérifier «Nom de la base de données» sous «À 
propos DHIS 2» dans ton base de données locale. 

Olav



11. sep. 2014 kl. 14:20 skrev Jørn Braa :

> Bonjour Assetta, en franglish:
> 
> what exactly do you mean by (c'est quoi exactement)  'déconnecte de ma
> base en local et me reconnecte', c'est redémarrage? /are you
> restarting the DHIS?
> 
> Also make sure you have (il faut avoir) hibernate.hbm2ddl.auto =
> update in your hibernate.properties file.
> 
> Et il faut avoir hibernate.properties file - sinon, les  métadonnées
> importées ne marche que en 'runtime' et rien est conservée,
> 
> Do you have hibernate.properties file? Please see
> https://www.dhis2.org/development for some guides
> 
> jørn
> 
> 2014-09-11 8:20 GMT+02:00 Assetta BARA :
>> Salut chers tous,
>> l'importation des métadonnées n'est pas stable j'ai installé dhis2 en
>> local (2.16) et importé mes métadonnées de ma base en ligne (2.16 aussi)
>> avec succès. Mais à chaque fois, que je me déconnecte de ma base en local et
>> me reconnecte, pas de métadonnées!!! Existe t-il une méthode de conserver
>> ses variables importées? Merci de votre aide.
>> Assetta
>> DHIS2-Burkina
>> 
>> ___
>> 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
>> 
> 
> ___
> 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


___
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] [Dhis2-devs] dhis 2.16 upgrade notes

[Robin Martens]

Hi all,

Short question: is it possible to upload additional base layers (like the 
default ones of Google) into DHIS2 for visualizing in the GIS module? For 
instance in shape format?

Kind regards,

Robin
___
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] [Dhis2-devs] dhis 2.16 upgrade notes

[Knut Staring]

Currently not...we had this functionality at some point, but I think it was
removed during a refactoring of the GUI.

k


On Thu, Sep 11, 2014 at 4:18 PM, Robin Martens  wrote:

>   Hi all,
>
>
>
> Short question: is it possible to upload additional base layers (like the
> default ones of Google) into DHIS2 for visualizing in the GIS module? For
> instance in shape format?
>
>
>
> Kind regards,
>
>
>
> Robin
>
> ___
> 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
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://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] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

[Robin Martens]

Hi Jason,

To pick up the point again, there's an additional question I've been looking at.

Even if disaggregated indicator reporting is burdensome (as you explain below), 
it is sometimes necessary for correct aggregated indicator calculations (the 
most obvious one the use of weighted averages) to have "intermediary 
calculations" according to dimensions in the indicator calculation, which can 
then be aggregated over the whole table to obtain the total aggregated 
indicator value. Even in these intermediary calculations, however, the data is 
not available for calculation, returning zero as a result.

The conclusion is that the current way of indicator calculation not only 
complicates (if not makes impossible in many cases) calculation of indicators 
per custom dimension, but also making impossible the correct calculation of 
indicators over period and orgunit dimension when any intermediary calculation 
over custom dimensions is necessary.

Can you confirm this?

If true, is it hard to modify the calculation method to simply pick the 
one-level-higher value of a data element whenever no disaggregated value 
exists? With existing I don't mean NULL or zero, but rather not defined (the 
dimension does not exist).

Robin

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 10 September 2014 17:55
To: Robin Martens
Cc: Lars Helge Øverland; 
dhis2-users@lists.launchpad.net; 
dhis2-devs
Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

Hi Robin,
It has been a discussed, and certainly not a bug. See a related thread here 
(https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar discussion 
on validation rules. It is essentially the same as indicators. What you will 
have to do is to create seperate indicator for each and every combination which 
you need. It can be painful, but the only way really which I know at the moment.

Feel free to file a blueprint here. https://blueprints.launchpad.net/dhis2

Regards,
Jason


On Wed, Sep 10, 2014 at 5:37 PM, Robin Martens 
mailto:mart...@sher.be>> wrote:
Dear all,

I've been testing the indicator calculation algorithm and noticed something 
particular of which I'm not sure if it's a bug or a deliberate development 
choice.

Indicators are not explicitly defined per category such as data elements but 
the reporting tools allow a disaggregated indicator calculation, which is 
definitely very useful. In a specific example, I want to know how many people 
were vaccinated this year and I have 3 kinds of vaccinations: A, B, and C. I 
have two data elements: the total population and the national vaccination 
levels (in %), with a custom category "vaccination type" which can be A, B, or 
C.

My indicator would be "total population" x "national vaccination level 
(total)". That works fine when put in a pivot table.

However, when trying to disaggregate the indicator calculation by adding my 
custom category to the pivot table, I don't have any values anymore. It seems 
the reason is that the "total population" data element does not have the 
"vaccination type" category (which seems logical) and therefore isn't found by 
the calculation algorithm. As a result, my table is empty. It seems useful that 
the algorithm would take the aggregated value (for population) available in 
such cases.

Another example is over the period dimension: my population is a yearly value, 
so when calculating an indicator on a monthly basis, instead of taking the 
available yearly value, he takes zero.

So my question: is this a deliberate choice in the development, a bug, or an 
idea for a future system improvement?

Kind regards,

Robin



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



--
Jason P. Pickering
email: jason.p.picker...@gmail.com
tel:+46764147049
___
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] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

[Jason Pickering]

Hi Robin,
You lost me. Could you maybe give a somewhat simpler example by what you
mean by an "intermediary calculation"?

I am not sure exactly what you are trying to acheive, but what I can say is
that in certain cases, I have had to write my own calculation methods for
certain indicators which are basically impossible to calculate with the
current implementation in DHIS2. It works fine for simple sums, averages,
and other types of statistical things (standard deviation, etc), but for
instance, if you want to calculate other statistical properties (skewness,
kurtosis) of a given set of values, there is not a way to do it directly
with DHIS2. Also, certain indicators depend on component parts, and cannot
be calculated the way DHIS2 does it, by first summing up the numerator and
denominator and then dividing it, as opposed to calculating a non-weighted
average of compulsory pairs of data. What I am getting at, is that you may
have to write your own calculation methods, depending on how complex they
are.

Regards,
Jason


On Thu, Sep 11, 2014 at 4:20 PM, Robin Martens  wrote:

>  Hi Jason,
>
>
>
> To pick up the point again, there's an additional question I've been
> looking at.
>
>
>
> Even if disaggregated indicator reporting is burdensome (as you explain
> below), it is sometimes necessary for correct aggregated indicator
> calculations (the most obvious one the use of weighted averages) to have
> "intermediary calculations" according to dimensions in the indicator
> calculation, which can then be aggregated over the whole table to obtain
> the total aggregated indicator value. Even in these intermediary
> calculations, however, the data is not available for calculation, returning
> zero as a result.
>
>
>
> The conclusion is that the current way of indicator calculation not only
> complicates (if not makes impossible in many cases) calculation of
> indicators per custom dimension, but also making impossible the correct
> calculation of indicators over period and orgunit dimension when any
> intermediary calculation over custom dimensions is necessary.
>
>
>
> Can you confirm this?
>
>
>
> If true, is it hard to modify the calculation method to simply pick the
> one-level-higher value of a data element whenever no disaggregated value
> exists? With existing I don't mean NULL or zero, but rather not defined
> (the dimension does not exist).
>
>
>
> Robin
>
>
>
> *From:* Jason Pickering [mailto:jason.p.picker...@gmail.com
> ]
> *Sent:* 10 September 2014 17:55
> *To:* Robin Martens
> *Cc:* Lars Helge Øverland; dhis2-users@lists.launchpad.net; dhis2-devs
> *Subject:* Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions
>
>
>
> Hi Robin,
>
> It has been a discussed, and certainly not a bug. See a related thread
> here (https://lists.launchpad.net/dhis2-devs/msg27571.html) for a similar
> discussion on validation rules. It is essentially the same as indicators.
> What you will have to do is to create seperate indicator for each and every
> combination which you need. It can be painful, but the only way really
> which I know at the moment.
>
>
>
> Feel free to file a blueprint here. https://blueprints.launchpad.net/dhis2
>
>
>
> Regards,
>
> Jason
>
>
>
>
>
> On Wed, Sep 10, 2014 at 5:37 PM, Robin Martens  wrote:
>
> Dear all,
>
>
>
> I've been testing the indicator calculation algorithm and noticed
> something particular of which I'm not sure if it's a bug or a deliberate
> development choice.
>
>
>
> Indicators are not explicitly defined per category such as data elements
> but the reporting tools allow a disaggregated indicator calculation, which
> is definitely very useful. In a specific example, I want to know how many
> people were vaccinated this year and I have 3 kinds of vaccinations: A, B,
> and C. I have two data elements: the total population and the national
> vaccination levels (in %), with a custom category "vaccination type" which
> can be A, B, or C.
>
>
>
> My indicator would be "total population" x "national vaccination level
> (total)". That works fine when put in a pivot table.
>
>
>
> However, when trying to disaggregate the indicator calculation by adding
> my custom category to the pivot table, I don't have any values anymore. It
> seems the reason is that the "total population" data element does not have
> the "vaccination type" category (which seems logical) and therefore isn't
> found by the calculation algorithm. As a result, my table is empty. It
> seems useful that the algorithm would take the aggregated value (for
> population) available in such cases.
>
>
>
> Another example is over the period dimension: my population is a yearly
> value, so when calculating an indicator on a monthly basis, instead of
> taking the available yearly value, he takes zero.
>
>
>
> So my question: is this a deliberate choice in the development, a bug, or
> an idea for a future system improvement?
>
>
>
> Kind regards,
>
>
>
> Robin
>
>
>
>
>
>
> __

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

[Robin Martens]

Hi Jason,

I appreciate your help as this is very important for our project, thanks.

Some of our indicators are indeed quite complex and might need some custom 
coding if not too complicated. However, can you give some basic steps on how to 
achieve this (and on how hard this is in terms of programming as we're not 
experts here)?

---

The rest of this mail is about the specific issue I'm having here, it's 
basically related to three things:


1.   The absence of "cross-product" calculations in DHIS2 (I think it's 
what you call compulsory pairs of data).

2.   The fact that when no data exists on a disaggregated level, the value 
is taken to be zero instead of the aggregated (for custom dimensions only I 
think).

3.   The average function only exists over the time dimension (as discussed 
by Lars previously this week).

A simple example:



Population

Conso pp

Total

District 1

10

2

20

District 2

5

3

15

Total

15

5

35


When calculating the total national consumption, DHIS2 will do: aggregated 
population (=15) times aggregated consumption per person (=5) makes 75, which 
is wrong. In reality, the two mistakes are:


1.   The calculation should happen on district level before aggregating to 
the national value (20 for district1 plus 15 for district2 makes 35, which is 
the correct answer). -> Cross product

2.   DHIS2 always sums over orgunits (to be corrected soon according to 
Lars so I won't go further in detail here)

The cross-product issue can actually be "solved" by a workaround: obliging the 
user to explicitly show the disaggregation level (i.e. the level at which the 
cross product happens) in the report tables. Interestingly enough, when 
calculating the total in a report without showing districts, DHIS2 will return 
75, while when showing the districts 35.

Imagine now that the consumption has three products (a custom category), ABC. 
The table would look like this:



Population

Conso pp A

Conso pp B

Conso pp C

Total A

Total B

Total C

Total

District 1

10

2

1

1

20

10

10

40

District 2

5

3

1

0

15

5

0

20

Total

15

5

2

1

35

15

10

60


The same principle, but aggregated over the Product category and orgunit 
dimension gives the correct result of 60. This is how DHIS2 would calculate:


1.   When not showing the Product category in the table: total population 
(15) x total aggregated consumption (=5+2+1=8) is 120.

2.   When showing the Product category in the table: total population (0, 
it will not find a value and return zero) x consumption is 0 !!!

Indeed, the workaround does work for orgunits but not for custom dimensions 
when not all data (in this case the population) has the same custom dimensions.

I guess these are things that won't be solved quickly so I might need to do 
some coding myself. As a conclusion, to increase calculation power in DHIS2 I'd 
say:


1.   Use aggregated value when no disaggregated value exists (such as for 
population in the previous example).

2.   Aggregation operators (sum, average,...) should be defined per custom 
category and per data element. In other words, when creating a data element and 
adding categories, you have to add the operator for each category.

3.   Indicators should be available for re-use in other indicators. It 
enables you building complex indicators piece by piece and gives more 
flexibility on intermediate calculation (on disaggregated level).

I hope this is somewhat more clear.

Kind regards,

Robin

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 11 September 2014 16:30
To: Robin Martens
Cc: Lars Helge Øverland; dhis2-users@lists.launchpad.net; dhis2-devs
Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

Hi Robin,
You lost me. Could you maybe give a somewhat simpler example by what you mean 
by an "intermediary calculation"?

I am not sure exactly what you are trying to acheive, but what I can say is 
that in certain cases, I have had to write my own calculation methods for 
certain indicators which are basically impossible to calculate with the current 
implementation in DHIS2. It works fine for simple sums, averages, and other 
types of statistical things (standard deviation, etc), but for instance, if you 
want to calculate other statistical properties (skewness, kurtosis) of a given 
set of values, there is not a way to do it directly with DHIS2. Also, certain 
indicators depend on component parts, and cannot be calculated the way DHIS2 
does it, by first summing up the numerator and denominator and then dividing 
it, as opposed to calculating a non-weighted average of compulsory pairs of 
data. What I am getting at, is that you may have to write your own calculation 
methods, depending on how complex they are.

Regards,
Jason


On Thu, Sep 11, 2014 at 4:20 PM, Robin Martens 
mailto:mart...@sher.be>> wrote:
Hi Jason,

To pick up the point again, there's an additional question I've been looking at.

Even 

Re: [Dhis2-users] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

[Jason Pickering]

Hi Robin,

Your mail is dense and will need some digestion. :)

 You give a very good level of detail however of you problem in this mail
and will be very useful as this type of functionality is attempted to be
implemented.

To respond immediately to how you might be able to solve the issue, you
should possibly consider using the WebAPI to extract your data, process it
as you need, and then inject it back into DHIS2. The WebAPI is described in
detail here . I
have also written a chapter on the use of the R programming language with
DHIS2, which is particularly well suited to do the type of custom
calculations you are describing here. It is available here
. Of course,
other language/methods may also be more suited to your situation, such as
Python. Lastly, you can have a look at the DHIS2 Ad-hoc tool

which
would allow interaction with the service layer of DHIS2. Another approach
could be SQL which interacts directly with the database. I am sure there
are many other means as well. So short answer is, right now there is no
in-built way to achieve what you need I think, and it will take some coding
on your side.

We have run into similar issues in the water and sanitation sector, where
we need to work with the "latest reported data", which DHIS2 does not
handle really. We pull out the data via the WebAPI, do the aggregation
externally, and then inject everything back into the system to get the
figures we need. It would be nice if the system did it automatically, but
given the nature of the project, there are many feature requests and
limited resources. Contributions of course are welcome.

The current aggregation engine handles the "easy" cases of sums and
averages pretty well, but for more complex stuff, external routes may be
the only solution for now.

We should certainly try and distill some of your ideas into a concrete
blueprint.

Best regards,
Jason


On Thu, Sep 11, 2014 at 6:15 PM, Robin Martens  wrote:

>  Hi Jason,
>
>
>
> I appreciate your help as this is very important for our project, thanks.
>
>
>
> Some of our indicators are indeed quite complex and might need some custom
> coding if not too complicated. However, can you give some basic steps on
> how to achieve this (and on how hard this is in terms of programming as
> we're not experts here)?
>
>
>
> ---
>
>
>
> The rest of this mail is about the specific issue I'm having here, it's
> basically related to three things:
>
>
>
> 1.   The absence of "cross-product" calculations in DHIS2 (I think
> it's what you call compulsory pairs of data).
>
> 2.   The fact that when no data exists on a disaggregated level, the
> value is taken to be zero instead of the aggregated (for custom dimensions
> only I think).
>
> 3.   The average function only exists over the time dimension (as
> discussed by Lars previously this week).
>
>
>
> A simple example:
>
>
>
>
>
> Population
>
> Conso pp
>
> Total
>
> District 1
>
> 10
>
> 2
>
> 20
>
> District 2
>
> 5
>
> 3
>
> 15
>
> Total
>
> 15
>
> 5
>
> 35
>
>
>
> When calculating the total national consumption, DHIS2 will do: aggregated
> population (=15) times aggregated consumption per person (=5) makes 75,
> which is wrong. In reality, the two mistakes are:
>
>
>
> 1.   The calculation should happen on district level before
> aggregating to the national value (20 for district1 plus 15 for district2
> makes 35, which is the correct answer). -> Cross product
>
> 2.   DHIS2 always sums over orgunits (to be corrected soon according
> to Lars so I won't go further in detail here)
>
>
>
> The cross-product issue can actually be "solved" by a workaround: obliging
> the user to explicitly show the disaggregation level (i.e. the level at
> which the cross product happens) in the report tables. Interestingly
> enough, when calculating the total in a report without showing districts,
> DHIS2 will return 75, while when showing the districts 35.
>
>
>
> Imagine now that the consumption has three products (a custom category),
> ABC. The table would look like this:
>
>
>
>
>
> Population
>
> Conso pp A
>
> Conso pp B
>
> Conso pp C
>
> Total A
>
> Total B
>
> Total C
>
> *Total*
>
> District 1
>
> 10
>
> 2
>
> 1
>
> 1
>
> 20
>
> 10
>
> 10
>
> *40*
>
> District 2
>
> 5
>
> 3
>
> 1
>
> 0
>
> 15
>
> 5
>
> 0
>
> *20*
>
> Total
>
> 15
>
> 5
>
> 2
>
> 1
>
> 35
>
> 15
>
> 10
>
> 60
>
>
>
> The same principle, but aggregated over the Product category and orgunit
> dimension gives the correct result of 60. This is how DHIS2 would calculate:
>
>
>
> 1.   When not showing the Product category in the table: total
> population (15) x total aggregated consumption (=5+2+1=8) is 120.
>
> 2.   When showing the Product category in the table: total population
> (0, it will not find a value and return zero) x consumpt

[Dhis2-users] Event Capture - Program not selected

[sumudu weerasinghe]

Dear all,
I have my instance which was upgrade from 2.15 to 2.16 (R 16414). I try to
use event capture module . But the selection list for the program is empty,
even-though  my instance has two programme  . No errors found in log file.

Let me know if you have any idea why this might be happening.

Best Regards
Sumudu
___
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] [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

[Robin Martens]

Hi Jason,

Thanks for taking the time to read through my email.

I'll have a look at the different possibilities you proposed, and we'll be 
looking forward to any future upgrade of the calculation method (for now or 
later). I guess it's just that some sectors need more complex indicators than 
others (our project is in forest management).

Have a nice day,

Robin

From: Jason Pickering [mailto:jason.p.picker...@gmail.com]
Sent: 11 September 2014 19:00
To: Robin Martens
Cc: Lars Helge Øverland; dhis2-users@lists.launchpad.net; dhis2-devs
Subject: Re: [Dhis2-devs] DHIS2 - Indicator calculation over dimensions

Hi Robin,

Your mail is dense and will need some digestion. :)

 You give a very good level of detail however of you problem in this mail and 
will be very useful as this type of functionality is attempted to be 
implemented.

To respond immediately to how you might be able to solve the issue, you should 
possibly consider using the WebAPI to extract your data, process it as you 
need, and then inject it back into DHIS2. The WebAPI is described in detail 
here. I have also 
written a chapter on the use of the R programming language with DHIS2, which is 
particularly well suited to do the type of custom calculations you are 
describing here. It is available 
here. Of course, 
other language/methods may also be more suited to your situation, such as 
Python. Lastly, you can have a look at the DHIS2 Ad-hoc 
tool
 which would allow interaction with the service layer of DHIS2. Another 
approach could be SQL which interacts directly with the database. I am sure 
there are many other means as well. So short answer is, right now there is no 
in-built way to achieve what you need I think, and it will take some coding on 
your side.

We have run into similar issues in the water and sanitation sector, where we 
need to work with the "latest reported data", which DHIS2 does not handle 
really. We pull out the data via the WebAPI, do the aggregation externally, and 
then inject everything back into the system to get the figures we need. It 
would be nice if the system did it automatically, but given the nature of the 
project, there are many feature requests and limited resources. Contributions 
of course are welcome.

The current aggregation engine handles the "easy" cases of sums and averages 
pretty well, but for more complex stuff, external routes may be the only 
solution for now.

We should certainly try and distill some of your ideas into a concrete 
blueprint.

Best regards,
Jason


On Thu, Sep 11, 2014 at 6:15 PM, Robin Martens 
mailto:mart...@sher.be>> wrote:
Hi Jason,

I appreciate your help as this is very important for our project, thanks.

Some of our indicators are indeed quite complex and might need some custom 
coding if not too complicated. However, can you give some basic steps on how to 
achieve this (and on how hard this is in terms of programming as we're not 
experts here)?

---

The rest of this mail is about the specific issue I'm having here, it's 
basically related to three things:


1.   The absence of "cross-product" calculations in DHIS2 (I think it's 
what you call compulsory pairs of data).

2.   The fact that when no data exists on a disaggregated level, the value 
is taken to be zero instead of the aggregated (for custom dimensions only I 
think).

3.   The average function only exists over the time dimension (as discussed 
by Lars previously this week).

A simple example:



Population

Conso pp

Total

District 1

10

2

20

District 2

5

3

15

Total

15

5

35


When calculating the total national consumption, DHIS2 will do: aggregated 
population (=15) times aggregated consumption per person (=5) makes 75, which 
is wrong. In reality, the two mistakes are:


1.   The calculation should happen on district level before aggregating to 
the national value (20 for district1 plus 15 for district2 makes 35, which is 
the correct answer). -> Cross product

2.   DHIS2 always sums over orgunits (to be corrected soon according to 
Lars so I won't go further in detail here)

The cross-product issue can actually be "solved" by a workaround: obliging the 
user to explicitly show the disaggregation level (i.e. the level at which the 
cross product happens) in the report tables. Interestingly enough, when 
calculating the total in a report without showing districts, DHIS2 will return 
75, while when showing the districts 35.

Imagine now that the consumption has three products (a custom category), ABC. 
The table would look like this:



Population

Conso pp A

Conso pp B

Conso pp C

Total A

Total B

Total C

Total

District 1

10

2

1

1

20

10

10

40

District 2

5

3

1

0

15

5

0

20

Total

15

5

2

1

35

15

10

60


The same principle, but aggregated ov