Data not displaying in Pivot tables and Data Set reports

Dear All

I found this thread on the LaunchPad (https://lists.launchpad.net/dhis2-users/msg07859.html) and we are experiencing similar problems with our data. We are able to have various different users entering data into datasets, but as soon as you look to generate a report or use data visualiser/pivot tables etc. then no data is available.

If you generate a report, the entire report format comes out clearly and as it should be, but none of the entered data appears. So it is not something to do with the creation of the data sets.

Could anyone please provide any assistance?

Kind regards,

···

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

#Rabies is 99.9% fatal, 100% preventable. Together, we can #EndRabiesNow. Visit EndRabiesNow.org & sign the pledge.

Hi Terence

  1. Did you forget to regenerate the analytics tables after data entry?

It can be done ad-hoc or through scheduling.

  1. Have you enabled the “hide unapproved data in analytics” under settings > approval ?

  2. Have you set any “dimension restrictions for data analysis” for your users?

If “no” to all above, can you please share a login to your system privately?

regards,

Lars

···

On Mon, May 16, 2016 at 9:59 AM, Terence Scott terence.scott@rabiesalliance.org wrote:

Dear All

I found this thread on the LaunchPad (https://lists.launchpad.net/dhis2-users/msg07859.html) and we are experiencing similar problems with our data. We are able to have various different users entering data into datasets, but as soon as you look to generate a report or use data visualiser/pivot tables etc. then no data is available.

If you generate a report, the entire report format comes out clearly and as it should be, but none of the entered data appears. So it is not something to do with the creation of the data sets.

Could anyone please provide any assistance?

Kind regards,

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

#Rabies is 99.9% fatal, 100% preventable. Together, we can #EndRabiesNow. Visit EndRabiesNow.org & sign the pledge.


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Hi Terrence,

I use to run maintenance and table ressource generation (data administration module)+ analytique table and datamart management (report module) after entering data. and this helps me avoid such data values not found problem.

I suggest you to try it.

Henri

···

Le Lundi 16 mai 2016 8h59, Terence Scott terence.scott@rabiesalliance.org a écrit :

Dear All

I found this thread on the LaunchPad (https://lists.launchpad.net/dhis2-users/msg07859.html) and we are experiencing similar problems with our data. We are able to have various different users entering data into datasets, but as soon as you look to generate a report or use data visualiser/pivot tables etc. then no data is available.

If you generate a report, the entire report format comes out clearly and as it should be, but none of the entered data appears. So it is not something to do with the creation of the data sets.

Could anyone please provide any assistance?

Kind regards,

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

#Rabies is 99.9% fatal, 100% preventable. Together, we can #EndRabiesNow. Visit EndRabiesNow.org & sign the pledge.


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 Lars

Thanks very much for the advice. We checked all of the points that you mentioned and altered them as suggested for future reference also. It seemed to be the problem with forgetting to regenerate the analytics tables after data entry. We have thus set this as a scheduled event now!

Thanks again for all of the help and responses.

Kind regards,

Terence

···

On Mon, May 16, 2016 at 10:16 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Terence

  1. Did you forget to regenerate the analytics tables after data entry?

It can be done ad-hoc or through scheduling.

  1. Have you enabled the “hide unapproved data in analytics” under settings > approval ?
  1. Have you set any “dimension restrictions for data analysis” for your users?

If “no” to all above, can you please share a login to your system privately?

regards,

Lars

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

#Rabies is 99.9% fatal, 100% preventable. Together, we can #EndRabiesNow. Visit EndRabiesNow.org & sign the pledge.

On Mon, May 16, 2016 at 9:59 AM, Terence Scott terence.scott@rabiesalliance.org wrote:

Dear All

I found this thread on the LaunchPad (https://lists.launchpad.net/dhis2-users/msg07859.html) and we are experiencing similar problems with our data. We are able to have various different users entering data into datasets, but as soon as you look to generate a report or use data visualiser/pivot tables etc. then no data is available.

If you generate a report, the entire report format comes out clearly and as it should be, but none of the entered data appears. So it is not something to do with the creation of the data sets.

Could anyone please provide any assistance?

Kind regards,

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

#Rabies is 99.9% fatal, 100% preventable. Together, we can #EndRabiesNow. Visit EndRabiesNow.org & sign the pledge.


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Thanks Terence, good that it’s sorted out.

regards,

Lars

···

On Mon, May 16, 2016 at 2:38 PM, Terence Scott terence.scott@rabiesalliance.org wrote:

Hi Lars

Thanks very much for the advice. We checked all of the points that you mentioned and altered them as suggested for future reference also. It seemed to be the problem with forgetting to regenerate the analytics tables after data entry. We have thus set this as a scheduled event now!

Thanks again for all of the help and responses.

Kind regards,

Terence

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

#Rabies is 99.9% fatal, 100% preventable. Together, we can #EndRabiesNow. Visit EndRabiesNow.org & sign the pledge.

On Mon, May 16, 2016 at 10:16 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Terence

  1. Did you forget to regenerate the analytics tables after data entry?

It can be done ad-hoc or through scheduling.

  1. Have you enabled the “hide unapproved data in analytics” under settings > approval ?
  1. Have you set any “dimension restrictions for data analysis” for your users?

If “no” to all above, can you please share a login to your system privately?

regards,

Lars

On Mon, May 16, 2016 at 9:59 AM, Terence Scott terence.scott@rabiesalliance.org wrote:

Dear All

I found this thread on the LaunchPad (https://lists.launchpad.net/dhis2-users/msg07859.html) and we are experiencing similar problems with our data. We are able to have various different users entering data into datasets, but as soon as you look to generate a report or use data visualiser/pivot tables etc. then no data is available.

If you generate a report, the entire report format comes out clearly and as it should be, but none of the entered data appears. So it is not something to do with the creation of the data sets.

Could anyone please provide any assistance?

Kind regards,

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

#Rabies is 99.9% fatal, 100% preventable. Together, we can #EndRabiesNow. Visit EndRabiesNow.org & sign the pledge.


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

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org