← Back to team overview

dhis2-users team mailing list archive

Re: financial year reporting

 

Never mind. I'm an idiot.
Turns out I wasn't loading in the FY data.

[cid:7ad1231b-62d3-4ffb-bc97-d70a74eb96aa]


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

________________________________
From: Dhis2-users <dhis2-users-bounces+adam704a=hotmail.com@xxxxxxxxxxxxxxxxxxx> on behalf of Adam Preston <adam704a@xxxxxxxxxxx>
Sent: Thursday, October 12, 2017 3:59 PM
To: Lars Helge Øverland
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] financial year reporting


I just tried again with 2.28....same thing.


One other note, the data element I am having a problem with is entered on an annual basis and I am wanting to report this on a FY (starting October) basis. I feel like this has something to do with it.


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

________________________________
From: Dhis2-users <dhis2-users-bounces+adam704a=hotmail.com@xxxxxxxxxxxxxxxxxxx> on behalf of Adam Preston <adam704a@xxxxxxxxxxx>
Sent: Thursday, October 12, 2017 12:16 PM
To: Lars Helge Øverland
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] financial year reporting


I am running 2.27

 The _peroidstructure table seems fine to me.

[cid:8e50091c-5044-4502-a256-1eaf00dfed2c]

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.

[cid:5caef9aa-391d-4aed-8146-b46b8da51324]


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

[cid:335773ef-3972-48fd-b705-666e0a663492]

Any help here would be really appreciated.

-Adam


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) ?

regards,

Lars


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

Hi

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

[cid:5c860ab0-1eeb-4fc4-91da-41ab0a370a61]


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


[cid:61036da3-4b14-4563-8c27-4443717fb3e4]


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
lars@xxxxxxxxx<mailto:lars@xxxxxxxxx>
http://www.dhis2.org<https://www.dhis2.org/>

PNG image

PNG image

PNG image

PNG image

PNG image

GIF image


Follow ups

References