Analysis View Entry

asiri-cooray

Hi,

We have converted the NAV DB from Native to SQL. All the other functions are properly running but in the Analysis by Dimension functionality is not running. It's hanging in the filter options and waiting and cannot see the data also. This analysis Entry table has grown upto 20GB.

Are there any way to speedup this process.

Thks,
Asiri

ufuk

Have you tried Optimize function in Navision?

kriki

-Which version of NAV?
-Which version of SQL?
-Do you have a maintenance plan for rebuilding the indexes? What is the fillfactor (best use 90% as an average).
-Are you sure your tables have a clustered index? (this is a NAV4.0SP1 bug on SQL). If you NEVER had NAV4.0SP1, this should not be a problem.
-NAV optimize-function is not needed. There are better tools (and if you have 5.0SP1 or later, even these tools are not needed).

asiri-cooray

Hi Kriki & Ufuk,

Thks for your replies. Versn of NAV is 4 SP3 but technically converted to the NAV 2009 SP1.
SQL Version 2008.

Is it necessary to rebuild the indexes? if so, can u explain the steps to rebuild the indexes (this DB size is early 90 GB).
At the same time can u pls explain how to change the fillfactor also.

Thks,
Asiri

kriki

Index rebuilding is the LIFE of the SQL server (Specially if the size of the DB is bigger than the DB-cache). Without it you get a lot of performance problems.

Download this ebook: http://www.simple-talk.com/books/sql-books/brads-sure-guide-to-sql-server-maintenance-plans/.
It explains how to create a maintenance plan and some basics about the rebuild index.

slmaluwa

Is there a way to recreate the Analysis View Entry? We have restructured or changed some of Dimension attributes and needed to analyse based on the current structure.

kriki

Delete all entries in the table 365:"Analysis View Entry" and reset "Last Entry No.","Last Budget Entry No." to 0 in table 363:"Analysis View".