dhis2-users team mailing list archive

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

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.pickering@xxxxxxxxx]
Sent: Thursday, November 24, 2016 6:25 AM
To: Hinds, Ms. Angela (CAR) <hindsang@xxxxxxxxxx>
Cc: DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx>; DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
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) <hindsang@xxxxxxxxxx<mailto:hindsang@xxxxxxxxxx>> 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:dcocos@xxxxxxxxx<mailto:dcocos@xxxxxxxxx>]
Sent: Wednesday, November 23, 2016 12:18 PM
To: Hinds, Ms. Angela (CAR) <hindsang@xxxxxxxxxx<mailto:hindsang@xxxxxxxxxx>>
Cc: DHIS Users <dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>>; DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto: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<mailto: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<mailto: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<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>
tel:+46764147049