Program indicator disaggregation questions

Support - Assistance technique
1

Hello DHIS Community :slight_smile:

I’m exploring program indicator disaggregations and have 2 question.

  1. Can I map my program indicators to more than one disaggregation categoryCombo?
  2. Will my mappings to my disaggregation categories be usable in category option group sets?

As a bit of background, my use case behind these questions is that I want to disaggregate data from multiple programs by different age groups combinations (e.g. <5/5+ years AND <5/5-14/15+ years)

Thanks for the insights !

2

Hi @Kris_Reinhardt

Even if your base categoryCombo uses detailed categories, you can define:

  • Category Options

For Age:

<5
5–14
15+

  • Category Option Group Sets

You can define multiple groupings on top of the same base categories:

  • Group Set 1: Simple split

<5
5+ → (5–14 + 15+)

  • Group Set 2: Detailed split

<5
5–14
15+

I’m sure you can do it :clap:

1 Like
3

Thanks @HanyAly :smiley: this is how I have had the system configured. Unfortunately, it looks like it’s not working. After some digging, it looks like I’m getting a badSqlGrammarException error in my logs when trying to use a category option group set.

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select count(case when eventstatus in ('ACTIVE', 'COMPLETED') then 1 end) as value,ax."A88IcEp7zVZ",ax."monthly" from analytics_event_kz238i6pydu as ax where (ax."monthly" in ('202504', '202505', '202506', '202507', '202508', '202509', '202510', '202511', '202512', '202601', '202602', '202603') ) and ax."uidlevel1" in ('a2cf79e8f13') and ax."A88IcEp7zVZ" in ('I0YzYuKJAVC', 'qiKnkn7zGuf') and length((case when case when ax."ps" = 'k84o7pGL3RR' then "FRI6UTDBJFB" else null end < 5::numeric then 'abacfb5842a' else '' end || case when case when ax."ps" = 'k84o7pGL3RR' then "FRI6UTDBJFB" else null end >= 5::numeric and case when ax."ps" = 'k84o7pGL3RR' then "FRI6UTDBJFB" else null end < 15::numeric then 'a0b89770007' else '' end || case when case when ax."ps" = 'k84o7pGL3RR' then "FRI6UTDBJFB" else null end >= 15::numeric then 'af973e20283' else '' end)) = 11 and length((case when case when ax."ps" = 'k84o7pGL3RR' then "gbnoSILapVv" else null end = 'male' then 'a07cf4f8f5d' else '' end || case when case when ax."ps" = 'k84o7pGL3RR' then "gbnoSILapVv" else null end = 'female' then 'a273b9ae535' else '' end)) = 11 and (coalesce(case when ax."ps" = 'k84o7pGL3RR' then "RJw3qnHk88a" else null end::text,'') = 'yes') and ax."yearly" in ('2026', '2025') group by ax."A88IcEp7zVZ", ax."monthly" ]

Maybe use of the category option group set is not part of the expected functionality? @Gassim or @Jim_Grace can help with some insights on the expected functionality of this feature?? :smiley: