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
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
On 3 September 2014 11:21, Mansi Singhal msinghal@thoughtworks.com 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Hi Mansi,
I suspect the analytics process failed during the event tables stage.
Did you merge in the fix I did when this issue was raised last week? See
here:
http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/revision/16536
regards,
Lras
Hi Mansi,
Those tables are generated as part of the analytics process.
No errors in the log from the analytics process?
Ola
On Thu, Sep 4, 2014 at 2:19 AM, Lars Helge Øverland larshelge@gmail.com wrote:
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 Mansi,
I suspect the analytics process failed during the event tables stage.
Did you merge in the fix I did when this issue was raised last week? See here:
http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/revision/16536
regards,
Lras
Hey Ola,
There were no bugs when ran analytics process. It all went fine.
Mansi.
On Thu, Sep 4, 2014 at 10:09 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:
Hi Mansi,
Those tables are generated as part of the analytics process.
No errors in the log from the analytics process?
Ola
- sep. 2014 04:35 skrev “Mahendra Kariya” mahendra.kariya@thoughtworks.com følgende:
Hi Ola,
We don’t see any table of the type “analytics_event_2014_XXX” in the database. Could you please give us more details on how these tables are generated?
Hi Lars,
Yes. That fix is merged with our branch.
Thanks,
Mahendra
ThoughtWorks
–
Regards,
Mansi Singhal
+91 9900246052
On Thu, Sep 4, 2014 at 2:19 AM, Lars Helge Øverland larshelge@gmail.com wrote:
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 Mansi,
I suspect the analytics process failed during the event tables stage.
Did you merge in the fix I did when this issue was raised last week? See here:
http://bazaar.launchpad.net/~dhis2-devs-core/dhis2/trunk/revision/16536
regards,
Lras