Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Lars Helge Øverland]

Hi Hannan,

is this for February 2016? If so I suspect this is a leap-year issue (and
not an issue for other periods). We can look into it but this might not be
critical..

regards,

Lars

On Sun, Mar 27, 2016 at 8:56 AM, Hannan Khan  wrote:

> Dear Lars
>
> The problem in this thread arise again. That problem was fixed in the
> trunk and suppose to reflect in the later versions. Can you please check
> this issue and find a solution as soon as possible.
>
> We using version 2.22 build 21827.
>
> Regards
>
> Hannan Khan
> HISP Bangladesh
>
>
> On Sat, Jul 4, 2015 at 4:55 PM, Uddin Fatema  wrote:
>
>> Dear Lars,
>>
>> Thank you very much. I am really happy that 2.19 is working fine. Time
>> zone problem solved and aggregated data problem also solved.
>>
>> Again thanks a lot for you and core teams hard work.
>>
>> Best Regards
>>
>> Fatema
>>
>> On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema 
>> wrote:
>>
>>> Dear Lars,
>>>
>>> Here I attached the Error Log file
>>>
>>> Thanks in advance
>>>
>>> On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema 
>>> wrote:
>>>
 Dear Lars,

 Thanks a lot

 I just download 2.18 branch code and build the war file. Now i am
 running my database with this war file with UTC +6 Dhaka time zone  but
 still shows same error.

 Is it cash problem or anything else.

 On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland <
 larshe...@gmail.com> wrote:

> Hi Fatema,
>
> we have made a fix to prevent time zone issues for resource table
> generation in 2.18 and 2.19 now.
>
> regards,
>
> Lars
>
>
> On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema 
> wrote:
>
>> Yes Lars i found same error in 2.18 too.
>>
>> Actually I updated version in 2.18 in test server but still time zone
>> error remains for  (UTC+60 )Dhaka . You know that some time zone has time
>> zone problem in resource table generation. So I Changes time zone 
>> UTC+6:30)
>> Yaangoon) and update resource table and analytic.
>>
>> And still I found same error which is described me and Nayeem Al
>> Miftah.
>>
>> Thanks
>>
>> On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah <
>> n.mift...@gmail.com> wrote:
>>
>>> Dear Lars
>>> There are monthly datasets on which a data entry operator input 50
>>> in a cell. Analytic shows that same number as 51.7 in those months which
>>> have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less 
>>> value
>>> in February as it have 28 days.
>>>
>>> It has happened as the analytic table calculate the data as Ms.
>>> Fatema has described.
>>>
>>>
>>>
>>> Nayeem Al Mifthah
>>> HMIS Consultant
>>> Management Information System
>>> Directorate General of Health Services (DGHS), Bangladesh
>>> Supported by: UNICEF-Bangladesh
>>> Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
>>> Cell:+8801914030574
>>>
>>> On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland <
>>> larshe...@gmail.com> wrote:
>>>
 Hi Fatema,

 do you think you could explain a bit more about the data elements
 and calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema  wrote:

> Dear All,
>
>  Data Analytic table retrieve wrong data in Pivot table, data
> visualizer and GIS  and same error remain 2.17 and 2.16 too
>
> Here i attach screen short of Pivote Table Analysis and Data Entry
> Screen
>
>
> In pivote table value shows =  51.7
>
> but originally  dataentry screen shows  = 50
>
> Calculation
> it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
> But it should do  daysxvalue/daysno  = 50*31/31 =50
>
>
> Please have a look on it.
>
>
> Thanks
>
>
> Fatema
> --- Forwarded message --
> rom: Uddin Fatema 
> Date: Tue, May 5, 2015 at 5:56 PM
> Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in
> Pivot table, data visualizer and GIS.
> To: Jan Henrik Øverland 
>
>
> Dear Jan,
>
> DHIS2 2.16 analytics (pivote table, data-visualizer and gis
> mapping retrieve wrong data from Analytics_2015 or all analytics 
> table.
>
> The problem is in analytics table it store daysxvalue , daysno and
> value
> column but when it retrieve data for pivote table, 

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Hannan Khan]

Ok. But can it be solved? It will appear in the next leap-year.

DHIS2 is an excellent work done by all of you (and us) and we are hesitant
to say all users that it's DHIS2's fault.

