- OneStream is storing the true value and using a number format to display the values as scaled. If the client only takes scaled amounts, rounding could cause reports to not foot correctly in Workiva.
Possible options:
- Dynamic calculation on the Cube View which would return the values divided by the scaling amount and rounded to 0 decimal places – may impact the report run time.
- Use a data adapter (e.g CubeView FDX) in a business rule and process the data to scale as necessary and export to a CSV file.
Source: Office Hours 2020-7-16 - Jerri McConnell