Re: [Dhis2-devs] DHIS2 Dashboard Apps

Thanks a lot John for those clarification/ideas - agree with most of your points. We would be glad to be part of the process too. Martin On Sat, Apr 28, 2018 at 6:23 PM, John Mukulu wrote: > These are very interesting topics, > > Just weigh in on few of the issues raised. > > 1. Way of widgets

[Dhis2-devs] Analytics taking too much time for tracker

Dear Experts I am drawing your attention to one problem and need your kind attention. In one of our DHIS2 instances, 'Central Server' analytics generation taking too much time 12 h, 22 m, 34 s. DB size is 127 GB and have aggregated and trackers as. During analytics run-time the processor utilizat

[Dhis2-devs] How do I filter for authorities

Hello! I'm attempting to filter for roles with a specific authority and I'm getting a strange response: Specifically: Collection size must be integer `F_PROGRAM_INDICATOR_PUBLIC_ADD` The URL I'm using is: https://play.dhis2.org/2.29/api/userRoles?fields=name,id,authorities&filter=authorities:e

Re: [Dhis2-devs] Analytics taking too much time for tracker

Hi Hannan I recall you had a similar request which I responded to back in Jan 11. Maybe worth re-reading that thread as some of it seems still to be relevant. In particular: 1. The first question, as always, is has this suddenly happened or has something recently changed? Back then there had b

[Dhis2-devs] Data Value Submission Date

Hello Devs, I have looked at the "datavalue" table and discovered there are two columns (created and lastupdated). This I assume are supposed to be be the date (time stamp) of submission and update of the data values. In trying to query the API for the data values, I however have issues with fetc

[Dhis2-devs] Dimension restrictions for data analytics

Dear All, Has anyone met this scenerio? I noticed some accounts in my instance has some dimensions restricted for data analysis.Whenever i move the dimensions to the Available dimension restrictions for data analytics,when i edit that account again i find the dimensions have gone back to Select

Re: [Dhis2-devs] Data Value Submission Date

Thanks Knut. Regards On Mon, Apr 30, 2018 at 3:20 PM, Knut Staring wrote: > I suppose you mean through the Analytics API, since you can do something > like this: > > https://play.dhis2.org/2.29/api/26/dataValueSets?dataSet= > pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8 > > On Mon, Apr 30, 201

Re: [Dhis2-devs] Data Value Submission Date

I suppose you mean through the Analytics API, since you can do something like this: https://play.dhis2.org/2.29/api/26/dataValueSets?dataSet=pBOMPrpg1QX&period=201701&orgUnit=DiszpKrYNg8 On Mon, Apr 30, 2018 at 4:08 PM, Barnabas Akumba wrote: > Hello Devs, > > I have looked at the "datavalue" t

Re: [Dhis2-devs] Analytics taking too much time for tracker

Thanks Bob. I remembered that. 1st step I takes was upgrade postgres to 9.6 and tuning parameters which reduced time from 58 to 13 hour. And after that I removed/update the data types of the aggregated data set what was changed/amended that reduce the time to 8 hour. 1. this time it is gradually

Re: [Dhis2-devs] Analytics taking too much time for tracker

Hannan, Out of interest: how do you measure your DB size? "127GB" does not really say much - is it with or without analytics tables etc. Are you just using pg_database_size? I just ran that on my local instance of the South African "national" HMIS instance - it is 202 GB (NOTE: that includes anal

Re: [Dhis2-devs] Analytics taking too much time for tracker

Dear Calle Thank you for your information. 127 GB Databases size is including analytics. Yes disks are in RAID 5. Do you have tracker on that instances? Possible to share tomcat and DB tuning parameters? Please suggest. Regards Hannan On Tue, May 1, 2018 at 3:36 AM, Calle Hedberg wrote: > H