DHIS 2 (Version 2.23): Data doesn't display in DHIS Pivot table even after running analytics

Hi All,

I’m not able to view data on the Pivot table.
The data entered is however visible on the data entry screens and on the data set report but not on the DHIS 2 Pivot Table.

I’ve cleared the cache on Mozilla/Chrome and run analytics.Data mart jobs are scheduled to run every night at midnight.

Data is visible on PostgreSQL data value table.

Also noticed a message “(user) constrained by dimension” on the tomcat logs when attempting to access data on the pivot.

Please assist,

Fred

Hi Fred,

It is possible that the user has certain dimension restrictions for analytics.

Go to Apps -> Users. Select the user that is having problems visualising data in analytics. Edit the User. Scroll down and select “Show more options”.

You should see a section title “Available dimension restrictions for data analytics” (see attached). Check that there are no dimensions selected by mistake. If there are selected dimensions, try deselecting these from the user account and save. Run analytics to check if this resolves the problem.

If it doesn’t then it is possible that you may have other sharing protocols for the data you want to view.

Hope this helps.

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

···

On 10 Jan 2017, at 18:32, Fredrick Onyango deefre01@gmail.com wrote:

Hi All,

I’m not able to view data on the Pivot table.
The data entered is however visible on the data entry screens and on the data set report but not on the DHIS 2 Pivot Table.

I’ve cleared the cache on Mozilla/Chrome and run analytics.Data mart jobs are scheduled to run every night at midnight.

Data is visible on PostgreSQL data value table.

Also noticed a message “(user) constrained by dimension” on the tomcat logs when attempting to access data on the pivot.

Please assist,

Fred


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

I appreciate the feedback.

I’ve checked the dimension restrictions for data analytics and none is selected.

On the second option,are you referring to the ‘sharing settings’ on the data elements?Kindly clarify.

Fred

PastedGraphic-1.tiff (11.1 KB)

···

On Tue, Jan 10, 2017 at 9:44 PM, Busoye Anifalaje busoye@baosystems.com wrote:

Hi Fred,

It is possible that the user has certain dimension restrictions for analytics.

Go to Apps -> Users. Select the user that is having problems visualising data in analytics. Edit the User. Scroll down and select “Show more options”.

You should see a section title “Available dimension restrictions for data analytics” (see attached). Check that there are no dimensions selected by mistake. If there are selected dimensions, try deselecting these from the user account and save. Run analytics to check if this resolves the problem.

If it doesn’t then it is possible that you may have other sharing protocols for the data you want to view.

Hope this helps.

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

On 10 Jan 2017, at 18:32, Fredrick Onyango deefre01@gmail.com wrote:

Hi All,

I’m not able to view data on the Pivot table.
The data entered is however visible on the data entry screens and on the data set report but not on the DHIS 2 Pivot Table.

I’ve cleared the cache on Mozilla/Chrome and run analytics.Data mart jobs are scheduled to run every night at midnight.

Data is visible on PostgreSQL data value table.

Also noticed a message “(user) constrained by dimension” on the tomcat logs when attempting to access data on the pivot.

Please assist,

Fred


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

I actually thought about it after sending the initial email. If the same user can see the data in data set reports, there really shouldn’t be a reason not to see the data in pivot tables unless there are parameters you have added in pivot tables which weren’t in the data set report.

Can you shed some light on what kind of table you are trying to create? Indicators, data elements, category dimension, org unit group dimension etc

Cheers

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

···

On Tue, Jan 10, 2017 at 9:44 PM, Busoye Anifalaje busoye@baosystems.com wrote:

Hi Fred,

It is possible that the user has certain dimension restrictions for analytics.

Go to Apps -> Users. Select the user that is having problems visualising data in analytics. Edit the User. Scroll down and select “Show more options”.

You should see a section title “Available dimension restrictions for data analytics” (see attached). Check that there are no dimensions selected by mistake. If there are selected dimensions, try deselecting these from the user account and save. Run analytics to check if this resolves the problem.

If it doesn’t then it is possible that you may have other sharing protocols for the data you want to view.

Hope this helps.

<PastedGraphic-1.tiff>
Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

<Screen Shot 2017-01-10 at 18.41.26.png>

On 10 Jan 2017, at 18:32, Fredrick Onyango deefre01@gmail.com wrote:

Hi All,

I’m not able to view data on the Pivot table.
The data entered is however visible on the data entry screens and on the data set report but not on the DHIS 2 Pivot Table.

I’ve cleared the cache on Mozilla/Chrome and run analytics.Data mart jobs are scheduled to run every night at midnight.

Data is visible on PostgreSQL data value table.

Also noticed a message “(user) constrained by dimension” on the tomcat logs when attempting to access data on the pivot.

Please assist,

Fred


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 again for your help,

Now that you mentioned consistency of parameters,I’ve re-examined the setup and suspect I may have erroneously excluded a few category and data element components when importing meta-data.

Allow me to revert as soon as I review the imports for further assistance.

Many Thanks,

PastedGraphic-1.tiff (11.1 KB)

···

