Consolidation and Analysis View

seckpin

Our company has just implemented Nav4 SP3 with SQL 2005. We are facing serious performance issue when running consolidation and updating Analysis View. For just two weeks of data, the consolidation process can run more than 5 hours. For Analysis View updates, it can take up to 6 hours per card (while we have 6 Analsysi Veiw cards).

We are implementing Nav in phases, and just for the first phase, our average number of G/L entries per day are already at 30K+ lines. We are also using a lot of different Dimensions and almost all transactions have more than two Dimensions to be captured. The future phases will only get worse.

We were told by the consultants that the sheer number of entries are the cause of the slow performance. (Then does it mean that Nav is never meant for companies with high volumes of transactions?) We may need to go the manual way of consolidating our accounts, i.e. to print out the financial statements of each companies and add them up manually in Excel.

I'm wondering if there's any other ways than to do it manually? Is it possible to customize the consolidation and update Analaysis View program to improve the performance?

Thanks in advance for your kind advice.

Albertvh

Hi

You could use the job scheduler to run these after hours

Hope this helps

seckpin

Yes, this was mentioned as one of the solutions by our consultants too. But the problem is that we are already running some processes in the night (interface with other systems), and we don't have the luxury of 10 hours to run the consolidation and update Analysis View processes in the night. We are in retail business and we can't run these processes during operating hours either. So we are stuck.

kriki

If you use SQL, no need to keep all SIFTlevels of the primary key. Disable levels you don't need and it will go a lot faster.