SAP BW connector - decimal as thousand separator

[dmckay1]

The SAP BW data in the SAP query shows: 1,234.99933 It comes out as 1.234.9933 after connection to SAP BW. I have messed around with changing the locale of the number, but that didn't help.

[nishalit]

Query Editor does not have a notion of "formatting", so you can't really configure a thousands separator. The data should come in as a Decimal Number column in this case, and you should be able to format it in various ways after it's been loaded to the data model. You can configure thousands separator and other options within the Data/Report views.