DHIS2: Having issues while trying to create reports/charts

Support - Assistance technique
1

Hi All,

I have done the following actions in first step, but cannot see data entered in Pivot Tables/Charts.

  1. Created DataElements
  2. Created Category Options
  3. Added a Category to include Category Options
  4. Created a Category Combination item to and added the category created in Step3 in it.
  5. Now updated the DataElements and assigned the Category Combination.
  6. Now created a DataSet with these DataElements and assigned to the 2. organization units.
  7. Using the DataEntry module the data is added successfully for desired time period and marked as completed.
    But when trying to create a report/chart for these DataElments or DataSets, I am getting the message that No Values found. However when trying to create reports/charts on Demo site, everything works fine.

Is there anything that I am missing where while performing all the above mentioned steps.

In later step I have even deployed the sample database on my machine.

DHIS2: V2.18 (Using dhis2-live.exe to run the application)

OS: Windows 7

DB: Postgres 9.4

  1. Selected DataEntry->
  2. Selected Sierra Leone->Bo->Badjia
  3. Selected Child Health as dataset and April 2015
  4. Clicked on the button “In-complete”
  5. Updated some of the values and now clicked on “Complete”.

Updated values are not appearing in Pivot Tables.

Do I have to update some table? run some script or function from to reflect the updates in pivot tables?

I got a response from one person that “Go to Reports. Run Analytics”, but I don’t have this option visible on my interface.

···

Regards,
Muhammad Tahir

2

Hi,

You need to run analytics, if you don’t see that as an option… it means you don’t have superuser rights.

Which user are you login in as? admin/district?

···

On Tue, May 12, 2015 at 2:20 PM, Muhammad Tahir mtagb09@gmail.com wrote:

Hi All,

I have done the following actions in first step, but cannot see data entered in Pivot Tables/Charts.

  1. Created DataElements
  2. Created Category Options
  3. Added a Category to include Category Options
  4. Created a Category Combination item to and added the category created in Step3 in it.
  5. Now updated the DataElements and assigned the Category Combination.
  6. Now created a DataSet with these DataElements and assigned to the 2. organization units.
  7. Using the DataEntry module the data is added successfully for desired time period and marked as completed.
    But when trying to create a report/chart for these DataElments or DataSets, I am getting the message that No Values found. However when trying to create reports/charts on Demo site, everything works fine.

Is there anything that I am missing where while performing all the above mentioned steps.

In later step I have even deployed the sample database on my machine.

DHIS2: V2.18 (Using dhis2-live.exe to run the application)

OS: Windows 7

DB: Postgres 9.4

  1. Selected DataEntry->
  2. Selected Sierra Leone->Bo->Badjia
  3. Selected Child Health as dataset and April 2015
  4. Clicked on the button “In-complete”
  5. Updated some of the values and now clicked on “Complete”.

Updated values are not appearing in Pivot Tables.

Do I have to update some table? run some script or function from to reflect the updates in pivot tables?

–
Regards,
Muhammad Tahir

I got a response from one person that “Go to Reports. Run Analytics”, but I don’t have this option visible on my interface.

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

–
Morten

3

Hi Morten,

User: admin

Password: district

DHIS2 : Version 2.18

OS: Windows7

DB: Postgres 9.4

Can you please share a screen shot of the available option? And isn’t the user “admin” a SuperUser ?

​Regards,

Muhammad Tahir

4

Hi Muhammad.

I suggest to run somme maintenance tasks on your database:

Menu “Data administration”, on the left, Maintenance, tick “click clean analytic tables” then run maintenance. You can also do the same thing for the other checkboxes.

You can also back to main menu and run browser cache.

Hope this will help.

Henri.

···

Le Mardi 12 mai 2015 8h20, Muhammad Tahir mtagb09@gmail.com a écrit :

Hi All,

I have done the following actions in first step, but cannot see data entered in Pivot Tables/Charts.

  1. Created DataElements
  2. Created Category Options
  3. Added a Category to include Category Options
  4. Created a Category Combination item to and added the category created in Step3 in it.
  5. Now updated the DataElements and assigned the Category Combination.
  6. Now created a DataSet with these DataElements and assigned to the 2. organization units.
  7. Using the DataEntry module the data is added successfully for desired time period and marked as completed.
    But when trying to create a report/chart for these DataElments or DataSets, I am getting the message that No Values found. However when trying to create reports/charts on Demo site, everything works fine.

Is there anything that I am missing where while performing all the above mentioned steps.

In later step I have even deployed the sample database on my machine.

DHIS2: V2.18 (Using dhis2-live.exe to run the application)

OS: Windows 7

DB: Postgres 9.4

  1. Selected DataEntry->
  2. Selected Sierra Leone->Bo->Badjia
  3. Selected Child Health as dataset and April 2015
  4. Clicked on the button “In-complete”
  5. Updated some of the values and now clicked on “Complete”.

Updated values are not appearing in Pivot Tables.

Do I have to update some table? run some script or function from to reflect the updates in pivot tables?

I got a response from one person that “Go to Reports. Run Analytics”, but I don’t have this option visible on my interface.

–
Regards,
Muhammad Tahir

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

5

Hi Morten,

Many thanks for your help, using user “system”, I was able to find and perform the analytics.

​Regards,

Muhammad Tahir

6

Hi Muhammad,

Did you run the analytics/datamarts? May be this can solve.

Best regards,

Joao

···

Hi All,

I have done the following actions in first step, but cannot see data entered in Pivot Tables/Charts.

  1. Created DataElements

  2. Created Category Options

  3. Added a Category to include Category Options

  4. Created a Category Combination item to and added the category created in Step3 in it.

  5. Now updated the DataElements and assigned the Category Combination.

  6. Now created a DataSet with these DataElements and assigned to the 2. organization units.

  7. Using the DataEntry module the data is added successfully for desired time period and marked as completed.

