dhis2-users team mailing list archive

["Laura E. Lincks" <laura.lincks@xxxxxxxxxxxxxxxxx>]

DHIS version 2.19
Build 19144

We have an urgent issue which needs correction as soon as possible (we have
a reporting deadline of Monday, 11 January.):

We are collecting data via a Data Set/Data Entry screen for data elements
which are categorized by 2 genders and 8 age groups. Three of the age
categorizations for both genders are collecting the data via the data entry
screen properly but are showing up as blanks when included in a pivot
table. (The other 5 age groups for both genders are reporting properly in
the same pivot table.)

In looking at the data on the backend and querying the category option
combinations, resource tables and analytics tables I see that there are
multiple instances of many of the gender/age group categories. (For
example, there are 4 (Female, 0-1 years) category option combos.) The data
set and data entry screen are collecting the data properly but a no-longer
used version of the category option combo is being pulled into the
analytics table/pivot table for 3 of the 8 age groupings.

There is no error in the log when running Analytics.

The Data Set Report appears to display the proper data per the data entry
screen (i.e., it does not mimic the incomplete Pivot Table report.)

Is there a way to realign the category options so that what is used in the
data entry screen is what flows through to the analytics table? Or is there
a later build that corrects this problem?

Thank you.

*Laura E. Lincks*
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132