2009/9/26 Lars Helge Ă˜verland <larshe...@gmail.com> > > > On Sat, Sep 26, 2009 at 9:12 AM, Jason Pickering < > jason.p.picker...@gmail.com> wrote: > >> >> I am very sure about this and have discussed with Jan separately that >> blank values are reported/displayed as 0 on maps. >> >> I will see if I can dig out the discussion. >> >> > > Jason is right in that missing values are displayed in report tables and > GIS as 0s. > > Regarding storage in the database, we have 1. a system setting which > decides whether to store 0s in the raw data value table and 2. a system > setting which decides whether to write 0s to the aggregated indicator value > table during datamart. > > Lars > > > The problem is that aggregated data values get converted from blank to 0 values as well, not only indicator numerators. Don't understand how these settings can change that.
But Jason, the main storage of data values (DataValue) does not create 0s for blank values, it is in the data mart (copy of data used for reports. GIS etc.) that this happens. Basically this means that the main data storage is not compromised and a small fix to the data mart procedure would fix this (also on all existing data). Ola ---------- > _______________________________________________ > Mailing list: > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> > More help : https://help.launchpad.net/ListHelp > > -- Blanks are displayed as 0 in report https://bugs.launchpad.net/bugs/436692 You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. Status in DHIS 2 - District Health Information Software: New Bug description: Blank values are converted to 0s in the report. _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp