← Back to team overview

dhis2-users team mailing list archive

Re: Sharing Pivot Table details between DHIS instances

 

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 3130
>>> Fax:          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

References