Analytics data querying problem

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

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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Maimoona,
I think there are two approaches. The best way would be to transmit the completeness information through the WebAPI as detailed here.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

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@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Did you set your JAVA_OPTS?

···

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

No I didnot, and unfortunately I donot have any idea of how to do it :frowning:

···

On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring knutst@gmail.com wrote:

Did you set your JAVA_OPTS?

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

https://www.google.la/search?q=java_opts+dhis2

···

On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

No I didnot, and unfortunately I donot have any idea of how to do it :frowning:


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring knutst@gmail.com wrote:

Did you set your JAVA_OPTS?

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
I used above parameters in startup.sh, but it still gives me PermGen Space error.

Is there some way I could download Html Standard Report as pdf?
I tried doing something like 'api/reports/rRehCvkn5mV/data.pdf?ou=uVvDS7yf79Y&pe=201312', but it didnot work.

···

On Wed, Dec 11, 2013 at 12:21 PM, Knut Staring knutst@gmail.com wrote:

https://www.google.la/search?q=java_opts+dhis2

On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

No I didnot, and unfortunately I donot have any idea of how to do it :frowning:


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring knutst@gmail.com wrote:

Did you set your JAVA_OPTS?

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Sorry, mistakenly took this offlist. Why have the list policy been changed so that default is reply to just one person?

···

On Wed, Dec 11, 2013 at 10:15 AM, Knut Staring knutst@gmail.com wrote:

startup.sh is only for Linux.

You should create a Windows environment variable called JAVA_OPTS.

Set the value to -Xmx:3000m -Xms:1024m -XX:MaxPermSize=512m -XX:PermSize=128m

Alternatively, you can open a cmd window, navigate to dhis-live and paste your command directly there:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 9:54 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

no, its Windows Desktop, Core i3 pc with Win 7 and 4GB RAM.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 1:46 PM, Knut Staring knutst@gmail.com wrote:

Are you running dhis live on ubuntu?

Sent from my mobile

On 11 Dec 2013 14:43, “Maimoona Kausar” maimoona.kausar@irdinformatics.org wrote:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
I used above parameters in startup.sh, but it still gives me PermGen Space error.

Is there some way I could download Html Standard Report as pdf?
I tried doing something like 'api/reports/rRehCvkn5mV/data.pdf?ou=uVvDS7yf79Y&pe=201312', but it didnot work.


On Wed, Dec 11, 2013 at 12:21 PM, Knut Staring knutst@gmail.com wrote:

https://www.google.la/search?q=java_opts+dhis2

On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

No I didnot, and unfortunately I donot have any idea of how to do it :frowning:


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring knutst@gmail.com wrote:

Did you set your JAVA_OPTS?

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Maimoona,

  • like Jason says, you can indicate whether the “form” is complete through the “dataSet” and “period” attribute on the “dataValueSet” xml element.

  • The perm gen error is very likely due to lack of JAV_OPTS being set and/or picked up by the system. You can double check from Help -> About -> Java_opts inside DHIS.

  • For HTML reports you cannot get it as PDF through the Web API directly. You can however run the report inside DHIS and click the “Download as PDF” button, which will use the web browser to render as PDF (we have optimized the CSS in order to make it render well).

Lars

···

On Wed, Dec 11, 2013 at 10:19 AM, Knut Staring knutst@gmail.com wrote:

Sorry, mistakenly took this offlist. Why have the list policy been changed so that default is reply to just one person?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 10:15 AM, Knut Staring knutst@gmail.com wrote:

startup.sh is only for Linux.

You should create a Windows environment variable called JAVA_OPTS.

Set the value to -Xmx:3000m -Xms:1024m -XX:MaxPermSize=512m -XX:PermSize=128m

Alternatively, you can open a cmd window, navigate to dhis-live and paste your command directly there:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 9:54 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

no, its Windows Desktop, Core i3 pc with Win 7 and 4GB RAM.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 1:46 PM, Knut Staring knutst@gmail.com wrote:

Are you running dhis live on ubuntu?

Sent from my mobile

On 11 Dec 2013 14:43, “Maimoona Kausar” maimoona.kausar@irdinformatics.org wrote:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
I used above parameters in startup.sh, but it still gives me PermGen Space error.

Is there some way I could download Html Standard Report as pdf?
I tried doing something like 'api/reports/rRehCvkn5mV/data.pdf?ou=uVvDS7yf79Y&pe=201312', but it didnot work.


On Wed, Dec 11, 2013 at 12:21 PM, Knut Staring knutst@gmail.com wrote:

https://www.google.la/search?q=java_opts+dhis2

On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

No I didnot, and unfortunately I donot have any idea of how to do it :frowning:


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring knutst@gmail.com wrote:

Did you set your JAVA_OPTS?

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Thanks Knut, The Permgen problem resolved by running it via command prompt directly.

Lars, could you please let me know how and where I can run my html report to get downloaded as pdf. Currently when I run report it shows me an html report with only two options ‘Print’ and Back.

···

On Wed, Dec 11, 2013 at 5:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Maimoona,

  • like Jason says, you can indicate whether the “form” is complete through the “dataSet” and “period” attribute on the “dataValueSet” xml element.
  • The perm gen error is very likely due to lack of JAV_OPTS being set and/or picked up by the system. You can double check from Help -> About -> Java_opts inside DHIS.
  • For HTML reports you cannot get it as PDF through the Web API directly. You can however run the report inside DHIS and click the “Download as PDF” button, which will use the web browser to render as PDF (we have optimized the CSS in order to make it render well).

Lars

On Wed, Dec 11, 2013 at 10:19 AM, Knut Staring knutst@gmail.com wrote:

Sorry, mistakenly took this offlist. Why have the list policy been changed so that default is reply to just one person?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 10:15 AM, Knut Staring knutst@gmail.com wrote:

startup.sh is only for Linux.

You should create a Windows environment variable called JAVA_OPTS.

Set the value to -Xmx:3000m -Xms:1024m -XX:MaxPermSize=512m -XX:PermSize=128m

Alternatively, you can open a cmd window, navigate to dhis-live and paste your command directly there:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 9:54 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

no, its Windows Desktop, Core i3 pc with Win 7 and 4GB RAM.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 1:46 PM, Knut Staring knutst@gmail.com wrote:

Are you running dhis live on ubuntu?

Sent from my mobile

On 11 Dec 2013 14:43, “Maimoona Kausar” maimoona.kausar@irdinformatics.org wrote:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
I used above parameters in startup.sh, but it still gives me PermGen Space error.

Is there some way I could download Html Standard Report as pdf?
I tried doing something like 'api/reports/rRehCvkn5mV/data.pdf?ou=uVvDS7yf79Y&pe=201312', but it didnot work.


On Wed, Dec 11, 2013 at 12:21 PM, Knut Staring knutst@gmail.com wrote:

https://www.google.la/search?q=java_opts+dhis2

On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

No I didnot, and unfortunately I donot have any idea of how to do it :frowning:


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring knutst@gmail.com wrote:

Did you set your JAVA_OPTS?

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Sorry the label on the button is “Print”. Try with chrome - it should give you a nice pdf document.

Example:

http://apps.dhis2.org/demo/dhis-web-reporting/generateHtmlReport.action?uid=AMERNML55Tg&pe=201309&

···

On Wed, Dec 11, 2013 at 1:28 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

Thanks Knut, The Permgen problem resolved by running it via command prompt directly.

Lars, could you please let me know how and where I can run my html report to get downloaded as pdf. Currently when I run report it shows me an html report with only two options ‘Print’ and Back.

On Wed, Dec 11, 2013 at 5:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Maimoona,

  • like Jason says, you can indicate whether the “form” is complete through the “dataSet” and “period” attribute on the “dataValueSet” xml element.
  • The perm gen error is very likely due to lack of JAV_OPTS being set and/or picked up by the system. You can double check from Help -> About -> Java_opts inside DHIS.
  • For HTML reports you cannot get it as PDF through the Web API directly. You can however run the report inside DHIS and click the “Download as PDF” button, which will use the web browser to render as PDF (we have optimized the CSS in order to make it render well).

