Exporting data from PCMCS with DM how do I round the output values to 2 decimal places
Summaryround exported values from PCMCS to export file
There does not appear to be a way to export values from PCMCS with DM, so that the values are rounded to 2 decimal places.
The documentation refers to the Data Precision and Data number of Decimal. We set both of these to 2 and still values come out with 12 decimal places. I believe for ASO cubes these are invalid according to the note in the documentation.
"These settings works only in BSO cubes; they do not work in ASO cubes."
There is another reference to using SQL Mapping in data load maps code but it's only for ARCS. amountx = round(amount,2)