dhis2-users team mailing list archive

[Johan Sæbø <johansa@xxxxxxxxxx>]

Stephen,

On 14.02.2012 17:59, Stephen Gbanyan wrote:
> Hi All,
>
> I have been asked if it is possible to have a Pivot Table like that of
> the DHIS1.4 in which I could run a query and generate data of
> supporting partners to the MOH.

This is possible, see below

> Example
> If IRC is supporting 10 facilities in Margibi County can I generate a
> PT with only those 10 facilities supported by IRC?  It that can work
> can I please be guided.

Yes, but I suspect you have to write a new pivotsource/"view" for it. If 
you are using the MyDatamart to fetch data to your (or IRCs) local 
machine, you could get all facility data from Margibi County downloaded 
quite easily. However, since you just want a subset, you would probably 
have to make this new pivot view (e.g. write some query, in your DHIS2 
database I think). Since I'm no expert on neither queries nor 
MyDatamart, I leave it to others to guide you here, but I suspect it 
makes sense to keep record of the "IRC facilities" inside DHIS2, using 
orgunit groups. This way you can probably write your query based on 
matching orgunit groups, and you don't have to worry about your query 
again as long as you keep list of IRC facilities updated in DHIS2.

Regards.
Johan

> Thanks
>
> Stephen
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp