← Back to team overview

dhis2-users team mailing list archive

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

 

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@xxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxx | 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@xxxxxxxxx> 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@xxxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxx | 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>>
>
>

TIFF image


Follow ups

References