No totals visible in the pivot table

Support - Assistance technique
1

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

2

You have to run Analytics first, the last menu option on the left when you open the Reports module.

Regards,

Knut

···

On Wed, Nov 23, 2016 at 5:15 PM, Hinds, Ms. Angela (CAR) hindsang@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

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

–

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

3

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

4

Hi Angela,
You should created SQL views via the DHIS2 application. Go to Data Administration → SQL Views and create your view there.See here 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@carpha.org wrote:

On Nov 23, 2016, at 11:15 AM, Hinds, Ms. Angela (CAR) hindsang@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

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@gmail.com]

Sent: Wednesday, November 23, 2016 12:18 PM

To: Hinds, Ms. Angela (CAR) hindsang@CARPHA.ORG

Cc: DHIS Users dhis2-users@lists.launchpad.net; DHIS 2 Developers list 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

dcocos@baosystems.com | http://www.baosystems.com | 2900 K Street, Suite 404, Washington D.C. 20007

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

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

–

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

5

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

···

Hi Angela,

You should created SQL views via the DHIS2 application. Go to Data Administration → SQL Views and create your view there.See
here 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@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:dcocos@gmail.com]

Sent: Wednesday, November 23, 2016 12:18 PM

To: Hinds, Ms. Angela (CAR) hindsang@CARPHA.ORG

Cc: DHIS Users dhis2-users@lists.launchpad.net; DHIS 2 Developers list 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

dcocos@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) hindsang@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

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

–

Jason P. Pickering

email: jason.p.pickering@gmail.com

tel:+46764147049

6

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