Aggregate periods not available in datamart, report tables and dataset report

Bug #375989 reported by Ola Hodne Titlestad on 2009-05-13
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
DHIS
High
Lars Helge Øverland

Bug Description

The system does not pre-generate periods, but instead creates them when they are needed to store a new value, either via data entry or data import.

In a system where data is entered or imported monthly only, which is quite common, there would e.g. be no quarterly periods available in the database. When you want to use or export aggregated values by quarter there is no way to select these quarterly periods in either datamart or report table GUI since they do not appear in the available period lists in the select boxes, simply because they do not exist.

We need some kind of mechanism to allow "output" modules like datamart and report tables to create and use periods when generating aggregated data.

Right now this inconsistency is blocking the users from analysing and presenting data on aggregated periods.

Changed in dhis2:
importance: Undecided → High
milestone: none → 2.0.1
Changed in dhis2:
milestone: 2.0.1 → 2.0.2
Changed in dhis2:
assignee: nobody → Bob Jolliffe (bobjolliffe)
Changed in dhis2:
milestone: 2.0.2 → 2.0.3
Changed in dhis2:
milestone: 2.0.3 → 2.0.4

This seems to be the same limitation as I highlighted in that long
mail I wrote the other day, namely a lack of aggregation rules within
dimensions. If we had a general service, to allow one to define
aggregation rules for dimension elements, it would seem to be a major
step forward. I do not know if this is how you are planning on
addressing this.

For instance, if we could implement rules (which implies a hierarchy) such as

Quarter 1 = Jan + Feb + March
Quarter 2 = April + May + June

we should also be able to implement..

Province = District 1 + District 2 + District 3 ..

in the same way.

Right now, the "orgunit" rule is pretty much hardcoded; the sum of all
child dimensional elements in an orgunit hierarchy are aggregated to
the parent.

If the functionality of dimensional aggregation was generalized
somehow, we should be able to apply these rules to any dimension.

I guess it is easy to visualize, but would likely require a large refactor.

JPP

2009/11/2 Lars Helge Øverland <email address hidden>:
> ** Changed in: dhis2
>    Milestone: 2.0.3 => 2.0.4
>
> --
> Aggregate periods not available in datamart or report tables
> https://bugs.launchpad.net/bugs/375989
> 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:
> The system does not pre-generate periods, but instead creates them when they are needed to store a new value, either via data entry or data import.
>
> In a system where data is entered or imported monthly only, which is quite common, there would e.g. be no quarterly periods available in the database. When you want to use or export aggregated values by quarter there is no way to select these quarterly periods in either datamart or report table GUI since they do not appear in the available period lists in the select boxes, simply because they do not exist.
>
> We need some kind of mechanism to allow "output" modules like datamart and report tables to create and use periods when generating aggregated data.
>
> Right now this inconsistency is blocking the users from analysing and presenting data on aggregated periods.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : <email address hidden>
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

Changed in dhis2:
status: New → Confirmed
Changed in dhis2:
assignee: Bob Jolliffe (bobjolliffe) → nobody
milestone: 2.0.4 → 2.0.5
Changed in dhis2:
assignee: nobody → Lars Helge Øverland (larshelge)
summary: - Aggregate periods not available in datamart or report tables
+ Aggregate periods not available in datamart, report tables and dataset
+ report
Changed in dhis2:
status: Confirmed → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers