Master Data Services - Numeric fields arbitrary maximum of 7 Decimals unnecessarily restrictive - by DeeBeeGee

Status : 


Sign in
to vote
ID 795497 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 7/31/2013 4:21:35 AM
Access Restriction Public


Would it not be better to make the maximum decimals allowed for a numeric field a configurable item to allow the administrator to decide what is a reasonable in the context of the application. 

After all, everyone has different needs..

While there is a workaround it is quite cumbersome and not explicitly supported. An alternative method of multiplying the value by a factor to move the decimal point (eg pi = 31415.9265359 / 10000) is a sure fire way to get input errors

See thread below for proposed workaround using mds SPs and a further issue with the way numeric datatypes are defined
Sign in to post a comment.
Posted by Microsoft on 8/1/2013 at 9:35 AM
Hello DeeBeeGee. After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap. Note that the article you reference states that five decimal precision is within 0.000084%. Thanks again for providing the product suggestion and continued support for our product.

-Walter A Jokiel, Program Manager, SQL Server (