Value of Variable V{event_count} stores in which Table of the DHIS2 Database

Implementation - Implémentation
1

Hi!

We are working on Triangulation of Data using Power BI Dashboard. We are facing challenge to link value of V{event_count} Can you guide me value of the variable stores in which Table of the DHIS2 Database ?

2

Hi @RKJ

Are you creating a program indicator? Why not create the indicator and then make the API request to get the value?

Thanks!

3

Hi! AL-Gassim,
Thank for your reply. We have already created and implemented the PI including V{event_count} in the filter expression. Now I want to know where(Database Table) DHIS2 stores the value of the variable. How can I pull the value using API ?

Thanks,
Raushan

4

To the best of my knowledge these values are generated during the analytics tables export and are stored in several tables that start with the word analytics_.

If you want to get the event_count, you can create a program indicator that will give you the value of the event_count and then get the value using the API. Here’s the related manual: Analytics - DHIS2 Documentation