← Back to team overview

dhis2-users team mailing list archive

Re: Analytics data querying problem

 

Sorry, mistakenly took this offlist. Why have the list policy been changed
so that default is reply to just one person?


On Wed, Dec 11, 2013 at 10:15 AM, Knut Staring <knutst@xxxxxxxxx> wrote:

> startup.sh is only for Linux.
>
> You should create a Windows environment variable called JAVA_OPTS.
>
> Set the value to -Xmx:3000m -Xms:1024m -XX:MaxPermSize=512m
> -XX:PermSize=128m
>
> Alternatively, you can open a cmd window, navigate to dhis-live and paste
> your command directly there:
>
> java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
>
>
>
> On Wed, Dec 11, 2013 at 9:54 AM, Maimoona Kausar <
> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>
>> no, its Windows Desktop, Core i3 pc with Win 7 and 4GB RAM.
>>
>>
>> On Wed, Dec 11, 2013 at 1:46 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>>> Are you running dhis live on ubuntu?
>>>
>>> Sent from my mobile
>>> On 11 Dec 2013 14:43, "Maimoona Kausar" <
>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>
>>>> java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
>>>>
>>>> I used above parameters in startup.sh, but it still gives me PermGen Space error.
>>>>
>>>> Is there some way I could download Html Standard Report as pdf?
>>>>
>>>>
>>>>
>>>>
>>>> I tried doing something like 'api/reports/rRehCvkn5mV/data.pdf?ou=uVvDS7yf79Y&pe=201312', but it didnot work.
>>>>
>>>>
>>>>
>>>>
>>>> On Wed, Dec 11, 2013 at 12:21 PM, Knut Staring <knutst@xxxxxxxxx>wrote:
>>>>
>>>>> https://www.google.la/search?q=java_opts+dhis2
>>>>>
>>>>>
>>>>> On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar <
>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>
>>>>>> No I didnot, and unfortunately I donot have any idea of how to do it
>>>>>> :(
>>>>>>
>>>>>>
>>>>>> On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring <knutst@xxxxxxxxx>wrote:
>>>>>>
>>>>>>> Did you set your JAVA_OPTS?
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar <
>>>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> Thanks I would start working on it.
>>>>>>>>
>>>>>>>> I have another question. For standard html reports, is there any
>>>>>>>> way to get/download report as pdf. Also in trying working with jrxml
>>>>>>>> reports it throws PermGen Space error. I am using dhis-live on a 4 GB
>>>>>>>> machine.
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering <
>>>>>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>> Sorry, gave you the wrong link to how to send the completeness
>>>>>>>>> information. It should be [1]
>>>>>>>>>
>>>>>>>>> You can see it here as described in the docs
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> [1]http://www.dhis2.org/doc/snapshot/en/user/html/ch25s06.html
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, Dec 11, 2013 at 6:42 AM, Jason Pickering <
>>>>>>>>> jason.p.pickering@xxxxxxxxx> wrote:
>>>>>>>>>
>>>>>>>>>> Hi Maimoona,
>>>>>>>>>> I think there are two approaches. The best way would be to
>>>>>>>>>> transmit the completeness information through the WebAPI as detailed
>>>>>>>>>> here<http://www.dhis2.org/doc/snapshot/en/user/html/ch25s13.html>
>>>>>>>>>> .
>>>>>>>>>>
>>>>>>>>>> We had a similar situation when importing data from DHIS 1.4. In
>>>>>>>>>> this case, no completeness information was transmitted, so we developed
>>>>>>>>>> some scripts to automatically populate the "completedatasetregistration"
>>>>>>>>>> table based on the presence of some compulsory data elements. It was
>>>>>>>>>> assumed that if the compulsory data elements existed, then the record was
>>>>>>>>>> complete. Records were then created and inserted into the
>>>>>>>>>> "completedatasetregistration" so that the completeness analysis would make
>>>>>>>>>> sense for these imported records. But of course, some assumptions had to be
>>>>>>>>>> made in this case, like "Was the record really complete?". Also determining
>>>>>>>>>> the date of submission would need to be considered. In this case, we just
>>>>>>>>>> set it to 15 days past the end of the period, but there could be other ways
>>>>>>>>>> of doing this.
>>>>>>>>>>
>>>>>>>>>> Best regards,
>>>>>>>>>> Jason
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Tue, Dec 10, 2013 at 10:57 PM, Maimoona Kausar <
>>>>>>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>> But we are not using any data entry forms. Our data comes into
>>>>>>>>>>> the system via dhisreport module for OpenMRS. This module saves
>>>>>>>>>>> data into table datavalue of dhis directly. I tried finding
>>>>>>>>>>> completeddataset via 'Reporting Rate Summary' but it appears
>>>>>>>>>>> that it has 0 'Actual Reports' for all months (data in table datavalue
>>>>>>>>>>> exists though). Our reports are dataSet centric and a report is comprised
>>>>>>>>>>> of a dataSet.
>>>>>>>>>>> Is there some important consideration we have not taken into
>>>>>>>>>>> account in using dhis?
>>>>>>>>>>> A quick solution could be finding all members for a dataSet and
>>>>>>>>>>> add those in dimension dynamically, but is there some other better way of
>>>>>>>>>>> achieving the goal?
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland <
>>>>>>>>>>> larshelge@xxxxxxxxx> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hi Maimoona,
>>>>>>>>>>>>
>>>>>>>>>>>> "data sets" refers to data set reporting dates. It calculates
>>>>>>>>>>>> the reporting rates based on the number of complete data set registrations
>>>>>>>>>>>> (people clicking complete in data entry that is). The table name for your
>>>>>>>>>>>> reference is "completedatasetregistration".
>>>>>>>>>>>>
>>>>>>>>>>>> regards,
>>>>>>>>>>>>
>>>>>>>>>>>> Lars
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Tue, Dec 10, 2013 at 10:42 AM, Maimoona Kausar <
>>>>>>>>>>>> maimoona.kausar@xxxxxxxxxxxxxxxxxx> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Hi Team,
>>>>>>>>>>>>>
>>>>>>>>>>>>> I am working with DHIS Standard HTML Reports.
>>>>>>>>>>>>>
>>>>>>>>>>>>> I am trying to access json data via following:
>>>>>>>>>>>>>
>>>>>>>>>>>>> ../api/analytics?skipMeta=true&dimension=pe:201312&dimension=dx:xxxxxxxxx(dataSet
>>>>>>>>>>>>> id) .
>>>>>>>>>>>>>
>>>>>>>>>>>>> It doesnot return any row for the query. However by
>>>>>>>>>>>>> eliminating 'dx', it returns 1 row as expected.
>>>>>>>>>>>>> The dataSet exists and in datavalue table it also contains
>>>>>>>>>>>>> values for some of the elements of specified dataSet in given timePeriod.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Does it perform an inner join on all members of the dataSet?
>>>>>>>>>>>>> Giving Ids of individual dataElements as dx also returns
>>>>>>>>>>>>> expected values. Is it possible to specify a dataSet/any group of elements
>>>>>>>>>>>>> that could return data for all members existing in datavalue table.
>>>>>>>>>>>>>
>>>>>>>>>>>>> I have also tried using dataElementGroupSet as follows
>>>>>>>>>>>>>
>>>>>>>>>>>>> api/analytics?skipMeta=true&dimension=pe:201312&dimension=mA8swNR1Vwi:CyAumtaciAg
>>>>>>>>>>>>>  but it doesnot work too.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Many thanks,
>>>>>>>>>>>>> Maimoona
>>>>>>>>>>>>>
>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>> 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
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Knut Staring
>>>>> Dept. of Informatics, University of Oslo
>>>>> +4791880522
>>>>> http://dhis2.org
>>>>>
>>>>
>>>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>



-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

Follow ups

References