← Back to team overview

dhis2-users team mailing list archive

Re: financial year reporting


I am running 2.27

 The _peroidstructure table seems fine to me.


Again, it just sees like some records just aren't being generated for the analytic tables. Where it's working I get two records, one for the financial year one for the annual year.


Where it's not working I only get the entry for the annual year.


Any help here would be really appreciated.


Sent from Outlook<http://aka.ms/weboutlook>

From: Lars Helge Øverland <lars@xxxxxxxxx>
Sent: Thursday, October 5, 2017 3:05 AM
To: Adam Preston
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] financial year reporting

Hi Adam,

that is strange. Which version of DHIS 2 are you running?

Also, could you have a loo in table _periodstructure and see how those quarters are linked to the financial year (see the column headers which are equal to analytics tables) ?



On Thu, Oct 5, 2017 at 1:16 AM, Adam Preston <adam704a@xxxxxxxxxxx<mailto:adam704a@xxxxxxxxxxx>> wrote:
A little more information here:

In the database, I found that in the analytic tables the financialoct field was blank.  Where its working I see that that field is set to '2013Oct' or whatever year. Do I need to configured something so that these analytic tables are generated right?

Sent from Outlook<http://aka.ms/weboutlook>

From: Dhis2-users <dhis2-users-bounces+adam704a=hotmail.com@xxxxxxxxxxxxxxxxxxx<mailto:hotmail.com@xxxxxxxxxxxxxxxxxxx>> on behalf of Adam Preston <adam704a@xxxxxxxxxxx<mailto:adam704a@xxxxxxxxxxx>>
Sent: Wednesday, October 4, 2017 3:14 PM
To: dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: [Dhis2-users] financial year reporting


I am seeing some unexpected results when running reports using the financial year period. When running a regular quarterly report everything looks fine


but when running the same report but with the financial year (start october) period the data is missing.


I have rebuilt the analytics tables (and cleared my cache) a few times, and it's still the same. Are there any tricks to get this working? Or am I doing something wrong?

Sent from Outlook<http://aka.ms/weboutlook>

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

Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland

PNG image

PNG image

PNG image

PNG image

PNG image

Follow ups