Hi John, You should probably consider using the new feature of the category option group sets. This allows a mechanism to have multiple reports for a single organisation unit and time period, which would be disaggregated by for instance, "Implementing partner" and "Project". You can take a look at the new documentation here<http://apps.dhis2.org/ci/job/dhis-documentation-en/lastSuccessfulBuild/artifact/*zip*/archive.zip> which describes how to set this up.
The problem with the approach which you propose is that the maintenance of the orgunit hierarchy becomes complicated if you are dealing with a lot of IPs. If it is a small number, it may be possible, but has proven to be a big headache in other implementations where this type of information needs to be recorded. Best regards, Jason On Thu, Feb 20, 2014 at 1:21 AM, John Ojo <[email protected]> wrote: > Hi All, > > I am designing a database for an organization that works with multiple > local NGOs (14 NGOs in all) as the Implementing Partners (IPs) for the said > organization. > > There are 40 districts in all. For the sake of this description, I will > name the districts as district_1, district_2, district_3, and so on. and > the IPs as IP1, IP2, IP3, and so on. > Each of the IPs works in multiple districts; for example IP1 and IP2 each > works in all the 40 districts. > > Each IP specializes in one program area. For example, IP1 does only > HIV/AIDS while IP2 focuses on Gender & Human Rights. > The organization needs to be able to know the results of each IP from each > district every month. > > I am therefore planning to set up the organisation unit names in the DHIS > 2 database as follows: > For IP1 and IP2, I'm considering the following orgUnit names: > > District_1 > IP1_d1 > IP2_d1 > > District_2 > IP1_d2 > IP2_d2 > > > District_3 > IP1_d3 > IP2_d3 > . > . > . > District_40 > IP1_d40 > IP2_d40 > > I would appreciate suggestions on how to handle this piece, especially if > there's a better way than this approach and would also like to hear from > anyone who had had to deal with this type of situation and how they handled > the orgUnit names. > > Thank you so much. > > John > > > *John Ojo MD, FMCPH* > Accra, Ghana. > Mobile: +233 234691626+233 234691626 > Skype: Johnojo > Email: [email protected] <[email protected]> > <http://www.corridor-sida.org/> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
