Thanks Jason, I had some problems with doing the views via DHIS 2 so eventually did it externally. I will re-visit it though. Much appreciate your assistance. Regards, Angela
From: Jason Pickering [mailto:[email protected]] Sent: Thursday, November 24, 2016 6:25 AM To: Hinds, Ms. Angela (CAR) <[email protected]> Cc: DHIS Users <[email protected]>; DHIS 2 Developers list <[email protected]> Subject: Re: [Dhis2-users] [Dhis2-devs] No totals visible in the pivot table Hi Angela, You should created SQL views via the DHIS2 application. Go to Data Administration -> SQL Views and create your view there.See here<https://ci.dhis2.org/docs/master/en/user/html/dataAdmin_sqlView.html#d0e19320> for details. When the analytics process runs, it needs to drop certain resource tables. If these tables are linked to a view in the database, then the process fails. If you must have views directly on the database (and not created through the DHIS2 SQL View functionality) you need to be sure they do not reference resource tables, or alternatively, encapsulate the view in a PLPSQL function, so that they are not seen by the database. Regards, Jason On Thu, Nov 24, 2016 at 11:20 AM, Hinds, Ms. Angela (CAR) <[email protected]<mailto:[email protected]>> wrote: 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:[email protected]<mailto:[email protected]>] Sent: Wednesday, November 23, 2016 12:18 PM To: Hinds, Ms. Angela (CAR) <[email protected]<mailto:[email protected]>> Cc: DHIS Users <[email protected]<mailto:[email protected]>>; DHIS 2 Developers list <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> | 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) > <[email protected]<mailto:[email protected]>> 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 : > [email protected]<mailto:[email protected]> > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected]<mailto:[email protected]> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Jason P. Pickering email: [email protected]<mailto:[email protected]> tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
