← 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

 

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

On Tue, Jan 10, 2017 at 11:23 PM, Fredrick Onyango <deefre01@xxxxxxxxx>
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@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


References