← Back to team overview

dhis2-users team mailing list archive

Re: Analytics data querying problem

 

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