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? 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 ? 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.
Regards, Jason 2010/7/12 Lars Helge Øverland <larshe...@gmail.com>: > Generating any of the resource tables don't affect the aggregation / > report tables... > > > > On Sun, Jul 11, 2010 at 5:36 PM, Orvalho Augusto <orvaq...@gmail.com> wrote: >> Thanks!!! >> >> Caveman >> >> >> On Sun, Jul 11, 2010 at 5:03 PM, Jason Pickering >> <jason.p.picker...@gmail.com> 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 <orvaq...@gmail.com> >>> 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@lists.launchpad.net >>> > Unsubscribe : https://launchpad.net/~dhis2-devs >>> > More help : https://help.launchpad.net/ListHelp >>> > >>> > >>> >>> >>> >>> -- >>> -- >>> Jason P. Pickering >>> email: jason.p.picker...@gmail.com >>> tel:+260968395190 >> >> >> >> >> _______________________________________________ >> 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 >> >> > -- -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+260968395190 _______________________________________________ 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