Regards

Hannan

On Tue, Mar 29, 2016 at 3:58 PM, Lars Helge Øverland  wrote:

> Hi Hannan,
>
> is this for February 2016? If so I suspect this is a leap-year issue (and
> not an issue for other periods). We can look into it but this might not be
> critical..
>
> regards,
>
> Lars
>
> On Sun, Mar 27, 2016 at 8:56 AM, Hannan Khan  wrote:
>
>> Dear Lars
>>
>> The problem in this thread arise again. That problem was fixed in the
>> trunk and suppose to reflect in the later versions. Can you please check
>> this issue and find a solution as soon as possible.
>>
>> We using version 2.22 build 21827.
>>
>> Regards
>>
>> Hannan Khan
>> HISP Bangladesh
>>
>>
>> On Sat, Jul 4, 2015 at 4:55 PM, Uddin Fatema  wrote:
>>
>>> Dear Lars,
>>>
>>> Thank you very much. I am really happy that 2.19 is working fine. Time
>>> zone problem solved and aggregated data problem also solved.
>>>
>>> Again thanks a lot for you and core teams hard work.
>>>
>>> Best Regards
>>>
>>> Fatema
>>>
>>> On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema 
>>> wrote:
>>>
 Dear Lars,

 Here I attached the Error Log file

 Thanks in advance

 On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema 
 wrote:

> Dear Lars,
>
> Thanks a lot
>
> I just download 2.18 branch code and build the war file. Now i am
> running my database with this war file with UTC +6 Dhaka time zone  but
> still shows same error.
>
> Is it cash problem or anything else.
>
> On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland <
> larshe...@gmail.com> wrote:
>
>> Hi Fatema,
>>
>> we have made a fix to prevent time zone issues for resource table
>> generation in 2.18 and 2.19 now.
>>
>> regards,
>>
>> Lars
>>
>>
>> On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema 
>> wrote:
>>
>>> Yes Lars i found same error in 2.18 too.
>>>
>>> Actually I updated version in 2.18 in test server but still time
>>> zone error remains for  (UTC+60 )Dhaka . You know that some time zone 
>>> has
>>> time zone problem in resource table generation. So I Changes time zone
>>> UTC+6:30) Yaangoon) and update resource table and analytic.
>>>
>>> And still I found same error which is described me and Nayeem Al
>>> Miftah.
>>>
>>> Thanks
>>>
>>> On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah <
>>> n.mift...@gmail.com> wrote:
>>>
 Dear Lars
 There are monthly datasets on which a data entry operator input 50
 in a cell. Analytic shows that same number as 51.7 in those months 
 which
 have 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less 
 value
 in February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms.
 Fatema has described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland <
 larshe...@gmail.com> wrote:

> Hi Fatema,
>
> do you think you could explain a bit more about the data elements
> and calculation?
>
> Do you think you cold try with 2.18 / 2.19 ?
>
> regards,
>
> Lars
>
>
>
> On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema <
> fatema...@gmail.com> wrote:
>
>> Dear All,
>>
>>  Data Analytic table retrieve wrong data in Pivot table, data
>> visualizer and GIS  and same error remain 2.17 and 2.16 too
>>
>> Here i attach screen short of Pivote Table Analysis and Data
>> Entry Screen
>>
>>
>> In pivote table value shows =  51.7
>>
>> but originally  dataentry screen shows  = 50
>>
>> Calculation
>> it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
>> But it should do  daysxvalue/daysno  = 50*31/31 =50
>>
>>
>> Please have a look on it.
>>
>>
>> Thanks
>>
>>
>> Fatema
>> --- Forwarded message --
>> rom: Uddin Fatema 
>> Date: Tue, May 5, 2015 at 5:56 PM
>> Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in
>> Pivot table, data 

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Uddin Fatema]

Dear Lars,

Thank you very much. I am really happy that 2.19 is working fine. Time zone
problem solved and aggregated data problem also solved.

Again thanks a lot for you and core teams hard work.

Best Regards

Fatema

On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema fatema...@gmail.com wrote:

 Dear Lars,

 Here I attached the Error Log file

 Thanks in advance

 On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema fatema...@gmail.com wrote:

 Dear Lars,

 Thanks a lot

 I just download 2.18 branch code and build the war file. Now i am running
 my database with this war file with UTC +6 Dhaka time zone  but still shows
 same error.

 Is it cash problem or anything else.

 On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshe...@gmail.com
  wrote:

 Hi Fatema,

 we have made a fix to prevent time zone issues for resource table
 generation in 2.18 and 2.19 now.

 regards,

 Lars


 On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Yes Lars i found same error in 2.18 too.

 Actually I updated version in 2.18 in test server but still time zone
 error remains for  (UTC+60 )Dhaka . You know that some time zone has time
 zone problem in resource table generation. So I Changes time zone UTC+6:30)
 Yaangoon) and update resource table and analytic.

 And still I found same error which is described me and Nayeem Al Miftah.

 Thanks

 On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com
  wrote:

 Dear Lars
 There are monthly datasets on which a data entry operator input 50 in
 a cell. Analytic shows that same number as 51.7 in those months which have
 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
 February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms. Fatema
 has described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements and
 calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data
 visualizer and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry
 Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
 table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and
 value
 column but when it retrieve data for pivote table, data-visualizer
 and gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows
 wrong data.

 Could you please solved it additionally, can you please tell me in
 source code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : 

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Lars Helge Øverland]

Thanks Fatema, that's great news.

best regards,

Lars


On Sat, Jul 4, 2015 at 12:55 PM, Uddin Fatema fatema...@gmail.com wrote:

 Dear Lars,

 Thank you very much. I am really happy that 2.19 is working fine. Time
 zone problem solved and aggregated data problem also solved.

 Again thanks a lot for you and core teams hard work.

 Best Regards

 Fatema

 On Wed, Jun 24, 2015 at 4:11 PM, Uddin Fatema fatema...@gmail.com wrote:

 Dear Lars,

 Here I attached the Error Log file

 Thanks in advance

 On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear Lars,

 Thanks a lot

 I just download 2.18 branch code and build the war file. Now i am
 running my database with this war file with UTC +6 Dhaka time zone  but
 still shows same error.

 Is it cash problem or anything else.

 On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 Hi Fatema,

 we have made a fix to prevent time zone issues for resource table
 generation in 2.18 and 2.19 now.

 regards,

 Lars


 On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Yes Lars i found same error in 2.18 too.

 Actually I updated version in 2.18 in test server but still time zone
 error remains for  (UTC+60 )Dhaka . You know that some time zone has time
 zone problem in resource table generation. So I Changes time zone 
 UTC+6:30)
 Yaangoon) and update resource table and analytic.

 And still I found same error which is described me and Nayeem Al
 Miftah.

 Thanks

 On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah 
 n.mift...@gmail.com wrote:

 Dear Lars
 There are monthly datasets on which a data entry operator input 50 in
 a cell. Analytic shows that same number as 51.7 in those months which 
 have
 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
 February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms.
 Fatema has described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements
 and calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data
 visualizer and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry
 Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in
 Pivot table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and
 value
 column but when it retrieve data for pivote table, data-visualizer
 and gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows
 wrong data.

 Could you please solved it additionally, can you please tell me in
 source code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Uddin Fatema]

Dear Lars,

Here I attached the Error Log file

Thanks in advance

On Tue, Jun 23, 2015 at 4:30 PM, Uddin Fatema fatema...@gmail.com wrote:

 Dear Lars,

 Thanks a lot

 I just download 2.18 branch code and build the war file. Now i am running
 my database with this war file with UTC +6 Dhaka time zone  but still shows
 same error.

 Is it cash problem or anything else.

 On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshe...@gmail.com
 wrote:

 Hi Fatema,

 we have made a fix to prevent time zone issues for resource table
 generation in 2.18 and 2.19 now.

 regards,

 Lars


 On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Yes Lars i found same error in 2.18 too.

 Actually I updated version in 2.18 in test server but still time zone
 error remains for  (UTC+60 )Dhaka . You know that some time zone has time
 zone problem in resource table generation. So I Changes time zone UTC+6:30)
 Yaangoon) and update resource table and analytic.

 And still I found same error which is described me and Nayeem Al Miftah.

 Thanks

 On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com
 wrote:

 Dear Lars
 There are monthly datasets on which a data entry operator input 50 in a
 cell. Analytic shows that same number as 51.7 in those months which have 31
 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
 February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms. Fatema
 has described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements and
 calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data
 visualizer and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry
 Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
 table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and
 value
 column but when it retrieve data for pivote table, data-visualizer
 and gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows
 wrong data.

 Could you please solved it additionally, can you please tell me in
 source code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp





 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Lars Helge Øverland]

Hi Fatema,

I have made a fix for the problem with inaccurate aggregate values for data
elements with average aggregation operator (e.g. 51.7 instead of 50) now in
trunk and 2.19.

New build is available from https://www.dhis2.org/downloads in 40 minutes.

regards,

Lars


On Tue, Jun 23, 2015 at 12:48 PM, Lars Helge Øverland larshe...@gmail.com
wrote:

 Okay. Can can you please

 - provide the output of the tomcat log for when it fails

 - try by downloading 2.18 from https://www.dhis2.org/downloads to rule
 out build issues


 regards,

 Lars


 On Tue, Jun 23, 2015 at 12:30 PM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear Lars,

 Thanks a lot

 I just download 2.18 branch code and build the war file. Now i am running
 my database with this war file with UTC +6 Dhaka time zone  but still shows
 same error.

 Is it cash problem or anything else.

 On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshe...@gmail.com
  wrote:

 Hi Fatema,

 we have made a fix to prevent time zone issues for resource table
 generation in 2.18 and 2.19 now.

 regards,

 Lars


 On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Yes Lars i found same error in 2.18 too.

 Actually I updated version in 2.18 in test server but still time zone
 error remains for  (UTC+60 )Dhaka . You know that some time zone has time
 zone problem in resource table generation. So I Changes time zone UTC+6:30)
 Yaangoon) and update resource table and analytic.

 And still I found same error which is described me and Nayeem Al Miftah.

 Thanks

 On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com
  wrote:

 Dear Lars
 There are monthly datasets on which a data entry operator input 50 in
 a cell. Analytic shows that same number as 51.7 in those months which have
 31 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
 February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms. Fatema
 has described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements and
 calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data
 visualizer and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry
 Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
 table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and
 value
 column but when it retrieve data for pivote table, data-visualizer
 and gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows
 wrong data.

 Could you please solved it additionally, can you please tell me in
 source code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org 

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Uddin Fatema]

Dear Lars,

Thanks a lot

I just download 2.18 branch code and build the war file. Now i am running
my database with this war file with UTC +6 Dhaka time zone  but still shows
same error.

Is it cash problem or anything else.

On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshe...@gmail.com
wrote:

 Hi Fatema,

 we have made a fix to prevent time zone issues for resource table
 generation in 2.18 and 2.19 now.

 regards,

 Lars


 On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Yes Lars i found same error in 2.18 too.

 Actually I updated version in 2.18 in test server but still time zone
 error remains for  (UTC+60 )Dhaka . You know that some time zone has time
 zone problem in resource table generation. So I Changes time zone UTC+6:30)
 Yaangoon) and update resource table and analytic.

 And still I found same error which is described me and Nayeem Al Miftah.

 Thanks

 On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com
 wrote:

 Dear Lars
 There are monthly datasets on which a data entry operator input 50 in a
 cell. Analytic shows that same number as 51.7 in those months which have 31
 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
 February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms. Fatema
 has described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements and
 calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data
 visualizer and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry
 Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
 table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and
 value
 column but when it retrieve data for pivote table, data-visualizer and
 gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows
 wrong data.

 Could you please solved it additionally, can you please tell me in
 source code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp





 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Lars Helge Øverland]

Okay. Can can you please

- provide the output of the tomcat log for when it fails

- try by downloading 2.18 from https://www.dhis2.org/downloads to rule out
build issues


regards,

Lars


On Tue, Jun 23, 2015 at 12:30 PM, Uddin Fatema fatema...@gmail.com wrote:

 Dear Lars,

 Thanks a lot

 I just download 2.18 branch code and build the war file. Now i am running
 my database with this war file with UTC +6 Dhaka time zone  but still shows
 same error.

 Is it cash problem or anything else.

 On Tue, Jun 23, 2015 at 2:22 AM, Lars Helge Øverland larshe...@gmail.com
 wrote:

 Hi Fatema,

 we have made a fix to prevent time zone issues for resource table
 generation in 2.18 and 2.19 now.

 regards,

 Lars


 On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Yes Lars i found same error in 2.18 too.

 Actually I updated version in 2.18 in test server but still time zone
 error remains for  (UTC+60 )Dhaka . You know that some time zone has time
 zone problem in resource table generation. So I Changes time zone UTC+6:30)
 Yaangoon) and update resource table and analytic.

 And still I found same error which is described me and Nayeem Al Miftah.

 Thanks

 On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com
 wrote:

 Dear Lars
 There are monthly datasets on which a data entry operator input 50 in a
 cell. Analytic shows that same number as 51.7 in those months which have 31
 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
 February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms. Fatema
 has described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland 
 larshe...@gmail.com wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements and
 calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data
 visualizer and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry
 Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
 table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and
 value
 column but when it retrieve data for pivote table, data-visualizer
 and gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows
 wrong data.

 Could you please solved it additionally, can you please tell me in
 source code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp





 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Lars Helge Øverland]

Hi Fatema,

we have made a fix to prevent time zone issues for resource table
generation in 2.18 and 2.19 now.

regards,

Lars


On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatema...@gmail.com wrote:

 Yes Lars i found same error in 2.18 too.

 Actually I updated version in 2.18 in test server but still time zone
 error remains for  (UTC+60 )Dhaka . You know that some time zone has time
 zone problem in resource table generation. So I Changes time zone UTC+6:30)
 Yaangoon) and update resource table and analytic.

 And still I found same error which is described me and Nayeem Al Miftah.

 Thanks

 On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com
 wrote:

 Dear Lars
 There are monthly datasets on which a data entry operator input 50 in a
 cell. Analytic shows that same number as 51.7 in those months which have 31
 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
 February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms. Fatema
 has described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshe...@gmail.com
  wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements and
 calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data
 visualizer and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry
 Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
 table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and value
 column but when it retrieve data for pivote table, data-visualizer and
 gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows wrong
 data.

 Could you please solved it additionally, can you please tell me in
 source code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp





 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org https://www.dhis2.org
___
Mailing 

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Lars Helge Øverland]

Okay thanks.

Could you let me know

- what is the data element value type and aggregation operator for the data
element for which you get this result?

- is it possible for you to privately share a login and a link to a
favorite?

regards,

Lars

On Wed, Jun 17, 2015 at 11:57 AM, Uddin Fatema fatema...@gmail.com wrote:

 Yes Lars i found same error in 2.18 too.

 Actually I updated version in 2.18 in test server but still time zone
 error remains for  (UTC+60 )Dhaka . You know that some time zone has time
 zone problem in resource table generation. So I Changes time zone UTC+6:30)
 Yaangoon) and update resource table and analytic.

 And still I found same error which is described me and Nayeem Al Miftah.

 Thanks

 On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com
 wrote:

 Dear Lars
 There are monthly datasets on which a data entry operator input 50 in a
 cell. Analytic shows that same number as 51.7 in those months which have 31
 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
 February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms. Fatema
 has described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshe...@gmail.com
  wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements and
 calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data
 visualizer and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry
 Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
 table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and value
 column but when it retrieve data for pivote table, data-visualizer and
 gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows wrong
 data.

 Could you please solved it additionally, can you please tell me in
 source code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp





 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




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

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Uddin Fatema]

Yes Lars i found same error in 2.18 too.

Actually I updated version in 2.18 in test server but still time zone error
remains for  (UTC+60 )Dhaka . You know that some time zone has time zone
problem in resource table generation. So I Changes time zone UTC+6:30)
Yaangoon) and update resource table and analytic.

And still I found same error which is described me and Nayeem Al Miftah.

Thanks

On Wed, Jun 17, 2015 at 3:44 PM, Nayeem Al Mifthah n.mift...@gmail.com
wrote:

 Dear Lars
 There are monthly datasets on which a data entry operator input 50 in a
 cell. Analytic shows that same number as 51.7 in those months which have 31
 days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
 February as it have 28 days.

 It has happened as the analytic table calculate the data as Ms. Fatema has
 described.



 Nayeem Al Mifthah
 HMIS Consultant
 Management Information System
 Directorate General of Health Services (DGHS), Bangladesh
 Supported by: UNICEF-Bangladesh
 Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
 Cell:+8801914030574

 On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshe...@gmail.com
 wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements and
 calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data visualizer
 and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
 table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and value
 column but when it retrieve data for pivote table, data-visualizer and
 gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows wrong
 data.

 Could you please solved it additionally, can you please tell me in
 source code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp





-- 
Regards,
*Fatema Uddin*

Technical Advisor (HIS)-Support to the Health Sector Program II
Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
German House
House 10/A-2, Road 90
Gulshan 2, Dhaka 1212, Bangladesh

T  +880 9666701000
F  +880 28823099
M +880 19 6206 4721
I   www.giz.de
https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f
___
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

Re: [Dhis2-devs] [Dhis2-users] dhis2 2.18, 2.17. 2.16 reporting Error. Please Help.

[Nayeem Al Mifthah]

Dear Lars
There are monthly datasets on which a data entry operator input 50 in a
cell. Analytic shows that same number as 51.7 in those months which have 31
days (Jan, Mar, May, July, Aug, Oct, Dec), Also it shows less value in
February as it have 28 days.

It has happened as the analytic table calculate the data as Ms. Fatema has
described.



Nayeem Al Mifthah
HMIS Consultant
Management Information System
Directorate General of Health Services (DGHS), Bangladesh
Supported by: UNICEF-Bangladesh
Email: n.mift...@gmail.com  | nay...@mis.dghs.gov.bd
Cell:+8801914030574

On Wed, Jun 17, 2015 at 3:19 PM, Lars Helge Øverland larshe...@gmail.com
wrote:

 Hi Fatema,

 do you think you could explain a bit more about the data elements and
 calculation?

 Do you think you cold try with 2.18 / 2.19 ?

 regards,

 Lars



 On Wed, Jun 17, 2015 at 11:06 AM, Uddin Fatema fatema...@gmail.com
 wrote:

 Dear All,

  Data Analytic table retrieve wrong data in Pivot table, data visualizer
 and GIS  and same error remain 2.17 and 2.16 too

 Here i attach screen short of Pivote Table Analysis and Data Entry Screen


 In pivote table value shows =  51.7

 but originally  dataentry screen shows  = 50

 Calculation
 it is dividing daysxvalue / 30 = 50* 31/30 = 51.7
 But it should do  daysxvalue/daysno  = 50*31/31 =50


 Please have a look on it.


 Thanks


 Fatema
 --- Forwarded message --
 rom: Uddin Fatema fatema...@gmail.com
 Date: Tue, May 5, 2015 at 5:56 PM
 Subject: DHIS2 2.16 Data Analytic table retrieve wrong data in Pivot
 table, data visualizer and GIS.
 To: Jan Henrik Øverland janhenrik.overl...@gmail.com


 Dear Jan,

 DHIS2 2.16 analytics (pivote table, data-visualizer and gis mapping
 retrieve wrong data from Analytics_2015 or all analytics table.

 The problem is in analytics table it store daysxvalue , daysno and value
 column but when it retrieve data for pivote table, data-visualizer and
 gis that time it is dividing daysxvalue / 30
 But it should do  daysxvalue/daysno

 As a result in pivot table, data visualizer and gis mapping shows wrong
 data.

 Could you please solved it additionally, can you please tell me in source
 code in which file i have to change.

 Thanks a lot in advance.

 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Regards,
 *Fatema Uddin*

 Technical Advisor (HIS)-Support to the Health Sector Program II
 Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH
 German House
 House 10/A-2, Road 90
 Gulshan 2, Dhaka 1212, Bangladesh

 T  +880 9666701000
 F  +880 28823099
 M +880 19 6206 4721
 I   www.giz.de
 https://owa.giz.de/owa/redir.aspx?C=mPQMujasE0-yL6Aa4ocPcnkcfUThJNEIi4h1DwsYjO3Ua20UR_COt6aTH1s4JIdR4p-jCoFsP6A.URL=http%3a%2f%2fwww.giz.de%2f




 --
 Lars Helge Øverland
 Lead developer, DHIS 2
 University of Oslo
 Skype: larshelgeoverland
 http://www.dhis2.org https://www.dhis2.org


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp


___
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