Advanced Downloads for Event Reports

I’m getting the following for just about every event report I make:

Here’s the link that generates it:

https://play.dhis2.org/2.30/api/29/analytics/dataValueSet.json?dimension=pe:LAST_12_MONTHS&dimension=ou:ImspTQPwCqd&filter=bx6fsa0t90x:IN:1&stage=A03MvHHogjR&displayProperty=SHORTNAME&outputType=EVENT

The Event Report looks like:

I’ve tried many different layouts and I can’t seem to make a single advanced “dataValueSet” download to work for event reports.

Has anyone been able to make those work? Should they work? I wondering if they even make sense, since they are for system to system interoperability of aggregated data, In this case I was trying to take total BCG doses given at birth, by month, for the whole country.

Dimension identifier does not reference any dimension: bx6fsa0t90x isn’t enough for me to go on though.

···

Timothy Harding
Sr. Systems Analyst, BAO Systems

+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 507, Washington D.C. 20007

Hi Timothy,

Something seems wrong. Let us look at it.

Jan

···

On Mon, Sep 10, 2018 at 4:21 PM Timothy Harding tharding@baosystems.com wrote:

I’m getting the following for just about every event report I make:

Here’s the link that generates it:

https://play.dhis2.org/2.30/api/29/analytics/dataValueSet.json?dimension=pe:LAST_12_MONTHS&dimension=ou:ImspTQPwCqd&filter=bx6fsa0t90x:IN:1&stage=A03MvHHogjR&displayProperty=SHORTNAME&outputType=EVENT

The Event Report looks like:

I’ve tried many different layouts and I can’t seem to make a single advanced “dataValueSet” download to work for event reports.

Has anyone been able to make those work? Should they work? I wondering if they even make sense, since they are for system to system interoperability of aggregated data, In this case I was trying to take total BCG doses given at birth, by month, for the whole country.

Dimension identifier does not reference any dimension: bx6fsa0t90x isn’t enough for me to go on though.

Timothy Harding
Sr. Systems Analyst, BAO Systems

+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 507, Washington D.C. 20007


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

Hi Tim,

we do not support the data value set responses for event analytics, only for aggregate analytics. Docs here.

https://docs.dhis2.org/master/en/developer/html/webapi_analytics.html#webapi_analytics_data_value_set_format

When you think of it, the data value set analytics response is meant to transform aggregated data into the data value set format, so that the output mimics raw, routine data values, even if it has been aggregated first by the system. This concept does not apply so well to event analytics, where you normally look at counts of various options (there is no single data element/option combo to link to per data value).

Note that the aggregated analytics API lets you retrieve aggregated values for tracker/event data elements (which in fact are possible to aggregate) as well as for program indicators, so if the report you are looking to create can be made from aggregated event values (e.g. not counts of options) you can retrieve it that way.

regards,

Lars

···

Lars Helge Øverland

Technical lead, DHIS 2

University of Oslo

lars@dhis2.org

https://www.dhis2.org

1 Like

Thanks Lars,

Would it be best to remove that from the drop down list since it isn’t meant to work in the event view?

As I can see this would be confusing to others who find it there and expect it to work similarly.

My use case can only work if I create a program indicator and use the pivot table. Not as elegant as the event reports, but it works.

···

Timothy Harding
Sr. Systems Analyst, BAO Systems

+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 507, Washington D.C. 20007

1 Like