← Back to team overview

dhis2-devs team mailing list archive

Re: Aggregating values

 

2010/7/12 Jason Pickering <jason.p.pickering@xxxxxxxxx>

> Hi Lars,
> Well, yes and no. If the resource tables (namely orgunitstructure) is
> not generated, it would not be possible to assign any orgunits to a
> given data mart/report table?


The orgunitstructure table is just a resource table intended to be used by
3rd party tools which is not used internally in the system (maybe for the
databrowser after you and Hieu changed it?).


> Likewise, if the orgunit levels have not
> been defined, it is also not possible to assign any orgunits to a
> given report table/datamart, or perhaps I am just hallucinating ?


That is true, but I wouldn't call the orgunit levels a resource table per
se, it has a belonging object in the model and is used internally (even if
you very well might use it in query).


> I
> have run into this problem several times actually when creating new
> databases. Ideally, the orgunitstructure table should be regenerated
> when there have been changes to the orgunit hierarchy and users should
> be warned that it is not possible to create a report table/datamart
> without first defining orgunit level names.
>

Agree that we could have some sort of integrated "required setup guide" in
the system...


>
> Regards,
> Jason
>
>
> 2010/7/12 Lars Helge Øverland <larshelge@xxxxxxxxx>:
> > Generating any of the resource tables don't affect the aggregation /
> > report tables...
> >
> >
> >
> > On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto <orvaquim@xxxxxxxxx>
> wrote:
> >> Thanks!!!
> >>
> >> Caveman
> >>
> >>
> >> On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering
> >> <jason.p.pickering@xxxxxxxxx> wrote:
> >>>
> >>> A very common mistake is not having generated the resource tables,
> >>> namely "orgunitstructure". Consult the documentation for more details
> >>> on how to generate these tables.
> >>>
> >>> Regards,
> >>> Jason
> >>>
> >>>
> >>> On Sun, Jul 11, 2010 at 4:27 PM, Orvalho Augusto <orvaquim@xxxxxxxxx>
> >>> wrote:
> >>> > I have a dataelement collected at a Health Centre level (eg:
> ats_posfem)
> >>> > in
> >>> > one province and only in some particular districts. In unpredictible
> >>> > future
> >>> > at National level we will be collecting on every health centre.
> >>> >
> >>> > Now, my ignorance: How can I obtain the provincial total on Report
> >>> > Table? I
> >>> > have been battled with DHIS so far and nothing.
> >>> >
> >>> > Thanks guys
> >>> > Caveman
> >>> >
> >>> >
> >>> > _______________________________________________
> >>> > Mailing list: https://launchpad.net/~dhis2-devs
> >>> > Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >>> > Unsubscribe : https://launchpad.net/~dhis2-devs
> >>> > More help   : https://help.launchpad.net/ListHelp
> >>> >
> >>> >
> >>>
> >>>
> >>>
> >>> --
> >>> --
> >>> Jason P. Pickering
> >>> email: jason.p.pickering@xxxxxxxxx
> >>> tel:+260968395190
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> Mailing list: https://launchpad.net/~dhis2-devs
> >> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> >> Unsubscribe : https://launchpad.net/~dhis2-devs
> >> More help   : https://help.launchpad.net/ListHelp
> >>
> >>
> >
>
>
>
> --
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260968395190
>

References