4.7. Generate analytics tables

DHIS2 generates database tables which the system then uses as basis for various analytics functions. These tables are also valuable if you write advanced SQL reports. In the Reports app, you can execute the tables immediately or schedule them to be executed at regular intervals. This means that you can refresh recent analytics on demand and see updated pivot tables without waiting for all of the past years data to re-process.

[Note]Note

You can also generate the tables through the web API. This task is typically performed by a system administrator.

  1. Open the Reports app and click Analytics.

  2. Select the parts of the analytics process you want to skip:

    • Skip generation of resource tables

    • Skip generation of aggregate data and completeness data

    • Skip generation of event data

    • Skip generation of enrollment data

  3. Select Number of last years of data to include.

  4. Click Start export.