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:dco...@gmail.com] Sent: Wednesday, November 23, 2016 12:18 PM To: Hinds, Ms. Angela (CAR) <hinds...@carpha.org> Cc: DHIS Users <dhis2-users@lists.launchpad.net>; DHIS 2 Developers list <dhis2-d...@lists.launchpad.net> 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 dco...@baosystems.com | 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) <hinds...@carpha.org> > 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-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp _______________________________________________ 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
