← Back to team overview

dhis2-devs team mailing list archive

Re: Unable to generate event reports

 

Hi Mansi,

Can you check in your database whether you have any tables of the type
"analytics_event_2014_XXX" and whether they contain any data?
The last part of the table name, "XXX", refers to the uid the program it
contains data for, it's one table per program. 2014 is the year, so if your
data is from 2013, look for 2013 tables.

The events shown in Event Reports/Visualizer are fetched from these event
analytics tables.

If you have data in the event analytics tables, then it is a matter of
doing the right selections in the left side menu of the Event Reports. Try
"individual cases mode", all data items for your program+stage where you
know you have data, then try the root (top) orgunit and maybe last 12
months in the period (if you have recent data).

Ola
---------


----------------------------------
Ola Hodne Titlestad (Mr)
HISP
Department of Informatics
University of Oslo

Mobile: +47 48069736
Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link
<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>


On 3 September 2014 11:21, Mansi Singhal <msinghal@xxxxxxxxxxxxxxxx> wrote:

> Hi,
>
> We have event capture data in the DB. We want to generate event reports
> and charts.
> We have done the analytics and data mart table export. But still the event
> report app shows "No Values Found".
>
> Are we missing something?
>
>
> --
> Regards,
> Mansi Singhal
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

Follow ups

References