Lars

On Wed, Dec 11, 2013 at 10:19 AM, Knut Staring knutst@gmail.com wrote:

Sorry, mistakenly took this offlist. Why have the list policy been changed so that default is reply to just one person?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 10:15 AM, Knut Staring knutst@gmail.com wrote:

startup.sh is only for Linux.

You should create a Windows environment variable called JAVA_OPTS.

Set the value to -Xmx:3000m -Xms:1024m -XX:MaxPermSize=512m -XX:PermSize=128m

Alternatively, you can open a cmd window, navigate to dhis-live and paste your command directly there:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 9:54 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

no, its Windows Desktop, Core i3 pc with Win 7 and 4GB RAM.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 1:46 PM, Knut Staring knutst@gmail.com wrote:

Are you running dhis live on ubuntu?

Sent from my mobile

On 11 Dec 2013 14:43, “Maimoona Kausar” maimoona.kausar@irdinformatics.org wrote:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
I used above parameters in startup.sh, but it still gives me PermGen Space error.

Is there some way I could download Html Standard Report as pdf?
I tried doing something like 'api/reports/rRehCvkn5mV/data.pdf?ou=uVvDS7yf79Y&pe=201312', but it didnot work.


On Wed, Dec 11, 2013 at 12:21 PM, Knut Staring knutst@gmail.com wrote:

https://www.google.la/search?q=java_opts+dhis2

On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

No I didnot, and unfortunately I donot have any idea of how to do it :frowning:


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring knutst@gmail.com wrote:

Did you set your JAVA_OPTS?

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Thanks alot Lars. I was able to download document as pdf as per your suggestion.

···

On Wed, Dec 11, 2013 at 6:23 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Sorry the label on the button is “Print”. Try with chrome - it should give you a nice pdf document.

Example:

http://apps.dhis2.org/demo/dhis-web-reporting/generateHtmlReport.action?uid=AMERNML55Tg&pe=201309&

On Wed, Dec 11, 2013 at 1:28 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

Thanks Knut, The Permgen problem resolved by running it via command prompt directly.

Lars, could you please let me know how and where I can run my html report to get downloaded as pdf. Currently when I run report it shows me an html report with only two options ‘Print’ and Back.

On Wed, Dec 11, 2013 at 5:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Maimoona,

  • like Jason says, you can indicate whether the “form” is complete through the “dataSet” and “period” attribute on the “dataValueSet” xml element.
  • The perm gen error is very likely due to lack of JAV_OPTS being set and/or picked up by the system. You can double check from Help -> About -> Java_opts inside DHIS.
  • For HTML reports you cannot get it as PDF through the Web API directly. You can however run the report inside DHIS and click the “Download as PDF” button, which will use the web browser to render as PDF (we have optimized the CSS in order to make it render well).

Lars

On Wed, Dec 11, 2013 at 10:19 AM, Knut Staring knutst@gmail.com wrote:

Sorry, mistakenly took this offlist. Why have the list policy been changed so that default is reply to just one person?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 10:15 AM, Knut Staring knutst@gmail.com wrote:

startup.sh is only for Linux.

You should create a Windows environment variable called JAVA_OPTS.

Set the value to -Xmx:3000m -Xms:1024m -XX:MaxPermSize=512m -XX:PermSize=128m

Alternatively, you can open a cmd window, navigate to dhis-live and paste your command directly there:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 9:54 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

no, its Windows Desktop, Core i3 pc with Win 7 and 4GB RAM.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 1:46 PM, Knut Staring knutst@gmail.com wrote:

Are you running dhis live on ubuntu?

Sent from my mobile

On 11 Dec 2013 14:43, “Maimoona Kausar” maimoona.kausar@irdinformatics.org wrote:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
I used above parameters in startup.sh, but it still gives me PermGen Space error.

