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?
S.R.Vaidya.
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
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.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
RIS Plus, LLC
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Relational - what a concept - why can't development stick with that?
http://mibuso.com/blogs/davidmachanick/
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n