I was faced with problem during saving decimal data via Excel input schedules. We use BPC 7.0 MS, SQL Server 2008.
One of the main customer demands is using decimal comma (",") due to Russian regional settings and standards. We've switched server regional options and one of the client machine's regional options into Russian, all integer data is sent to SQL correctly but during saving decimal data we got error - Type mismatch.
Do you mind how to solve this issue? Or it is possible only using English standarts?
Thanks for your help.