dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #03513
Re: Analytics data querying problem
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
>
Follow ups
References