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