Is there some way I could download Html Standard Report as pdf?
I tried doing something like 'api/reports/rRehCvkn5mV/data.pdf?ou=uVvDS7yf79Y&pe=201312', but it didnot work.


On Wed, Dec 11, 2013 at 12:21 PM, Knut Staring knutst@gmail.com wrote:

https://www.google.la/search?q=java_opts+dhis2

On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

No I didnot, and unfortunately I donot have any idea of how to do it :frowning:


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring knutst@gmail.com wrote:

Did you set your JAVA_OPTS?

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Great.

···

On Wed, Dec 11, 2013 at 6:23 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Sorry the label on the button is “Print”. Try with chrome - it should give you a nice pdf document.

Example:

http://apps.dhis2.org/demo/dhis-web-reporting/generateHtmlReport.action?uid=AMERNML55Tg&pe=201309&

On Wed, Dec 11, 2013 at 1:28 PM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

Thanks Knut, The Permgen problem resolved by running it via command prompt directly.

Lars, could you please let me know how and where I can run my html report to get downloaded as pdf. Currently when I run report it shows me an html report with only two options ‘Print’ and Back.

On Wed, Dec 11, 2013 at 5:19 PM, Lars Helge Øverland larshelge@gmail.com wrote:

Hi Maimoona,

  • like Jason says, you can indicate whether the “form” is complete through the “dataSet” and “period” attribute on the “dataValueSet” xml element.
  • The perm gen error is very likely due to lack of JAV_OPTS being set and/or picked up by the system. You can double check from Help -> About -> Java_opts inside DHIS.
  • For HTML reports you cannot get it as PDF through the Web API directly. You can however run the report inside DHIS and click the “Download as PDF” button, which will use the web browser to render as PDF (we have optimized the CSS in order to make it render well).

Lars

On Wed, Dec 11, 2013 at 10:19 AM, Knut Staring knutst@gmail.com wrote:

Sorry, mistakenly took this offlist. Why have the list policy been changed so that default is reply to just one person?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 10:15 AM, Knut Staring knutst@gmail.com wrote:

startup.sh is only for Linux.

You should create a Windows environment variable called JAVA_OPTS.

Set the value to -Xmx:3000m -Xms:1024m -XX:MaxPermSize=512m -XX:PermSize=128m

Alternatively, you can open a cmd window, navigate to dhis-live and paste your command directly there:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 9:54 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

no, its Windows Desktop, Core i3 pc with Win 7 and 4GB RAM.


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 1:46 PM, Knut Staring knutst@gmail.com wrote:

Are you running dhis live on ubuntu?

Sent from my mobile

On 11 Dec 2013 14:43, “Maimoona Kausar” maimoona.kausar@irdinformatics.org wrote:

java -Xmx6000m -Xms3000m -XX:MaxPermSize=500m -XX:PermSize=300m -jar dhis-live.jar
I used above parameters in startup.sh, but it still gives me PermGen Space error.

Is there some way I could download Html Standard Report as pdf?
I tried doing something like 'api/reports/rRehCvkn5mV/data.pdf?ou=uVvDS7yf79Y&pe=201312', but it didnot work.


On Wed, Dec 11, 2013 at 12:21 PM, Knut Staring knutst@gmail.com wrote:

https://www.google.la/search?q=java_opts+dhis2

On Wed, Dec 11, 2013 at 8:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org wrote:

No I didnot, and unfortunately I donot have any idea of how to do it :frowning:


Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

On Wed, Dec 11, 2013 at 12:13 PM, Knut Staring knutst@gmail.com wrote:

Did you set your JAVA_OPTS?

On Wed, Dec 11, 2013 at 7:18 AM, Maimoona Kausar maimoona.kausar@irdinformatics.org 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.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

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

On Wed, Dec 11, 2013 at 9:54 AM, Jason Pickering jason.p.pickering@gmail.com 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@gmail.com 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.

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@irdinformatics.org 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?


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Wed, Dec 11, 2013 at 12:39 AM, Lars Helge Øverland larshelge@gmail.com 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@irdinformatics.org 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp