Indicators having dataset metrics type in denominator doesnt work in 2.36.9

[Guy_Ekani]

Hello Team,

Indicators having dataset metrics type (Expected) in denominator doesnt work in 2.36.9 (5235548),

To reproduce create an indicator with data expected report in denominator, in this example in play i used poputation : R{aLpVgfXiz0f.EXPECTED_REPORTS}

• 2.36.9 : https://play.dhis2.org/2.36.9/dhis-web-data-visualizer/index.html#/aOfR6YP3zmQ
• 2.35.12 : https://play.dhis2.org/2.35.12/dhis-web-data-visualizer/index.html#/oIga0lUKQdS

Please could you advise,

[Gassim (AL-Gassim Sharaf Addin)]

Hi @Guy_Ekani,
Thank you! Yes, I can reproduce this issue, would you like to create a bug issue on Jira.dhis2.org? Thank you!

[Guy_Ekani]

@Gassim

uld you like to create a bug

Thank you @Gassim here is the ticket : [DHIS2-12864] - Jira

Sincerely,

[Gassim (AL-Gassim Sharaf Addin)]

Thank you Guy! I voted , thanks! I also added CoP to labels and a link to this topic in the comments.

p.s. bug hunters are mentioned in the copmonthly

[Guy_Ekani]

@Gassim please while waiting for an update, is there another way to get the number of expected report in denominators ?

[Gassim (AL-Gassim Sharaf Addin)]

Sorry @Guy_Ekani! I am triaging the bug issue; however, Did you try using the Maps app?

[Guy_Ekani]

Most of our outputs are in tables and graphs, seems to works for single value and maps

[Guy_Ekani]

Thank you @phil,

But we still have issues with outputs (graph and table) when period is set as category and indicators having dataset metrics type in denominators.

Please could you advise ?

Sincerely,

Play 2.36.10 : https://play.dhis2.org/2.36.10/dhis-web-data-visualizer/index.html#/OoByd8m1tRC

Play 2.35.13 : https://play.dhis2.org/2.35.13/dhis-web-data-visualizer/index.html#/tORJswDPMgd

Here is the description: Indicators having dataset metrics type in denominator doesnt work in 2.36.9

Here is the Jira : [DHIS2-12864] - Jira

[Gassim (AL-Gassim Sharaf Addin)]

@Guy_Ekani,
Thank you for your post! I’m sorry I had to move your post from the announcement because the patch is a security hotfix. If you clicked ‘watch’ in the Jira issue, you will receive notifications for any updates.

Thanks!

---

@phil

Hi @Guy_Ekani

Yes, please note that this is not a maintenance patch with bugfixes, only a security hotfix to secure against the recent “spring4shell” vulnerability.

[Gassim (AL-Gassim Sharaf Addin)]

@Guy_Ekani, core team experts have been looking at this issue and the final recommendation is to update to the ~latest build of your version because it is working fine~[sorry, see Phil’s post below, thanks!]. Please see this jira bug issue for more details: Indicators with reporting rates in expression not working with OU dimension as filter

Thanks! 👍

[phil (Philip Larsen Donnelly)]

Just to be clear @Guy_Ekani @Gassim, this problem exist in the latest stable release. It is resolved for the next maintenance release. The only way to get the fix immediately is to take what we call a Canary build (nightly build of the development version) - we don’t recommend using Canary build for your production version unless you perform thorough regression testing yourself.

[Guy_Ekani]

Thank you for your advice @phil, we are waiting for the stable build that will include this fix.

[Gassim (AL-Gassim Sharaf Addin)]

Hi @Guy_Ekani

Have you upgraded the DHIS2 instance that you are using to any of the latest DHIS2 versions? The Jira bug issue is closed now and has been resolved, see comment: [DHIS2-12864] - Jira

Please let me know if you are still able to reproduce the issue in any of the latest versions so we can follow up.

Thanks!