dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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 <
emmanuelwiller@xxxxxxxxx> 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
> emmanuelwiller@xxxxxxxxx
> emmanuelwiller@xxxxxxxxx
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>