Re: [Dhis2-devs] [Dhis2-users] runing Analytics errors.

2014-04-24 Thread Dapo Adejumo
Hi, This is related to a bug with analytics and sql views that was initially fixed but seems to have crept in again. It will need to be fixed – A temporary workaround is to delete sql views from your database. Regards, Dapo Adejumo +2

Re: [Dhis2-devs] [Dhis2-users] runing Analytics errors.

2014-04-24 Thread Jason Pickering
Hi Emmanuel, It is not possible to have views linked directly to the resource tables, as they are dropped and regenerated each time when the analytics runs. Two options. 1) Encapsulate your view in a stored procedure. 2) Use the SQL view function of DHIS2. Both approaches have been discussed pre