← Back to team overview

dhis2-users team mailing list archive

Re: Sharing Pivot Table details between DHIS instances

 

In DHIS2 can't "global" be set as OUlevel zero (above national/OU1)? If multiple countries were to be integrated into one instance it would require all existing OUlevels to be incremented unless level zero could be accommodated with some dynamic settings for different 'branches' (assuming all country instances share a common and proportionate number of vertical levels).  
The other option is going a much more sophisticated route and virtualizing a DHIS2 instance from multiple 'live' instances but that would be a whole new kind of approach - probably unnecessarily complex ... 

Sent from my HTC

----- Reply message -----
From: "Knut Staring" <knutst@xxxxxxxxx>
To: "Greg Rowles" <greg.rowles@xxxxxxxxx>
Cc: "Lars Helge Øverland" <larshelge@xxxxxxxxx>, "DHIS Users" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: [Dhis2-users] Sharing Pivot Table details between DHIS instances
Date: Fri, Jun 20, 2014 04:47

And more generally we could then have objects that are more akin to meta-meta-data:Parametrizable map, chart and PT favorites that include legend sets, as well as Dashboards. 



I guess supporting Relative periods and User Org Unit has been our first stab at this.




On Fri, Jun 20, 2014 at 4:43 AM, Knut Staring <knutst@xxxxxxxxx> wrote:


I guess I am talking about somehow parametrizing the PT favorites - and being able to share the parametrizable favorites between DHIS2 instances.





On Fri, Jun 20, 2014 at 4:39 AM, Knut Staring <knutst@xxxxxxxxx> wrote:



While I agree on the recommendation of a common meta-data repository for Data Elements and Indicators, this obviously does not help in the least when it comes to OrgUnits in different countries. We have OrgUnit as a parameter in the "ordinary" reports, but not for pivot tables (periods are of course already standardised across most countries -  those that use ISO calendars).




I suppose the question highlights the increasing use of more flexible PT for reporting in addition to (or completely replacing) conventional reports. Does it make sense to think of an App that makes it easy to pass parameters (OU, periods) to ready-made pivot layouts - or would that really just be recreating the PT GUI? Is the API already capable of handling this?





Knut




On Thu, Jun 19, 2014 at 8:49 PM, Greg Rowles <greg.rowles@xxxxxxxxx> wrote:




Hi, Also agree with the abovementioned. We're working towards a "master" data-dictionary for indicator and data element definitions to ensure alignment and standardization here in South Africa. It might be good to begin assessing alignment possibilities starting with indicators as they determine which elements get collected...





Regards,
Greg



On Thu, Jun 19, 2014 at 8:33 PM, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:





Hi, agree with Jason. On an additional note, if the meta-data (data elements in particular) actually are consistent across several instances it might be a good effort to standardize the UID, will be useful if you want to do comparative analysis across countries at a later stage.






Lars





On Thu, Jun 19, 2014 at 7:34 PM, Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:






I would think the best way to go about this would be to have a common meta-data repository. It would seem to be quite a bit of effort to try and map metadata definitions between different instances, but the usual approach here would be to have a "master" instance, which other "slave" instances would draw their metadata from. In this case, the exchange of pivots/reports would be possible, but very troublesome otherwise.







It is certainly possible, but building the transformation would be one more piece to maintain and would be quite fragile, as changes on either side would break it. 

Best regards,







Jason




On Thu, Jun 19, 2014 at 7:29 PM, Laura E. Lincks <laura.lincks@xxxxxxxxxxxxxxxxx> wrote:








We have individual DHIS instances installed for individual countries. Many configuration needs are similar across countries including the set up of many reports. Is it possible to take a pivot table definition set up in one country and export that definition to another country's DHIS instance? I see that details can be exported for a pivot table using Meta-Data Export but it of course contains unique identifiers for that country which will not apply in another country's instance. Is there a way to query the data from the backend, create an output script, changing the unique IDs to the new country's respective IDs and then insert the data in the new country's database? It may be more trouble doing it that way than simply manually creating the pivot table structures in the new country, but I thought I'd ask if anyone has had success doing it in a more automated fashion.









-- 
Laura E. Lincks







Database
Developer
ICAP -
Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1








New York, NY 10032
Tel: 212 304 7132


























_______________________________________________

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






_______________________________________________

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







_______________________________________________

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






-- 







Business Intelligence Planner
Health Information Systems Programme





- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 





Mobile  :    073 246 2992
Landline:   021 554 3130Fax:          086 733 8432 





Skype:      gregory_rowles






_______________________________________________

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





-- 

Knut Staring
Dept. of Informatics, University of Oslo
+4791880522



http://dhis2.org







-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522


http://dhis2.org








-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org

Follow ups