← Back to team overview

dhis2-users team mailing list archive

Re: Analytics data querying problem

 

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