← Back to team overview

dhis2-users team mailing list archive

Re: Analytics data querying problem

 

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

Follow ups

References