If it is only 10 facilities you need I would go with the mydatamart approach and select 1 facility at a time and download their data into the same local datamart and then create a pivot table on top of that. A bit cumbersome, but this requires no extra query on the server side.
More long term we are planning filters in mydatamart to more easily download subsets of facilities or data elements. Right now you can download all data for 1 facilty or for all facilities in an area(parent,grandparent etc).
This problem is somehow related to an issue I was discussing with Bob,namely that it would be useful to have a filter in place for certain user to only be able to be allowed to download the data for orgunits for which they have entered. I do not really know exactly Stephen’s issue, but I suspect it may be a similar requirement to what we have in Nigeria, namely that users should be allowed to get their own aggregate data but not the aggregate data of others. So, if IRC has entered data, a filter should be put in place to retrieve their data from the orgunits assigned to this particular user, and not inherit any other orgunits which have they have not been explicitly assigned.
If it is only 10 facilities you need I would go with the mydatamart approach and select 1 facility at a time and download their data into the same local datamart and then create a pivot table on top of that. A bit cumbersome, but this requires no extra query on the server side.
More long term we are planning filters in mydatamart to more easily download subsets of facilities or data elements. Right now you can download all data for 1 facilty or for all facilities in an area(parent,grandparent etc).
This is an interesting issue to Rwanda as well – we have similar requirements.
Just a quick thought, would it not be possible to use the DHIS-2 user’s orgunit access (as assigned when setting up the User by orgunit) to do this filtering? How exactly could that be accessed in a view or report table?
This problem is somehow related to an issue I was discussing with Bob,namely that it would be useful to have a filter in place for certain user to only be able to be allowed to download the data for orgunits for which they have entered. I do not really know exactly Stephen’s issue, but I suspect it may be a similar requirement to what we have in Nigeria, namely that users should be allowed to get their own aggregate data but not the aggregate data of others. So, if IRC has entered data, a filter should be put in place to retrieve their data from the orgunits assigned to this particular user, and not inherit any other orgunits which have they have not been explicitly assigned.
If it is only 10 facilities you need I would go with the mydatamart approach and select 1 facility at a time and download their data into the same local datamart and then create a pivot table on top of that. A bit cumbersome, but this requires no extra query on the server side.
More long term we are planning filters in mydatamart to more easily download subsets of facilities or data elements. Right now you can download all data for 1 facilty or for all facilities in an area(parent,grandparent etc).
The situation in Nigeria (and I suspect in other countries) is that we have a number of implementing partners who implement programmes and then report on them supported by a major bilateral development agency. Each partner needs to be provided access to their data (and only their data). Each implementing partner has a unique login and each reporting organisation unit is unique to a single implementing partner, and assigned to an organisation unit group. In order to maintain compatibility with the national system and facilitate geographical analysis, reporting units have been arranged in a geographical hierarchy. Orgunitgroup sets are used to implement an effective organisational hierarchy (Funding agency/programmes/partners). As a simple example, each organisationunit is assigned to an implementing partner (e.g. IRC, etc) and their aggregate data can be filtered by choosing the corresponding organisationunits with something like…
SELECT * FROM aggregatedatavalues where organisationunitid in
(SELECT DISTINCT organisationunitid from orgunitgroupmembers where orgunitgroupid = XXX);
where XXX would the orgunit group you wish to retrieve data for.
Of course the query would need to join a few more tables to make the view useful. What I hope to implement soon will be a stored procedure in Postgres to loop through each orgunit group and save this to a file…
In proto-procedureal SQL code…
FOR EACH rec in (SELECT DISTINCT orgunitgroupid from orgunitgroup) LOOP
resultset := SELECT * FROM aggregatedatavalues where organisationunitid in
(SELECT DISTINCT organisationunitid from orgunitgroupmembers where orgunitgroupid = rec.orgunitgroupid) ;
COPY resultset TO /some/path/rec.orgunitgroupid_data_date().csv;
END LOOP;
In this manner, each CSV file could be provided to the orgunit group, without any other orgunit groups data. Have not gotten around to the details of the procedure, but this is what I am planning anyway. This should be a really trivial stored procedure to implement, and once I get around to it, I can post here for others (or maybe someone has already done this another way?)
Regards,
Jason
···
On Wed, Feb 15, 2012 at 10:35 AM, Wilson,Randy rwilson@msh.org wrote:
This is an interesting issue to Rwanda as well – we have similar requirements.
Just a quick thought, would it not be possible to use the DHIS-2 user’s orgunit access (as assigned when setting up the User by orgunit) to do this filtering? How exactly could that be accessed in a view or report table?
Sent: Wednesday, February 15, 2012 9:26 AM To: Ola Hodne Titlestad Cc:dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Need some help
This problem is somehow related to an issue I was discussing with Bob,namely that it would be useful to have a filter in place for certain user to only be able to be allowed to download the data for orgunits for which they have entered. I do not really know exactly Stephen’s issue, but I suspect it may be a similar requirement to what we have in Nigeria, namely that users should be allowed to get their own aggregate data but not the aggregate data of others. So, if IRC has entered data, a filter should be put in place to retrieve their data from the orgunits assigned to this particular user, and not inherit any other orgunits which have they have not been explicitly assigned.
If it is only 10 facilities you need I would go with the mydatamart approach and select 1 facility at a time and download their data into the same local datamart and then create a pivot table on top of that. A bit cumbersome, but this requires no extra query on the server side.
More long term we are planning filters in mydatamart to more easily download subsets of facilities or data elements. Right now you can download all data for 1 facilty or for all facilities in an area(parent,grandparent etc).