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 previously on this list so be sure to check the archives. Best regards, Jason On Thu, Apr 24, 2014 at 8:30 PM, Emmanuel Willer CHARLES < [email protected]> wrote: > > Hi All, > > we are having error to run analytic reports, it lasts longer than usual. > when we try to run a resource table, we have the following error message. > Please Help. > > > > > ERROR MESSAGE > Link to error message: http://gyazo.com/d50d019cb8374ec38dcf020488c0167a > > Thank you for prompt answer. > -- > ___________________________________ > Charles Emmanuel Willer > 12,Lilavois 50 Croix des Bouquets, HT > Tels: +509-3842-3854 / +509-3270-0655 > Skype: emmanuelwiller > [email protected] > [email protected] > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
