dhis2-users team mailing list archive

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

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 <chbharathk@xxxxxxxxx> 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 <
> laura.lincks@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
>
> Regards,
> Bharath Kumar. Ch
>