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| [email protected] <mailto:[email protected]> | http://www.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 <[email protected]> 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 <[email protected] > <mailto:[email protected]>> 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| > [email protected] <mailto:[email protected]> | > http://www.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 <[email protected] >> <mailto:[email protected]>> 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 >> <https://launchpad.net/~dhis2-users> >> Post to : [email protected] >> <mailto:[email protected]> >> Unsubscribe : https://launchpad.net/~dhis2-users >> <https://launchpad.net/~dhis2-users> >> More help : https://help.launchpad.net/ListHelp >> <https://help.launchpad.net/ListHelp> > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
