Limit on data attribute - category options

We would like to add the data attributes: Donor, Program, Implementing Partner and Grant in a category combination to some datasets.

Looking at the data that needs to be imported, the Donors and Programs are few, however, the IPs and grants are in the range of 200 and 500 respectively; of course with potential to increase over time.

I am wondering if the DHIS2 is designed to manage that kind of data.

regards,

···

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug

I would also want to learn more.I was able to have such category combinations but the IPs were very few.However I didn’t manage to have some sort of filter that when one selects the program only IPs implementing such program should appear under that program.Instead all IPs appeared.Difficult for data quality incase someone selects an IP that is not implementing that program.

So.let’s learn

Stanley

···

On Apr 3, 2017 7:28 AM, “Sam Kasozi” kasozis@gmail.com wrote:

We would like to add the data attributes: Donor, Program, Implementing Partner and Grant in a category combination to some datasets.

Looking at the data that needs to be imported, the Donors and Programs are few, however, the IPs and grants are in the range of 200 and 500 respectively; of course with potential to increase over time.

I am wondering if the DHIS2 is designed to manage that kind of data.

regards,

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi Sam,

yes it should be possible to set this up in DHIS 2.

In your case, if you create all 4 as categories you might end up with a very high number of option combo permutations.

However, it might be that you have fixed relationships within those categories. For example, it could be that one grant is supported by exactly one implementing partner and donor. In that case, you should not ask end users to actively select partner and donor in data entry; rather have them select the grant only (as a data set category). From there, you can set up category option groups and group sets:

Group set: Donor

Groups: USAID, DFID, etc

Group set: Implementing partner

Groups: PartnerA, PartnerB, etc

Then you assign each grant to exactly one group per group set. You can now do analytics based on the above dimensions without having end users explicitly selecting them in data entry. This will keep number of category option combos low and reduce time and errors during data entry. Make sure you set the category option group sets as “data dimension”.

Docs here.

regards,

Lars

···

On Mon, Apr 3, 2017 at 7:28 AM, Sam Kasozi kasozis@gmail.com wrote:

We would like to add the data attributes: Donor, Program, Implementing Partner and Grant in a category combination to some datasets.

Looking at the data that needs to be imported, the Donors and Programs are few, however, the IPs and grants are in the range of 200 and 500 respectively; of course with potential to increase over time.

I am wondering if the DHIS2 is designed to manage that kind of data.

regards,

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Yes, we do have fixed relationships within those categories, so this works for us!

This implementation is much safer as well since it will not require a data entrant to filter through the different categories.

Thank you.

···

On Mon, Apr 3, 2017 at 11:15 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Sam,

yes it should be possible to set this up in DHIS 2.

In your case, if you create all 4 as categories you might end up with a very high number of option combo permutations.

However, it might be that you have fixed relationships within those categories. For example, it could be that one grant is supported by exactly one implementing partner and donor. In that case, you should not ask end users to actively select partner and donor in data entry; rather have them select the grant only (as a data set category). From there, you can set up category option groups and group sets:

Group set: Donor

Groups: USAID, DFID, etc

Group set: Implementing partner

Groups: PartnerA, PartnerB, etc

Then you assign each grant to exactly one group per group set. You can now do analytics based on the above dimensions without having end users explicitly selecting them in data entry. This will keep number of category option combos low and reduce time and errors during data entry. Make sure you set the category option group sets as “data dimension”.

Docs here.

regards,

Lars

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug

On Mon, Apr 3, 2017 at 7:28 AM, Sam Kasozi kasozis@gmail.com wrote:

We would like to add the data attributes: Donor, Program, Implementing Partner and Grant in a category combination to some datasets.

Looking at the data that needs to be imported, the Donors and Programs are few, however, the IPs and grants are in the range of 200 and 500 respectively; of course with potential to increase over time.

I am wondering if the DHIS2 is designed to manage that kind of data.

regards,

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Dear all,

This is also a requirement for us but we are wondering if it is possible to implement a “user” visibility of the data sets category options. For example a user from Spain only being acessible to the Spain Implementer Partners or a user only accessing to the category options where he’s in charge to enter data.

Thanks a lot!

Marc Garnica

···

2017-04-03 9:15 GMT+02:00 Sam Kasozi kasozis@gmail.com:

Yes, we do have fixed relationships within those categories, so this works for us!

This implementation is much safer as well since it will not require a data entrant to filter through the different categories.

Thank you.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug

On Mon, Apr 3, 2017 at 11:15 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Sam,

yes it should be possible to set this up in DHIS 2.

In your case, if you create all 4 as categories you might end up with a very high number of option combo permutations.

However, it might be that you have fixed relationships within those categories. For example, it could be that one grant is supported by exactly one implementing partner and donor. In that case, you should not ask end users to actively select partner and donor in data entry; rather have them select the grant only (as a data set category). From there, you can set up category option groups and group sets:

Group set: Donor

Groups: USAID, DFID, etc

Group set: Implementing partner

Groups: PartnerA, PartnerB, etc

Then you assign each grant to exactly one group per group set. You can now do analytics based on the above dimensions without having end users explicitly selecting them in data entry. This will keep number of category option combos low and reduce time and errors during data entry. Make sure you set the category option group sets as “data dimension”.

Docs here.

regards,

Lars

On Mon, Apr 3, 2017 at 7:28 AM, Sam Kasozi kasozis@gmail.com wrote:

We would like to add the data attributes: Donor, Program, Implementing Partner and Grant in a category combination to some datasets.

Looking at the data that needs to be imported, the Donors and Programs are few, however, the IPs and grants are in the range of 200 and 500 respectively; of course with potential to increase over time.

I am wondering if the DHIS2 is designed to manage that kind of data.

regards,

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Yes, you can use “Sharing” controlled with user groups. However, it can get complex quickly, and usually requires very careful user management routines, coupled with automatic scripting to get it right.

···

On Mon, Apr 3, 2017 at 9:31 AM, Marc Garnica marcgarnica13@gmail.com wrote:

Dear all,

This is also a requirement for us but we are wondering if it is possible to implement a “user” visibility of the data sets category options. For example a user from Spain only being acessible to the Spain Implementer Partners or a user only accessing to the category options where he’s in charge to enter data.

Thanks a lot!

Marc Garnica


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

2017-04-03 9:15 GMT+02:00 Sam Kasozi kasozis@gmail.com:

Yes, we do have fixed relationships within those categories, so this works for us!

This implementation is much safer as well since it will not require a data entrant to filter through the different categories.

Thank you.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug

On Mon, Apr 3, 2017 at 11:15 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Sam,

yes it should be possible to set this up in DHIS 2.

In your case, if you create all 4 as categories you might end up with a very high number of option combo permutations.

However, it might be that you have fixed relationships within those categories. For example, it could be that one grant is supported by exactly one implementing partner and donor. In that case, you should not ask end users to actively select partner and donor in data entry; rather have them select the grant only (as a data set category). From there, you can set up category option groups and group sets:

Group set: Donor

Groups: USAID, DFID, etc

Group set: Implementing partner

Groups: PartnerA, PartnerB, etc

Then you assign each grant to exactly one group per group set. You can now do analytics based on the above dimensions without having end users explicitly selecting them in data entry. This will keep number of category option combos low and reduce time and errors during data entry. Make sure you set the category option group sets as “data dimension”.

Docs here.

regards,

Lars

On Mon, Apr 3, 2017 at 7:28 AM, Sam Kasozi kasozis@gmail.com wrote:

We would like to add the data attributes: Donor, Program, Implementing Partner and Grant in a category combination to some datasets.

Looking at the data that needs to be imported, the Donors and Programs are few, however, the IPs and grants are in the range of 200 and 500 respectively; of course with potential to increase over time.

I am wondering if the DHIS2 is designed to manage that kind of data.

regards,

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hi Marc,

as Jason says you can use the sharing (docs) solution for this by sharing each category option (representing e.g. partners) appropriately. This can be done in many ways depending on the level of complexity of your organization. At its very basic level, you can create one user group per implementing partner, then share each partner category option with read access to the appropriate user group. This way, when partners log into data entry, they will only see the category options in the category drop-down which are relevant to them.

Sharing can easily grow complex so it is advisable to keep things simple and think through the design up front (as always).

regards,

Lars

···

On Mon, Apr 3, 2017 at 9:44 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Yes, you can use “Sharing” controlled with user groups. However, it can get complex quickly, and usually requires very careful user management routines, coupled with automatic scripting to get it right.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Mon, Apr 3, 2017 at 9:31 AM, Marc Garnica marcgarnica13@gmail.com wrote:

Dear all,

This is also a requirement for us but we are wondering if it is possible to implement a “user” visibility of the data sets category options. For example a user from Spain only being acessible to the Spain Implementer Partners or a user only accessing to the category options where he’s in charge to enter data.

Thanks a lot!

Marc Garnica


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

2017-04-03 9:15 GMT+02:00 Sam Kasozi kasozis@gmail.com:

Yes, we do have fixed relationships within those categories, so this works for us!

This implementation is much safer as well since it will not require a data entrant to filter through the different categories.

Thank you.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug

On Mon, Apr 3, 2017 at 11:15 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Sam,

yes it should be possible to set this up in DHIS 2.

In your case, if you create all 4 as categories you might end up with a very high number of option combo permutations.

However, it might be that you have fixed relationships within those categories. For example, it could be that one grant is supported by exactly one implementing partner and donor. In that case, you should not ask end users to actively select partner and donor in data entry; rather have them select the grant only (as a data set category). From there, you can set up category option groups and group sets:

Group set: Donor

Groups: USAID, DFID, etc

Group set: Implementing partner

Groups: PartnerA, PartnerB, etc

Then you assign each grant to exactly one group per group set. You can now do analytics based on the above dimensions without having end users explicitly selecting them in data entry. This will keep number of category option combos low and reduce time and errors during data entry. Make sure you set the category option group sets as “data dimension”.

Docs here.

regards,

Lars

On Mon, Apr 3, 2017 at 7:28 AM, Sam Kasozi kasozis@gmail.com wrote:

We would like to add the data attributes: Donor, Program, Implementing Partner and Grant in a category combination to some datasets.

Looking at the data that needs to be imported, the Donors and Programs are few, however, the IPs and grants are in the range of 200 and 500 respectively; of course with potential to increase over time.

I am wondering if the DHIS2 is designed to manage that kind of data.

regards,

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

Nice solution! We will give a try. Thank you very much!

Marc

···

2017-04-03 10:08 GMT+02:00 Lars Helge Øverland lars@dhis2.org:

Hi Marc,

as Jason says you can use the sharing (docs) solution for this by sharing each category option (representing e.g. partners) appropriately. This can be done in many ways depending on the level of complexity of your organization. At its very basic level, you can create one user group per implementing partner, then share each partner category option with read access to the appropriate user group. This way, when partners log into data entry, they will only see the category options in the category drop-down which are relevant to them.

Sharing can easily grow complex so it is advisable to keep things simple and think through the design up front (as always).

regards,

Lars

On Mon, Apr 3, 2017 at 9:44 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Yes, you can use “Sharing” controlled with user groups. However, it can get complex quickly, and usually requires very careful user management routines, coupled with automatic scripting to get it right.


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

On Mon, Apr 3, 2017 at 9:31 AM, Marc Garnica marcgarnica13@gmail.com wrote:

Dear all,

This is also a requirement for us but we are wondering if it is possible to implement a “user” visibility of the data sets category options. For example a user from Spain only being acessible to the Spain Implementer Partners or a user only accessing to the category options where he’s in charge to enter data.

Thanks a lot!

Marc Garnica


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

2017-04-03 9:15 GMT+02:00 Sam Kasozi kasozis@gmail.com:

Yes, we do have fixed relationships within those categories, so this works for us!

This implementation is much safer as well since it will not require a data entrant to filter through the different categories.

Thank you.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug

On Mon, Apr 3, 2017 at 11:15 AM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Sam,

yes it should be possible to set this up in DHIS 2.

In your case, if you create all 4 as categories you might end up with a very high number of option combo permutations.

However, it might be that you have fixed relationships within those categories. For example, it could be that one grant is supported by exactly one implementing partner and donor. In that case, you should not ask end users to actively select partner and donor in data entry; rather have them select the grant only (as a data set category). From there, you can set up category option groups and group sets:

Group set: Donor

Groups: USAID, DFID, etc

Group set: Implementing partner

Groups: PartnerA, PartnerB, etc

Then you assign each grant to exactly one group per group set. You can now do analytics based on the above dimensions without having end users explicitly selecting them in data entry. This will keep number of category option combos low and reduce time and errors during data entry. Make sure you set the category option group sets as “data dimension”.

Docs here.

regards,

Lars

On Mon, Apr 3, 2017 at 7:28 AM, Sam Kasozi kasozis@gmail.com wrote:

We would like to add the data attributes: Donor, Program, Implementing Partner and Grant in a category combination to some datasets.

Looking at the data that needs to be imported, the Donors and Programs are few, however, the IPs and grants are in the range of 200 and 500 respectively; of course with potential to increase over time.

I am wondering if the DHIS2 is designed to manage that kind of data.

regards,

Sam Kasozi
+256 788-993-565

Skype: sam.kasoziug


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org