Re: [Dhis2-users] Aggregation query builder details

2015-11-26 Thread Knut Staring 
Thanks for the clarifications, Elmarie and Dipali

I think these are good inputs to our dev team, and hope some of them will
also chip into this conversation.

Cheers,
Knut

On Fri, Nov 27, 2015 at 4:11 AM, Elmarie Claasen  wrote:

> Hi Knut,
>
>
>
> Although I can see that program indicators can be helpful it has limited
> use in the context of interoperability between DHIS2 instances. In South
> Africa we feel that Survey type instances should be kept separate from
> Routine Health data collection and as such collect event or tracker data
> for surveys and would want to set up aggregated data elements in the system
> which populates with a stored aggregated data value which we
> export/synchronise with the routine HMIS system e.g.
>
> Patient satisfaction survey rate = No of surveys conducted/No of facilities
>
> Patient satisfaction rate = No of satisfied responses/All responses
>
>
>
> It is true that these aggregated elements can be populated with a function
> called via a sql view or cron job but not the most ideal.
>
> Up to now I have not figured out how to set up an indicator which counts
> if there was any surveys done in a specific period by adding a program
> indicator due to the limited amount of mathematical calculation formulae
> allowed in the Program Indicator engine.
>
>
>
> This said I must say that we don’t have much confidence in the accuracy of
> the Aggregation Query Builder as it is at the moment because there seems to
> be a ceiling limit on how many values can actually be inserted by running a
> scheduled or manual aggregation process and the simultaneous initiation of
> scheduled Aggregation Query builder and Analytics are problematic. For this
> reason we are checking the output of the Aggregation Query builder at this
> stage and when not entirely confident that it produces reliable results we
> are using functions instead.
>
>
>
> Regards,
>
>
>
> *Elmarie Claasen*
>
> [image: Hisp logo]
>
> Project Manager
>
> Health Information Systems Program
>
> Tel:  041-367 1027
>
> Cell: 082 374 2209
>
> E-mail: elma...@hisp.org
>
> Skype:  elmarie.claasen52
>
>
>
>
>
> This message and any attachments are subject to a disclaimer published at 
> http://www.hisp.org/policies.html#comms_disclaimer
> .   Please read the disclaimer before opening any attachment or taking any
> other action in terms of this electronic transmission.
> If you cannot access the disclaimer, kindly send an email to 
> disclai...@hisp.org
> and a copy will be provided to you. By replying to this e-mail or opening
> any attachment you agree to be bound by the provisions of the disclaimer.
>
>
>
> *From:* Dhis2-users [mailto:dhis2-users-bounces+elmarie=
> hisp@lists.launchpad.net] *On Behalf Of *Dipali Sahu
> *Sent:* 26 November 2015 12:49 PM
> *To:* Knut Staring
> *Cc:* DHIS 2 Users list
> *Subject:* Re: [Dhis2-users] Aggregation query builder details
>
>
>
> Hi Knut
>
>
>
> We actually use Aggregation query builder to a large extent to get
> aggregated data. Exclusively, all our data is captured through Event
> capture, and we aggregate it through Aggregation query builder, so that the
> aggregated values can be shown in datasets as well as Pivot tables.
>
> Also, using Pivot tables with data elements is easier for the end users
> since they there is flexibility to can slice and dice the data with
> categories under Pivot tables.
>
>
>
> Don't you think aggregation with only program indicators will limit the
> use of categories and therefore easy visualization under pivot tables.
>
>
>
> Thank you
>
> Deepali
>
> International Medical Corps
>
>
>
>
>
> On Wed, Nov 25, 2015 at 11:34 AM, Knut Staring  wrote:
>
> Hi Nami,
>
>
>
> Which version of DHIS2 are you working on? We are phasing out the
> aggregation query builder in favor of program indicators.
>
>
>
> Knut
>
>
>
> On Tue, Nov 24, 2015 at 5:45 PM, Nami Ghadri 
> wrote:
>
> Hello,
>
>
>
> I want to create an Aggregation query builder details as sum of data
> element value I put everything but it comes to Data element for
> sum/average/min/max ** **and try to select I can’t find anything and this
> field is *
>
>
>
> *mandatory and the data aggregator data element and tracker data element
> both has sum aggregator *
>
>
>
> *Any idea about this *
>
>
>
> *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
>
>
>
>
>
> --
>
> Knut Staring
>
> Dept. of Informatics, University of Oslo
>
> Norway: +4791880522
>
> Skype: knutstar
>
> 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
>
>
>
> *This message and a

Re: [Dhis2-users] Aggregation query builder details

2015-11-26 Thread Elmarie Claasen 
Hi Knut,

 

Although I can see that program indicators can be helpful it has limited use in 
the context of interoperability between DHIS2 instances. In South Africa we 
feel that Survey type instances should be kept separate from Routine Health 
data collection and as such collect event or tracker data for surveys and would 
want to set up aggregated data elements in the system which populates with a 
stored aggregated data value which we export/synchronise with the routine HMIS 
system e.g. 

Patient satisfaction survey rate = No of surveys conducted/No of facilities

Patient satisfaction rate = No of satisfied responses/All responses

 

It is true that these aggregated elements can be populated with a function 
called via a sql view or cron job but not the most ideal. 

Up to now I have not figured out how to set up an indicator which counts if 
there was any surveys done in a specific period by adding a program indicator 
due to the limited amount of mathematical calculation formulae allowed in the 
Program Indicator engine. 

 

This said I must say that we don’t have much confidence in the accuracy of the 
Aggregation Query Builder as it is at the moment because there seems to be a 
ceiling limit on how many values can actually be inserted by running a 
scheduled or manual aggregation process and the simultaneous initiation of 
scheduled Aggregation Query builder and Analytics are problematic. For this 
reason we are checking the output of the Aggregation Query builder at this 
stage and when not entirely confident that it produces reliable results we are 
using functions instead.

 

Regards,

 

Elmarie Claasen

Hisp logo

Project Manager

Health Information Systems Program

Tel:  041-367 1027

Cell: 082 374 2209

E-mail:   elma...@hisp.org

Skype:  elmarie.claasen52 

 

 

This message and any attachments are subject to a disclaimer published at  
 
http://www.hisp.org/policies.html#comms_disclaimer .   Please read the 
disclaimer before opening any attachment or taking any other action in terms of 
this electronic transmission. 
If you cannot access the disclaimer, kindly send an email to  
 disclai...@hisp.org and a copy will be provided to 
you. By replying to this e-mail or opening any attachment you agree to be bound 
by the provisions of the disclaimer. 

 

From: Dhis2-users 
[mailto:dhis2-users-bounces+elmarie=hisp@lists.launchpad.net] On Behalf Of 
Dipali Sahu
Sent: 26 November 2015 12:49 PM
To: Knut Staring
Cc: DHIS 2 Users list
Subject: Re: [Dhis2-users] Aggregation query builder details

 

Hi Knut

 

We actually use Aggregation query builder to a large extent to get aggregated 
data. Exclusively, all our data is captured through Event capture, and we 
aggregate it through Aggregation query builder, so that the aggregated values 
can be shown in datasets as well as Pivot tables.

Also, using Pivot tables with data elements is easier for the end users since 
they there is flexibility to can slice and dice the data with categories under 
Pivot tables. 

 

Don't you think aggregation with only program indicators will limit the use of 
categories and therefore easy visualization under pivot tables.

 

Thank you

Deepali

International Medical Corps

 

 

On Wed, Nov 25, 2015 at 11:34 AM, Knut Staring  wrote:

Hi Nami,

 

Which version of DHIS2 are you working on? We are phasing out the aggregation 
query builder in favor of program indicators.

 

Knut

 

On Tue, Nov 24, 2015 at 5:45 PM, Nami Ghadri  wrote:

Hello,

 

I want to create an Aggregation query builder details as sum of data element 
value I put everything but it comes to Data element for sum/average/min/max * 
and try to select I can’t find anything and this field is 

 

mandatory and the data aggregator data element and tracker data element both 
has sum aggregator 

 

Any idea about this 

 

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





 

-- 

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522  

Skype: knutstar

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

 


-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to dis

[Dhis2-users] Fwd: DHIS 2 Live

2015-11-26 Thread Knut Staring 
I see. I am forwarding your email to the right destination, which is our
user mailing list.

Could you please share your log with us? It is in the log folder and is
called dhis.log

Have you edited the hibernate.properties file in the conf folder?

Knut

-- Forwarded message --
From: Ann Duong 
Date: Thu, Nov 26, 2015 at 8:38 PM
Subject: Re: DHIS 2 Live
To: Knut Staring 


Yes I do. I have Java 8 Update 60 installed

Ann Duong


*Global Health Corps Fellow- IT Systems Liaison*
*The Ihangane Project, Rwanda*
a...@theihanganeproject.com 
http://www.theihanganeproject.com




On Thu, Nov 26, 2015 at 4:03 PM, Knut Staring  wrote:

> Hi Ann,
>
> Do you have Java 8 installed?
>
> Knut
>
> On Thu, Nov 26, 2015 at 8:05 PM, Ann Duong  wrote:
>
>> Hello,
>>
>> My name is Ann, and I"m currently on a fellowship through the Global
>> Health Corps. I'm working in Rwanda and my organization, The Ihangane
>> Project, is looking to use DHIS 2 for the health centers in our area.
>>
>> However, I just went to download the DHIS 2 Live Package, and when I
>> tried to run it in my computer I am receiving the following error below. I
>> am on a macbook running OS X Yosemite vs 10.10 and I tried to open it with
>> Chrome Version 46.0.2490.86.
>>
>> Thank you for your assistance!
>>
>>
>> HTTP ERROR: 503
>>
>> Problem accessing /. Reason:
>>
>> Service Unavailable
>>
>> --
>> *Powered by Jetty://*
>>
>>
>>
>> Best,
>> Ann Duong
>>
>> 
>> *Global Health Corps Fellow- IT Systems Liaison*
>> *The Ihangane Project, Rwanda*
>> a...@theihanganeproject.com 
>> http://www.theihanganeproject.com
>>
>>
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>




-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
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] Aggregation query builder details

2015-11-26 Thread Dipali Sahu 
Hi Knut

We actually use Aggregation query builder to a large extent to get
aggregated data. Exclusively, all our data is captured through Event
capture, and we aggregate it through Aggregation query builder, so that the
aggregated values can be shown in datasets as well as Pivot tables.
Also, using Pivot tables with data elements is easier for the end users
since they there is flexibility to can slice and dice the data with
categories under Pivot tables.

Don't you think aggregation with only program indicators will limit the use
of categories and therefore easy visualization under pivot tables.

Thank you
Deepali
International Medical Corps


On Wed, Nov 25, 2015 at 11:34 AM, Knut Staring  wrote:

> Hi Nami,
>
> Which version of DHIS2 are you working on? We are phasing out the
> aggregation query builder in favor of program indicators.
>
> Knut
>
> On Tue, Nov 24, 2015 at 5:45 PM, Nami Ghadri 
> wrote:
>
>> Hello,
>>
>>
>>
>> I want to create an Aggregation query builder details as sum of data
>> element value I put everything but it comes to Data element for
>> sum/average/min/max ** **and try to select I can’t find anything and
>> this field is *
>>
>>
>>
>> *mandatory and the data aggregator data element and tracker data element
>> both has sum aggregator *
>>
>>
>>
>> *Any idea about this *
>>
>>
>>
>> *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
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> 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
>
>
___
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