Analytics tables - only data elements - where are indicators?

I’m trying to pull some data from the analytics tables rather than using the datamart tables. Unlike aggregatedindicatorvalue table from the datamart it seems like the indicators are not pre-calculated in the analytics tables. Is that right?

If that is the case are the indicators calculated on the fly from the analytics table or are they stored somewhere else. This does not seem to be well documented.

Randy Wilson

Hi Randy,

···

On Thu, Apr 10, 2014 at 4:12 PM, Wilson,Randy rwilson@msh.org wrote:

I’m trying to pull some data from the analytics tables rather than using the datamart tables. Unlike aggregatedindicatorvalue table from the datamart it seems like the indicators are not pre-calculated in the analytics tables. Is that right?

Correct.

If that is the case are the indicators calculated on the fly from the analytics table or are they stored somewhere else.

They are calculated on the fly in the application layer.

This does not seem to be well documented.

The analytics tables are not really designed to be used directly, rather through the web api resource which is pretty well documented here: http://www.dhis2.org/doc/snapshot/en/user/html/ch29s19.html

I can only guess that you want to use such direct SQL queries in iReport - the problem is that iReport does not support well the use of web apis (think using JSON or XML as data source) as far as I know (and is getting a bit dated in my opinion). Would be interesting to hear if someone has been able to integrate web api data responses in iReport or other report design tools.

regards,

Lars

Hi all, I must to run a min/max in my dhis2 localhost but, I don’t see a result. can you help me about this problem because now, we are in the DHIS2 training.
Thanks

···

2014-04-10 7:39 GMT-07:00 Lars Helge Øverland larshelge@gmail.com:

Hi Randy,


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

On Thu, Apr 10, 2014 at 4:12 PM, Wilson,Randy rwilson@msh.org wrote:

I’m trying to pull some data from the analytics tables rather than using the datamart tables. Unlike aggregatedindicatorvalue table from the datamart it seems like the indicators are not pre-calculated in the analytics tables. Is that right?

Correct.

If that is the case are the indicators calculated on the fly from the analytics table or are they stored somewhere else.

They are calculated on the fly in the application layer.

This does not seem to be well documented.

The analytics tables are not really designed to be used directly, rather through the web api resource which is pretty well documented here: http://www.dhis2.org/doc/snapshot/en/user/html/ch29s19.html

I can only guess that you want to use such direct SQL queries in iReport - the problem is that iReport does not support well the use of web apis (think using JSON or XML as data source) as far as I know (and is getting a bit dated in my opinion). Would be interesting to hear if someone has been able to integrate web api data responses in iReport or other report design tools.

regards,

Lars