how to set decimal precision in Data Exchange while loading exchange rates to planning

Summary:

We are running a SQL to extract exchange rates from EBS and loading to planning. In cloud, it looks like the decimal precision stops at 4 when I retrieve the rates in smartview. I thought the underlying Essbase would store it up to 16 decimal point.

When the same SQL is run in on-prem essbase and retrieved through smartview, the precisions are more than 4 (basically showing whatever is there in EBS)

Is there a way to set the decimal precisions in Data Exchange?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):