Re: [Dhis2-users] Need some help

2012-02-14 Thread Jason Pickering
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 i

Re: [Dhis2-users] Need some help

2012-02-14 Thread Ola Hodne Titlestad
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 ar

Re: [Dhis2-users] Need some help

2012-02-14 Thread Lars Helge Øverland
Hi, quick comment, if you save your views through the "Sql View" management in data administration module they will be dropped and recreated with the resource tables. Lars On Tue, Feb 14, 2012 at 8:46 PM, Jason Pickering wrote: > Hi Stephen, > > I think the key question is whether this is  a mor

Re: [Dhis2-users] Need some help

2012-02-14 Thread Jason Pickering
Hi Stephen, I think the key question is whether this is a more general issue. If you only need to generate for IRC, then as Johan outlines, it is just matter of creating a specific pivot source view and filtering out the desired orguint group. However, creating views directly in the DHIS2 datab

Re: [Dhis2-users] Need some help

2012-02-14 Thread Johan Sæbø
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 facil

[Dhis2-users] Need some help

2012-02-14 Thread Stephen Gbanyan
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. Example If IRC is supporting 10 facilities in Margibi County can I generate a PT with only those 10 facilities supported by

[Dhis2-users] How does "D"number of days works

2012-02-14 Thread Kamugunga Adolphe
Hi, i am trying to create this calculated data element "Potential Number of hospitalization days(Beds x days in month)" using "Beds" as data element and "D" to formulate the the numerator but it's not calculating the value. Any help on how this works, i couldn't find any related info the manual.