← Back to team overview

dhis2-users team mailing list archive

Re: Analytics data querying problem

 

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
>>>
>>>
>>
>

Follow ups

References