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.
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@jembi.org 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.
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.
On Thu, Mar 19, 2015 at 9:00 AM, Pierre Dane pierre@jembi.org 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.
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.
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.
On Thu, Mar 19, 2015 at 9:00 AM, Pierre Dane pierre@jembi.org 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.