Indicators or Validations when using Combination of categories on DataSet

When using a combination of Categories on a Data Set - how can I write a validation rule that compares values between the categories used by the DataSet, rather than the total?

Similarly, how can I define an Indicator that uses for the numerator one Combination of Category of the data set, and then a different one for the denominator?

In neither case the category combination is exposed on the User Interface: only the DataElements and related CatCombos are exposed.

Rodolfo

Continuation of my question:

Is it possible to write Indicator/ Validation expressions using a syntax that can refer to the DataSet Attribute, even if the UI doesn’t expose it?

Can I refer to a particular DataValue as [DataElement UID].[CatCombo UID].[DataSetAttribute] ?

Otherwise I cannot use DataSetAttributes in my design: they are visible on analytics, but there are not exposed on Validations or Indicators, making them difficult (sometimes impossible) to use.

R

···

On Mon, Mar 30, 2015 at 5:50 PM, Rodolfo Melia rmelia@knowming.com wrote:

When using a combination of Categories on a Data Set - how can I write a validation rule that compares values between the categories used by the DataSet, rather than the total?

Similarly, how can I define an Indicator that uses for the numerator one Combination of Category of the data set, and then a different one for the denominator?

In neither case the category combination is exposed on the User Interface: only the DataElements and related CatCombos are exposed.

Rodolfo

Rodolfo Meliá

*Principal | *rmelia@knowming.com

Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636

www.knowming.com

Dear Rodolfo,

How about using a custom form with some jquery enforcing whatever you need?

Alex

···

On Tue, Mar 31, 2015 at 11:23 AM, Rodolfo Melia rmelia@knowming.com wrote:

Continuation of my question:

Is it possible to write Indicator/ Validation expressions using a syntax that can refer to the DataSet Attribute, even if the UI doesn’t expose it?

Can I refer to a particular DataValue as [DataElement UID].[CatCombo UID].[DataSetAttribute] ?

Otherwise I cannot use DataSetAttributes in my design: they are visible on analytics, but there are not exposed on Validations or Indicators, making them difficult (sometimes impossible) to use.

R


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

Rodolfo Meliá

*Principal | *rmelia@knowming.com

Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636

www.knowming.com

On Mon, Mar 30, 2015 at 5:50 PM, Rodolfo Melia rmelia@knowming.com wrote:

When using a combination of Categories on a Data Set - how can I write a validation rule that compares values between the categories used by the DataSet, rather than the total?

Similarly, how can I define an Indicator that uses for the numerator one Combination of Category of the data set, and then a different one for the denominator?

In neither case the category combination is exposed on the User Interface: only the DataElements and related CatCombos are exposed.

Rodolfo

Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Hi Alex - that will work, but we are looking at using Validation Rules, so they can be used for both, data entry and data import. Also, there are some indicators that I need to calculate that only use as numerator a specific DataValue that belong to one of the DataSetAttributes.

I may need to reverse the decision of using the Dataset Attributes, and instead do it the classic way: just Data Elements and CatCambos.

R

···

On Tue, Mar 31, 2015 at 2:21 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Rodolfo,

How about using a custom form with some jquery enforcing whatever you need?

Alex

On Tue, Mar 31, 2015 at 11:23 AM, Rodolfo Melia rmelia@knowming.com wrote:

Continuation of my question:

Is it possible to write Indicator/ Validation expressions using a syntax that can refer to the DataSet Attribute, even if the UI doesn’t expose it?

Can I refer to a particular DataValue as [DataElement UID].[CatCombo UID].[DataSetAttribute] ?

Otherwise I cannot use DataSetAttributes in my design: they are visible on analytics, but there are not exposed on Validations or Indicators, making them difficult (sometimes impossible) to use.

R


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


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Rodolfo Meliá

*Principal | *rmelia@knowming.com

Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636

www.knowming.com

On Mon, Mar 30, 2015 at 5:50 PM, Rodolfo Melia rmelia@knowming.com wrote:

When using a combination of Categories on a Data Set - how can I write a validation rule that compares values between the categories used by the DataSet, rather than the total?

Similarly, how can I define an Indicator that uses for the numerator one Combination of Category of the data set, and then a different one for the denominator?

In neither case the category combination is exposed on the User Interface: only the DataElements and related CatCombos are exposed.

Rodolfo

Hi Rodolfo,

