You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Exporting data from PCMCS with DM how do I round the output values to 2 decimal places

Received Response
11
Views
7
Comments
edited Aug 11, 2021 6:58PM in EPM Platform 7 comments

Summary

round exported values from PCMCS to export file

Content

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!