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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp

