Max. no. of dimensions in Navision

srvaidya.63 · 2008-04-07

Hello,

As per the online help of Navision you can define as many dimensions as you wish to.But we generally do not define/use more than 8 dimensions.
(2 global + 6 shortcut).

Is it to optimise on performance or are there any other reasons?

kine · 2008-04-07

It is better for performance. Each dimension means one record per each ledger entry record (Item Ledger entry, GL Entry, Value entry, Job entry, Resource Entry etc.) and it means big pile of records per posting. And filling all necessary dimensions before posting means big job...

ara3n · 2008-04-07

I'm curious why they didn't implement it with a limit. And if somebody wanted to additional dimension, you could modify it.

There is already a limit based on performance.

I would have the Ledger Entry Dimension table restructured, with PK equal Entry No., and Add 10 or 20 field as max number of dimension as attributes to the table. That way you have 1 to 1 records per Ledger Entry,

To further improve performance, I would have a separate Dimension table for each ledger entry table.

DenSter · 2008-04-07

Might as well just add the dimension fields to the ledger tables themselves.

ara3n · 2008-04-07

And we are back to square one.

davmac1 · 2008-04-07

I think adding the dimensions to the tables is a much simpler solution. The dimension logic is far too cumbersome currently.
Relational - what a concept - why can't development stick with that?

ara3n · 2008-04-07

I usually try to keep the number of dimension as small as possible. and add the additional dimensions to Ledger entries. It makes reports and filtering much easier.

Max. no. of dimensions in Navision

Comments

Categories