dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

Public bug reported:

Data validation is in practice not working with most DHIS2 instances
used in South Africa, due to the use of Category options to capture
daily data.

This design flaw is related to the similar constraint related to
indicators - which was resolved in 2.19 (indicators will now draw data
from ALL data records for a specific data element, UNLESS the
catoptioncomboid is specified).

Data Validation is actually not working AT ALL (or you get thousands of
"results" where left and right are both shown as zero) if the data
elements on the left and right do not have their catoptioncomboid
specified.

Note the following key concepts for a re-designed data validation
component:

1. If the user want only records with specific catoptioncomboid
included, those will be specified in the left/right rule.

2. If the user want all records for a specific data element to be
validated, then comparisons must be done across the spectrum of
catoptioncomboids BUT with the left and right side catoptioncomboids
being the same for each validation pair.

Example: we captured "Children under 5 years weighed" and "PHC headcount
under 5 years" on a daily basis in some facilities and on a monthly
total basis in other facilities. The validation rule says that the first
must be less than or equal to the latter. In this example, the
validation rule should validate the totals for those facilities
capturing monthly totals only, but it should also validate the daily
values for each day for the facilities that capture daily.

3. The validation rule processing must also include data captured at
different orghierarchy levels, because again in our case some facilities
capture data (monthly or daily) on a per facility basis (OU5) whereas
other facilities capture data on a per service point (OU6, consultation
rooms etc) basis - again either daily or monthly.

For any clarification, contact calle@xxxxxxxx

Best regards
Calle Hedberg
HISP-SA

** Affects: dhis2
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1468683

Title:
  Data Validation not working with multiple CatOptionComboIDs

Status in DHIS 2:
  New

Bug description:
  Data validation is in practice not working with most DHIS2 instances
  used in South Africa, due to the use of Category options to capture
  daily data.

  This design flaw is related to the similar constraint related to
  indicators - which was resolved in 2.19 (indicators will now draw data
  from ALL data records for a specific data element, UNLESS the
  catoptioncomboid is specified).

  Data Validation is actually not working AT ALL (or you get thousands
  of "results" where left and right are both shown as zero) if the data
  elements on the left and right do not have their catoptioncomboid
  specified.

  Note the following key concepts for a re-designed data validation
  component:

  1. If the user want only records with specific catoptioncomboid
  included, those will be specified in the left/right rule.

  2. If the user want all records for a specific data element to be
  validated, then comparisons must be done across the spectrum of
  catoptioncomboids BUT with the left and right side catoptioncomboids
  being the same for each validation pair.

  Example: we captured "Children under 5 years weighed" and "PHC
  headcount under 5 years" on a daily basis in some facilities and on a
  monthly total basis in other facilities. The validation rule says that
  the first must be less than or equal to the latter. In this example,
  the validation rule should validate the totals for those facilities
  capturing monthly totals only, but it should also validate the daily
  values for each day for the facilities that capture daily.

  3. The validation rule processing must also include data captured at
  different orghierarchy levels, because again in our case some
  facilities capture data (monthly or daily) on a per facility basis
  (OU5) whereas other facilities capture data on a per service point
  (OU6, consultation rooms etc) basis - again either daily or monthly.

  For any clarification, contact calle@xxxxxxxx

  Best regards
  Calle Hedberg
  HISP-SA

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1468683/+subscriptions