Is there a possibility to automatic Update of Analisys View

easy-navi

Hello,
Is there any possibility to Update the Analisys View Card using an automated job (and run it at night)???

The problem is that our customers often needs to change the dimension values at the posted
documents. So we have made for them such a modification.
The problem is only with Analisys view entry table, beacause to the only way (i know) to refresh it is to delete the entries and than re-create it. Navision have such a job but it rather long-runnig job. So my question is to automate that process and run that job at night (for example). Is it possible somehow??
Nav=4.03
SQL= mssql 2005

Jack, Poland

jannestig

Have you considered changing your modification so that upon change it triggers the automatic update such as when the original document is posted. Otherwise setup the codeunit to run overnight.

Why does the customer need to update posted documents anyway? It may be better to find out the reasons they post with the wrong dimension in the first place or if they need a verification step before post

themave

We run it in the job scheduler every nigh, have you tried it.

it is easy to do.

ara3n

I suggest to not update during posting. Main reason is performance and locking. As mentioned above, do it overnight.

easy-navi

themave wrote:

We run it in the job scheduler every nigh, have you tried it.

it is easy to do.

Themave -
I mean you do it using the Navision Application Server??
Or there is some easier way??

themave

easy-navi wrote:

themave wrote:

We run it in the job scheduler every nigh, have you tried it.

it is easy to do.

Themave -
I mean you do it using the Navision Application Server??
Or there is some easier way??

in version 4.0 there is a job schedular that is part of the service module, it is not ran with the application server, that is what we use.

David_Singleton

themave wrote:

easy-navi wrote:

themave wrote:

We run it in the job scheduler every nigh, have you tried it.

it is easy to do.

Themave -
I mean you do it using the Navision Application Server??
Or there is some easier way??

in version 4.0 there is a job schedular that is part of the service module, it is not ran with the application server, that is what we use.

And this can be quite easily ported to later versions.