dhis2-users team mailing list archive

["Hinds, Ms. Angela (CAR)" <hindsang@xxxxxxxxxx>]

Thanks everyone for the response. When I run the analytics it gives me the following below, which is related to a view I created in PgAdmin. Is the only option to move the view, run the analytics then add the view again?

Regards,
Angela  

Error
Process failed: StatementCallback; uncategorized SQLException for SQL [drop table _dateperiodstructure;]; SQL state [2BP01]; error code [0]; ERROR: cannot drop table _dateperiodstructure because other objects depend on it Detail: view "DHIS2MasterViewXtra" depends on table _dateperiodstructure 
Hint: Use DROP ... CASCADE to drop the dependent objects too.; nested exception is org.postgresql.util.PSQLException: ERROR: cannot drop table _dateperiodstructure because other objects depend on it Detail: view "DHIS2MasterViewXtra" depends on table _dateperiodstructure Hint: Use DROP ... CASCADE to drop the dependent objects too.  


-----Original Message-----
From: Dan Cocos [mailto:dcocos@xxxxxxxxx] 
Sent: Wednesday, November 23, 2016 12:18 PM
To: Hinds, Ms. Angela (CAR) <hindsang@xxxxxxxxxx>
Cc: DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-devs] No totals visible in the pivot table

You have to run Analytics for the Pivot Tables to update Apps —> Reports —> Analytics 


Dan Cocos
Principal, BAO Systems
dcocos@xxxxxxxxxxxxxx | http://www.baosystems.com |  2900 K Street, Suite 404, Washington D.C. 20007

> On Nov 23, 2016, at 11:15 AM, Hinds, Ms. Angela (CAR) <hindsang@xxxxxxxxxx> wrote:
> 
> Hi Folks,
>  
> I recently imported records using a csv file into DHIS 2.  I can see the data in the data entry screen and using the browser option but nothing when I use the pivot table tool.  It is aggregate data and I have not set up indicators as yet so I am just running straightforward tables using the details option.
>  
> Any ideas as to the reason for this?
>  
> Regards,
>  
> Angela
>  
>  
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp