2010/7/12 Jason Pickering <jason.p.picker...@gmail.com> > 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 <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
