changing a series of dimension values

(0) Share

Report

Posted on by keoma

32,729

hi,

one of our customers wants to change a series of dimension values with the same dimension code (cost centre). a special thing is that there are a bigger number of blocks that should go in each case to only one new dimension value, e.g. some "old" dim. values "cost centre"/A1000 (A1000 means the value of field Code, the 2. prim. key), "cost centre"/A1001, ... should go to one new dim. value "cost centre"/100.

in general some dimension values are used in a huge amount of tables/records. after changing/renaming the data integrity of the dimension values should be as well es before!

it should be done in a CU or in a processing only report.

any ideas? thx

best regards

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Jens Glathe 6,092 on at

Like (1)

Report

Hi Jonathan,

this is probably a common issue, "every" customer with dimensions I have worked with has some cutomizations to achieve this. Generally, if you have no overlap (source value range and target value range are completely distinct) you can do this with a translation table and the RENAME function on T349 "Dimension Value". If everything is correctly linked (table relations are unmodified/correct for new fields), then using RENAME is the most reliable and probably the fastest way (can't believe it - relative to coding effort) to do this. If the source and targed value ranges intersect, then you need to do this with double renames.

Renames can take a long time in a NAV database, though. Therefore it is recommended to do this as a batch job.

There are caveats, though:

- You need to have access rights to all tables with dimension values. If you have a portion of data that can't be accessed with the used license, this could lead to an error.

- All (I really mean all) tables must be compiled. Otherwise you will get an error on this table, leading to a rollback.

I have no "renaming toolkit" ready to publish it, though. Maybe you can find something in the mibuso downloads.

with best regards

Jens

Was this reply helpful? Yes No
Saurabh Shah 4,560 on at

Like (2)

Report

Hi,

below are some Dimension Correcting Tools for your reference purpose:

www.mibuso.com/dlinfo.asp

www.mibuso.com/dlinfo.asp

Regards,

Saurabh Shah

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

hi,

could following work for renaming of dim. values a,b,c to d?

* rename dim. value a to d.

* delete dim. value d.

* rename dim. value b to d.

* delete dim. value d.

* rename dim. value c to d.

ready

Was this reply helpful? Yes No
Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

Hi Jonathan,

as long as you do a delete without calling the OnDelete() trigger of T349 "Dimension Value", this will work. Done it my self on occasions.

with best regards

Jens

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

i think there is a dimension change tool available in NAV 2103 R2 but we suggest not to use it

Was this reply helpful? Yes No
Saurabh Shah 4,560 on at

Like (0)

Report

Hi Narayan,

As far as I know, there is no any such tool available in NAV 2013 R2 to update the posted dimension values in entries. (Replace existing dimension value with new one)

If you find it then please share that with us.

Regards,

Saurabh Shah

Was this reply helpful? Yes No