On Tue, Jan 10, 2017 at 10:37 PM, Busoye Anifalaje busoye@baosystems.com wrote:

Hi Fred,
I actually thought about it after sending the initial email. If the same user can see the data in data set reports, there really shouldn’t be a reason not to see the data in pivot tables unless there are parameters you have added in pivot tables which weren’t in the data set report.

Can you shed some light on what kind of table you are trying to create? Indicators, data elements, category dimension, org unit group dimension etc

Cheers

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

On 10 Jan 2017, at 19:28, Fredrick Onyango deefre01@gmail.com wrote:

Thanks Busoye,

I appreciate the feedback.

I’ve checked the dimension restrictions for data analytics and none is selected.

On the second option,are you referring to the ‘sharing settings’ on the data elements?Kindly clarify.

Fred

On Tue, Jan 10, 2017 at 9:44 PM, Busoye Anifalaje busoye@baosystems.com wrote:

Hi Fred,

It is possible that the user has certain dimension restrictions for analytics.

Go to Apps -> Users. Select the user that is having problems visualising data in analytics. Edit the User. Scroll down and select “Show more options”.

You should see a section title “Available dimension restrictions for data analytics” (see attached). Check that there are no dimensions selected by mistake. If there are selected dimensions, try deselecting these from the user account and save. Run analytics to check if this resolves the problem.

If it doesn’t then it is possible that you may have other sharing protocols for the data you want to view.

Hope this helps.

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

<PastedGraphic-1.tiff>

<Screen Shot 2017-01-10 at 18.41.26.png>

On 10 Jan 2017, at 18:32, Fredrick Onyango deefre01@gmail.com wrote:

Hi All,

I’m not able to view data on the Pivot table.
The data entered is however visible on the data entry screens and on the data set report but not on the DHIS 2 Pivot Table.

I’ve cleared the cache on Mozilla/Chrome and run analytics.Data mart jobs are scheduled to run every night at midnight.

Data is visible on PostgreSQL data value table.

Also noticed a message “(user) constrained by dimension” on the tomcat logs when attempting to access data on the pivot.

Please assist,

Fred


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

I confirmed the issue had to do with some missing components/dependencies from some metadata that we’re left our during export.I did a fresh export/import and all is working perfect now.

Many thanks for your assistance.

Regards,

Fred

PastedGraphic-1.tiff (11.1 KB)

···

On Tue, Jan 10, 2017 at 11:23 PM, Fredrick Onyango deefre01@gmail.com wrote:

Thanks again for your help,

Now that you mentioned consistency of parameters,I’ve re-examined the setup and suspect I may have erroneously excluded a few category and data element components when importing meta-data.

Allow me to revert as soon as I review the imports for further assistance.

Many Thanks,

On Tue, Jan 10, 2017 at 10:37 PM, Busoye Anifalaje busoye@baosystems.com wrote:

Hi Fred,
I actually thought about it after sending the initial email. If the same user can see the data in data set reports, there really shouldn’t be a reason not to see the data in pivot tables unless there are parameters you have added in pivot tables which weren’t in the data set report.

Can you shed some light on what kind of table you are trying to create? Indicators, data elements, category dimension, org unit group dimension etc

Cheers

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

On 10 Jan 2017, at 19:28, Fredrick Onyango deefre01@gmail.com wrote:

Thanks Busoye,

I appreciate the feedback.

I’ve checked the dimension restrictions for data analytics and none is selected.

On the second option,are you referring to the ‘sharing settings’ on the data elements?Kindly clarify.

Fred

On Tue, Jan 10, 2017 at 9:44 PM, Busoye Anifalaje busoye@baosystems.com wrote:

Hi Fred,

It is possible that the user has certain dimension restrictions for analytics.

Go to Apps -> Users. Select the user that is having problems visualising data in analytics. Edit the User. Scroll down and select “Show more options”.

You should see a section title “Available dimension restrictions for data analytics” (see attached). Check that there are no dimensions selected by mistake. If there are selected dimensions, try deselecting these from the user account and save. Run analytics to check if this resolves the problem.

If it doesn’t then it is possible that you may have other sharing protocols for the data you want to view.

Hope this helps.

Busoye Anifalaje (PhD)
Director of Services (Principal), BAO Systems

UK: +44 7901-740-757 | US: +1 682-307-0986|

busoye@baosystems.com | http://www.baosystems.com |

Skype: busoye | 2900 K Street, Suite 404, Washington D.C. 20007

<PastedGraphic-1.tiff>

<Screen Shot 2017-01-10 at 18.41.26.png>

On 10 Jan 2017, at 18:32, Fredrick Onyango deefre01@gmail.com wrote:

Hi All,

I’m not able to view data on the Pivot table.
The data entered is however visible on the data entry screens and on the data set report but not on the DHIS 2 Pivot Table.

I’ve cleared the cache on Mozilla/Chrome and run analytics.Data mart jobs are scheduled to run every night at midnight.

Data is visible on PostgreSQL data value table.

Also noticed a message “(user) constrained by dimension” on the tomcat logs when attempting to access data on the pivot.

Please assist,

Fred


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