I just ran a Data Integrity check in the Data Maintenance app and see that this issue is violating the following: Category option combos not in data element category combo in data entry form
*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:39 AM, Laura E. Lincks < laura.lin...@icap.columbia.edu> 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 : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp