← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Can't roll up

 

2010/6/7 Friedman, Roger (CDC/OID/NCHHSTP) (CTR) <rdf4@xxxxxxx>

>  Thanks, Ola.  I have cleared the hierarchy history through the menu.
>
> Thanks, Lars.  I got hung up in the failure of the resource tables
> operation and didn't try clearing the history.
>
> For my information, in what table is the hierarchy history?  And what
> function does it perform in relation to the rollup?  Is this an effort to
> automatically account for changes in the hierarchy when doing roll-ups?
>
Exactly.

This function is used to represent the organisation unit hierarchy in the
aggregation process and, if empty/messy, will cause the hierarchy
aggregation to be non-functional. Will make this more robust for the next
version.

Lars


> There have been frequent hierarchy changes in Ghana (almost all district
> splits), a problem which I have put on the shelf until I get basic
> functionality.
>
>
>




>  *From:* Ola Hodne Titlestad [mailto:olatitle@xxxxxxxxx]
> *Sent:* Monday, June 07, 2010 8:30 AM
> *To:* Lars Helge Øverland
> *Cc:* Jason Pickering; dhis2-users@xxxxxxxxxxxxxxxxxxx; Friedman, Roger
> (CDC/OID/NCHHSTP) (CTR); DHIS 2 developers
> *Subject:* Re: [Dhis2-devs] [Dhis2-users] Can't roll up
>
>
>
> Hi,
>
> Using the same database as Roger I managed to reproduce this problem and
> found that the clearing the hierarchy history as suggested by Lars, solved
> it.
>
> The problem was aggregation up the hierarchy from the raw data at district
> level to region or national, as all aggregates for orgunits above the
> district level were 0 in the report table.
>
> Apparently something has happened during the creation or later fixing of
> the orgunit hierarchy which has lead to a problem with the aggregation.
> Clearing the hierarchy history made the system rebuild the hierarchy
> structure again and then it worked.
>
> It is always good practice to clear the hierarchy history after finishing
> the initial customisation work as the history then is more a history of
> fixes and tweaking and not a real history of how the organisational
> structure has changed over time. This also speeds up the aggregation process
> as no history needs to be taken into account.
>
> Of course later when in production and real changes to the hierarchy are
> necessary to reflect real world changes then one should not clear the
> history after making such changes.....
>
> Lars might fill in more technical details as to how this problem happened.
>
> Ola
> ----------
>
> 2010/6/4 Lars Helge Øverland <larshelge@xxxxxxxxx>
>
>
>
> On Fri, Jun 4, 2010 at 7:37 AM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
> Hi Roger,
>
> Ola will probably be able help a bit more with this, but just a few
> things to check.
>
> Have all the resource tables been built? Maintenance->Resource tables
>
>
>
>
>
> Hi Roger,
>
>
>
> also try going to data administration -> maintenance -> clear hierarchy
> history.
>
>
>
> Lars
>
>
>
>
>
>
> Regards,
> Jason
>
>
>
>
>
>
> On Thu, Jun 3, 2010 at 10:28 PM, Friedman, Roger (CDC/OID/NCHHSTP)
> (CTR) <rdf4@xxxxxxx> wrote:
> > No matter what I do, I can't get my data to roll up.  Here is the log
> from
> > my latest effort, using a dimension report.  All the headers are correct,
> > all the periods are correct, there are the right number of rows in the
> > _report table, it's just that all numbers are 0.  When I look at
> > aggregateddatavalue, only one of the two periods is there, only 2 of 11
> > organization units is there, all 44 categoryoptioncomboids are there.
> >
> > <<ReportLog1.log>>
> >
>
> > _______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-users<https://launchpad.net/%7Edhis2-users>
> > Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~dhis2-users<https://launchpad.net/%7Edhis2-users>
> > More help   : https://help.launchpad.net/ListHelp
> >
> >
>
>
>
> --
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260968395190
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>
>

References