Thanks, Bharath. I did try that. It didn't change anything. *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
On Fri, Jan 8, 2016 at 12:55 AM, Bharath <[email protected]> wrote: > > You may try Update category option combinations from Apps -> Data > Administration -> Maintenance > > Please have the backup before doing this or try it in local machine first. > > > On Fri, Jan 8, 2016 at 11:09 AM, Laura E. Lincks < > [email protected]> wrote: > >> 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 >> >> > > > -- > > Regards, > Bharath Kumar. Ch >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
