[Dhis2-users] Reporting Rates for Data Sets with Category Combinations as Attributes

2018-04-24 Thread Pamod Amarakoon
Dear All,

Has anyone tried using category combinations as attributes for data sets.

I noticed that when using above method and check the reporting rate summary
in Reports module number of "Expected Reports" do not consider the category
combinations. Therefore when multiple reports are submitted under a single
org unit the percentage of reports exceeds 100%. Please see screenshot
below.


​
This is the same Jira issue reported at
https://jira.dhis2.org/browse/DHIS2-1532. Any alternatives.

Thanx.

-- 
Regards,
Pamod Amarakoon
MBBS (SL)
MSc (Biomedical Informatics), EMSc (Health Admin), PGCert (MedEd), CEH
HISP Sri Lanka

Confidentiality Notice: the information contained in this email and any
attachments may be legally privileged and confidential. If you are not an
intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this e-mail is strictly prohibited. If you have
received this e-mail in error, please notify the sender and permanently
delete the e-mail and any attachments immediately. You should not retain,
copy or use this e-mail or any attachments for any purpose, nor disclose
all or any part of the contents to any other person.
___
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] List of protected tables in DHIS2

2018-04-24 Thread Morten Olav Hansen
Hi

Up to date list of protected tables can be found here:

https://github.com/dhis2/dhis2-core/blob/master/dhis-2/dhis-api/src/main/java/org/hisp/dhis/sqlview/SqlView.java#L60

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org

On Wed, Apr 25, 2018 at 12:08 AM, Jean Habib  wrote:

> Hi Community,
> Please where can I find list of protected tables when creating sqlViews?
>
> ___
> 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
>
>
___
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] FREEZING TOP ROWS

2018-04-24 Thread Knut Staring
Hi Alex,

I doubt that is possible without creating your own user interface.

What you CAN do however is to use sections - then the users can select one
section at a time.

Best,
Knut

On Mon, Apr 16, 2018 at 10:19 AM, Alex Macharia  wrote:

> Dear Team,
>
> I wish to inquire whether it is possible to freeze some part of a dataset
> for it to be viewed as one scrolls through it.
>
> I have some dataset entry tables that are long and cant fit into one
> screen so have to scroll vertically and horizontally to see other parts.
>
> Here is an example of one for TB Active Case Finding
>
> Thank you all
>
> --
> ALEX MACHARIA
>
> ___
> 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

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
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


[Dhis2-users] Monitoring country progress and achievements by making global predictions

2018-04-24 Thread Knut Staring
"The world has seen explosive growth in the use of estimates for key health
indicators. UN agencies, such as WHO and UNICEF, and academic institutions,
notably the Global Burden of Disease (GBD) work of the Institute of Health
Metrics and Evaluation (IHME), have stepped up the frequency and scope of
global health estimates. Funding agencies, led by the Bill and Melinda
Gates Foundation, are making major investments in global health estimation.
Several prominent, high-impact academic journals prioritise publication of
global health estimates, which are usually received with great interest in
the international health and development community and media. "


http://www.thelancet.com/journals/lancet/article/PIIS0140-6736(18)30586-5/fulltext


-- 
Knut Staring

Department of Information, Evidence and Research
World Health Organization, Geneva, Switzerland
Office: +41 22 791 3683 Mob1: +33 6 4434 2931 Mob2: +47 9188 0522
Skype: knutstar
___
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] SQL or api listing between Enrollement and stages

2018-04-24 Thread DJIBRIL Hakim
Thank yoiu Calle for your reply.
this Apps will be so usefull.
Best

2018-04-24 12:59 GMT+00:00 Calle Hedberg :

> Djibril,
>
> Using Event Reports, you can run a report with enrollment attributes plus
> data elements from ONE stage.
>
> For multi-stage support, you have to wait: Ismail et all from HISP-Tz is
> working on one app for this, HISP-india has developed one (that nobody else
> seemingly can get to work), and the core team is working on one for 2.30
> (see DHIS2-2461)
>
> Regards
> Calle
>
> On 24 April 2018 at 12:14, DJIBRIL Hakim  wrote:
>
>> Hi All,
>> Could someone share with me a way to get listing for a tracker program
>> based on lastest stages with the enrollment informations ?
>> Thank you
>>
>> ___
>> 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
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
> 
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
___
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] SQL or api listing between Enrollement and stages

2018-04-24 Thread Calle Hedberg
Sorry

The above are apps and thus API-related.

For SQL views, you can set up a view for the relevant Analytics tables
yourself - painful, but doable:

Analytics_enrollment.. (one for each tracker programme)
Analytics_event. (one programme per year)

Regards
Calle

On 24 April 2018 at 14:59, Calle Hedberg  wrote:

> Djibril,
>
> Using Event Reports, you can run a report with enrollment attributes plus
> data elements from ONE stage.
>
> For multi-stage support, you have to wait: Ismail et all from HISP-Tz is
> working on one app for this, HISP-india has developed one (that nobody else
> seemingly can get to work), and the core team is working on one for 2.30
> (see DHIS2-2461)
>
> Regards
> Calle
>
> On 24 April 2018 at 12:14, DJIBRIL Hakim  wrote:
>
>> Hi All,
>> Could someone share with me a way to get listing for a tracker program
>> based on lastest stages with the enrollment informations ?
>> Thank you
>>
>> ___
>> 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
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>


-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
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] SQL or api listing between Enrollement and stages

2018-04-24 Thread Calle Hedberg
Djibril,

Using Event Reports, you can run a report with enrollment attributes plus
data elements from ONE stage.

For multi-stage support, you have to wait: Ismail et all from HISP-Tz is
working on one app for this, HISP-india has developed one (that nobody else
seemingly can get to work), and the core team is working on one for 2.30
(see DHIS2-2461)

Regards
Calle

On 24 April 2018 at 12:14, DJIBRIL Hakim  wrote:

> Hi All,
> Could someone share with me a way to get listing for a tracker program
> based on lastest stages with the enrollment informations ?
> Thank you
>
> ___
> 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
>
>


-- 

***

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedb...@gmail.com

Skype: calle_hedberg

***
___
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


[Dhis2-users] SQL or api listing between Enrollement and stages

2018-04-24 Thread DJIBRIL Hakim
Hi All,
Could someone share with me a way to get listing for a tracker program
based on lastest stages with the enrollment informations ?
Thank you
___
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