Question: When exporting data to excel from a cube view, is it possible to export the scaled values as the true value? The data is being extracted for loading into another system (Workiva) which the client wants to load scaled amounts.

• 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