Do you know if there’s been any update on this question? I am particularly interesting in creating indicators that combine data elements from different data set categories.

Please let me know.

Thanks.

Busoye

···

On Tue, Mar 31, 2015 at 2:21 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Rodolfo,

How about using a custom form with some jquery enforcing whatever you need?

Alex

On Tue, Mar 31, 2015 at 11:23 AM, Rodolfo Melia rmelia@knowming.com wrote:

Continuation of my question:

Is it possible to write Indicator/ Validation expressions using a syntax that can refer to the DataSet Attribute, even if the UI doesn’t expose it?

Can I refer to a particular DataValue as [DataElement UID].[CatCombo UID].[DataSetAttribute] ?

Otherwise I cannot use DataSetAttributes in my design: they are visible on analytics, but there are not exposed on Validations or Indicators, making them difficult (sometimes impossible) to use.

R


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


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Rodolfo Meliá

*Principal | *rmelia@knowming.com

Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636

www.knowming.com

On Mon, Mar 30, 2015 at 5:50 PM, Rodolfo Melia rmelia@knowming.com wrote:

When using a combination of Categories on a Data Set - how can I write a validation rule that compares values between the categories used by the DataSet, rather than the total?

Similarly, how can I define an Indicator that uses for the numerator one Combination of Category of the data set, and then a different one for the denominator?

In neither case the category combination is exposed on the User Interface: only the DataElements and related CatCombos are exposed.

Rodolfo

I don’t think there is. At the end, I had to create 2 sets of Data Elements (200 Data Elements x2=400 Data Elements), as if I used the DataSet Attribute I couldn’t look at an specific one when doing a indicator or validation. I do think that DHIS needs to expose the DataSet Attribute as part of the Indicator/ Quality modules at some point soon - having it on the analytics is not enough. I could be as easier as extending the current notation DataElementUID.CatComboUID by adding a third .DataSetAttributeIUD.

···

On Wed, Sep 16, 2015 at 12:49 PM, Adebusoye Anifalaje busoye@icloud.com wrote:

Hi Rodolfo,

Do you know if there’s been any update on this question? I am particularly interesting in creating indicators that combine data elements from different data set categories.

Please let me know.

Thanks.

Busoye

On 31 Mar 2015, at 18:13, Rodolfo Melia rmelia@knowming.com wrote:

Hi Alex - that will work, but we are looking at using Validation Rules, so they can be used for both, data entry and data import. Also, there are some indicators that I need to calculate that only use as numerator a specific DataValue that belong to one of the DataSetAttributes.

I may need to reverse the decision of using the Dataset Attributes, and instead do it the classic way: just Data Elements and CatCambos.

R


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

Rodolfo Meliá

*Principal | *rmelia@knowming.com

Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636

www.knowming.com

On Tue, Mar 31, 2015 at 2:21 PM, Alex Tumwesigye atumwesigye@gmail.com wrote:

Dear Rodolfo,

How about using a custom form with some jquery enforcing whatever you need?

Alex

On Tue, Mar 31, 2015 at 11:23 AM, Rodolfo Melia rmelia@knowming.com wrote:

Continuation of my question:

Is it possible to write Indicator/ Validation expressions using a syntax that can refer to the DataSet Attribute, even if the UI doesn’t expose it?

Can I refer to a particular DataValue as [DataElement UID].[CatCombo UID].[DataSetAttribute] ?

Otherwise I cannot use DataSetAttributes in my design: they are visible on analytics, but there are not exposed on Validations or Indicators, making them difficult (sometimes impossible) to use.

R


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


Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET

Kampala

Uganda

IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya

IT Specialist (Servers, Networks and Security, Health Information Systems - DHIS2 ) & Solar Consultant

+256 774149 775, + 256 759 800161

"I don’t want to be anything other than what I have been - one tree hill "

Rodolfo Meliá

*Principal | *rmelia@knowming.com

Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636

www.knowming.com

On Mon, Mar 30, 2015 at 5:50 PM, Rodolfo Melia rmelia@knowming.com wrote:

When using a combination of Categories on a Data Set - how can I write a validation rule that compares values between the categories used by the DataSet, rather than the total?

Similarly, how can I define an Indicator that uses for the numerator one Combination of Category of the data set, and then a different one for the denominator?

In neither case the category combination is exposed on the User Interface: only the DataElements and related CatCombos are exposed.

Rodolfo