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:jason.p.picker...@gmail.com] Sent: Thursday, November 24, 2016 6:25 AM To: Hinds, Ms. Angela (CAR) <hinds...@carpha.org> Cc: DHIS Users <dhis2-us...@lists.launchpad.net>; DHIS 2 Developers list <dhis2-devs@lists.launchpad.net> 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) <hinds...@carpha.org<mailto:hinds...@carpha.org>> 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:dco...@gmail.com<mailto:dco...@gmail.com>] Sent: Wednesday, November 23, 2016 12:18 PM To: Hinds, Ms. Angela (CAR) <hinds...@carpha.org<mailto:hinds...@carpha.org>> Cc: DHIS Users <dhis2-us...@lists.launchpad.net<mailto:dhis2-us...@lists.launchpad.net>>; DHIS 2 Developers list <dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@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<mailto: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<mailto: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-devs@lists.launchpad.net<mailto:dhis2-devs@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-us...@lists.launchpad.net<mailto:dhis2-us...@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Jason P. Pickering email: jason.p.picker...@gmail.com<mailto:jason.p.picker...@gmail.com> tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
