dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Hi Pierre,

You'll need to create one group set(a data dimension in analytics) per
level (district) and one group per orgunit (district names) at that level.

Then you assign the facilities and other reporting units to the group they
belong to. Data will then be aggregated or filtered per group in each
dimension. You can use the hide empty rows option to hide all the empty
combinations of groups&facilities in the pivot table.

This is of course not an ideal approach as it means you need to maintain
two ou hierarchies and it can be confusing to the user to see these extra
ou dimensions in analytics modules.

But it will add some functionality to your pivot tables.

Building up these groups is best done  through some kind of script as it
will take a lot of time through the UI.

Ola
-------
 On 19 Mar 2015 17:41, "Knut Staring" <knutst@xxxxxxxxx> wrote:

> Maybe I misunderstand, but can't you get somewhere by having an OrgUnit
> group for each level (and also an OU group set)?
>
> On Thu, Mar 19, 2015 at 5:36 PM, Jan Henrik Øverland <
> janhenrik.overland@xxxxxxxxx> wrote:
>
>> Hi Pierre,
>>
>> this is not likely to be implemented in the near future I'm afraid as it
>> requires a major upgrade of our pivot table engine. As you already seem
>> aware of this is a special case that sort of breaks with the nature of our
>> dimension based pivot table setup.
>>
>> It's technically doable of course, but to answer your question it's not
>> on the list for the next couple of releases.
>>
>> Jan
>>
>> On Thu, Mar 19, 2015 at 9:00 AM, Pierre Dane <pierre@xxxxxxxxx> wrote:
>>
>>> I know there has been discussion about having the different levels of
>>> the org unit hierarchy in the pivot tables. At present this is still not
>>> possible (as far as I can see) and the best we can do is to have the full
>>> hierarchy string as a dimension (e.g. ec Eastern Cape Province / ec
>>> Alfred Nzo District Municipality / ec Maluti Health sub-District / ec
>>> Madlangala Clinic)  South African Dept. Health has requested that we
>>> have each level as a dimension. We are working around this by providing a
>>> csv file for excel pivots.
>>>
>>> Are there any plans to get the org unit levels into the pivots as
>>> dimensions? Apologies if I've missed a previous thread about this.
>>>
>>> Thanks
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>