But when trying to create a report/chart for these DataElments or DataSets, I am getting the message that No Values found. However when trying to create reports/charts on Demo site, everything works fine.

Is there anything that I am missing where while performing all the above mentioned steps.

In later step I have even deployed the sample database on my machine.

DHIS2: V2.18 (Using dhis2-live.exe to run the application)

OS: Windows 7

DB: Postgres 9.4

  1. Selected DataEntry->

  2. Selected Sierra Leone->Bo->Badjia

  3. Selected Child Health as dataset and April 2015

  4. Clicked on the button “In-complete”

  5. Updated some of the values and now clicked on “Complete”.

Updated values are not appearing in Pivot Tables.

Do I have to update some table? run some script or function from to reflect the updates in pivot tables?

I got a response from one person that “Go to Reports. Run Analytics”, but I don’t have this option visible on my interface.

–

Regards,

Muhammad Tahir

7

I think the admin user may have some restriction …will look into it.

But you could start from an empty database instead (just create the db in PgAdmin and change the name in hibernate.properties. Then restart)

Knut

···

On Tue, May 12, 2015 at 9:39 AM, Joao Mazuze Joao_Mazuze@chasssmt.com wrote:

Hi Muhammad,

Did you run the analytics/datamarts? May be this can solve.

Best regards,

Joao

From: Dhis2-users [mailto:dhis2-users-bounces+joao_mazuze=chasssmt.com@lists.launchpad.net] On Behalf Of Muhammad Tahir

Sent: 12 May 2015 09:21

To: dhis2-users

Cc: dhis2-devs

Subject: [Dhis2-users] DHIS2: Having issues while trying to create reports/charts

Hi All,

I have done the following actions in first step, but cannot see data entered in Pivot Tables/Charts.

  1. Created DataElements
  2. Created Category Options
  3. Added a Category to include Category Options
  4. Created a Category Combination item to and added the category created in Step3 in it.
  5. Now updated the DataElements and assigned the Category Combination.
  6. Now created a DataSet with these DataElements and assigned to the 2. organization units.
  7. Using the DataEntry module the data is added successfully for desired time period and marked as completed.
    But when trying to create a report/chart for these DataElments or DataSets, I am getting the message that No Values found. However when trying to create reports/charts on Demo site, everything works fine.

Is there anything that I am missing where while performing all the above mentioned steps.

In later step I have even deployed the sample database on my machine.

DHIS2: V2.18 (Using dhis2-live.exe to run the application)

OS: Windows 7

DB: Postgres 9.4

  1. Selected DataEntry->
  2. Selected Sierra Leone->Bo->Badjia
  3. Selected Child Health as dataset and April 2015
  4. Clicked on the button “In-complete”
  5. Updated some of the values and now clicked on “Complete”.

Updated values are not appearing in Pivot Tables.

Do I have to update some table? run some script or function from to reflect the updates in pivot tables?

I got a response from one person that “Go to Reports. Run Analytics”, but I don’t have this option visible on my interface.

–

Regards,

Muhammad Tahir

This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.

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

8

Hi Knut,

Many thanks for your time and pointing out the correct option for utilization.

I have able to find the option with user “system”.

···

On Tue, May 12, 2015 at 12:58 PM, Knut Staring knutst@gmail.com wrote:

I think the admin user may have some restriction …will look into it.

But you could start from an empty database instead (just create the db in PgAdmin and change the name in hibernate.properties. Then restart)

Knut

–

On Tue, May 12, 2015 at 9:39 AM, Joao Mazuze Joao_Mazuze@chasssmt.com wrote:

Hi Muhammad,

Did you run the analytics/datamarts? May be this can solve.

Best regards,

Joao

From: Dhis2-users [mailto:dhis2-users-bounces+joao_mazuze=chasssmt.com@lists.launchpad.net] On Behalf Of Muhammad Tahir

Sent: 12 May 2015 09:21

To: dhis2-users

Cc: dhis2-devs

Subject: [Dhis2-users] DHIS2: Having issues while trying to create reports/charts

Hi All,

I have done the following actions in first step, but cannot see data entered in Pivot Tables/Charts.

  1. Created DataElements
  2. Created Category Options
  3. Added a Category to include Category Options
  4. Created a Category Combination item to and added the category created in Step3 in it.
  5. Now updated the DataElements and assigned the Category Combination.
  6. Now created a DataSet with these DataElements and assigned to the 2. organization units.
  7. Using the DataEntry module the data is added successfully for desired time period and marked as completed.
    But when trying to create a report/chart for these DataElments or DataSets, I am getting the message that No Values found. However when trying to create reports/charts on Demo site, everything works fine.

Is there anything that I am missing where while performing all the above mentioned steps.

In later step I have even deployed the sample database on my machine.

DHIS2: V2.18 (Using dhis2-live.exe to run the application)

OS: Windows 7

DB: Postgres 9.4

  1. Selected DataEntry->
  2. Selected Sierra Leone->Bo->Badjia
  3. Selected Child Health as dataset and April 2015
  4. Clicked on the button “In-complete”
  5. Updated some of the values and now clicked on “Complete”.

Updated values are not appearing in Pivot Tables.

Do I have to update some table? run some script or function from to reflect the updates in pivot tables?

I got a response from one person that “Go to Reports. Run Analytics”, but I don’t have this option visible on my interface.

–

Regards,

Muhammad Tahir

This message may contain privileged and confidential information intended solely for the addressee. Please do not read, disseminate or copy it unless you are the intended recipient. If this message has been received in error, we kindly ask that you notify the sender immediately by return email and delete all copies of the message from your system.

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

–

Regards,
Muhammad Tahir