How to get indicator value in analytics table?

Support - Assistance technique
1

hi,sir,

I found the analytics table only have DE, no INDICATOR, so ,how to got indicator value?

got indicator defintion, got de, calculate dynamicly?

···

–
此致

easy

莫愁前路无知己，天下谁人不识君。

2

Hi easy,

you cannot get indicator values directly from the analytics tables. Indicator values are calculated on-the-fly in the “analytics engine” based on the data. So you need to go through the Web API (or Java API if so inclined) to retrieve these.

Web API docs: http://www.dhis2.org/doc/snapshot/en/user/html/ch25s20.html

Java API docs: http://www.dhis2.org/download/apidocs/org/hisp/dhis/analytics/AnalyticsService.html

Lars

PS If you really need to pull out indicator values from the database with SQL (not recommended anymore!) you will have to run data mart and retrieve it from the aggregatedindicatorvalue table.

···

On Thu, Sep 12, 2013 at 11:56 AM, easy lin_xd@126.com wrote:

hi,sir,

I found the analytics table only have DE, no INDICATOR, so ,how to got indicator value?

got indicator defintion, got de, calculate dynamicly?

–
此致

easy

莫愁前路无知己，天下谁人不识君。

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp