What person responsible for financial reporting has not had to contend with rounding? I don't know any. In previous lives and various tools, this has always been a challenge. In the manual spreadsheet world, sometimes 0.4 is rounded up and 0.6 is rounded down to enable footing.
The title of this is Scaling, Rounding and Footing , oh my, but could easily be a little "Tiptoe thru the Tulips" to get this built out as the solution that evolved here. Read on!
Numbers must be reported on a scaled basis that is rounded to zero decimal places.
The practice of adding Rounding adjustments on a scaled basis is standard in the past solution.
Utilize the user defined dimension set as the data type.
Dynamic Calc runs on parents (i.e., no aggregation – stored parent value is scaled and rounded) like base / children members. This can result in footing issues because the values to the “right” of the decimal that would add to the precision of the results are not there due to the rounding to zero decimal places.
Find a non-DynamicCalc solution for base members and allow data to naturally aggregate (foot) up.
Challenge: To replicate the DynamicCalc function in OneStream non-dynamically. Let's just say, it took a while and a lot of great minds!
Because values need to be scaled and rounded at all levels, the natural aggregation (i.e., footing) using Approach 2 is actually worse than the DynamicCalc (at parents) because the values to the “right” of the decimal adds to the footing precision of the results.
Executive management spot checks both the rounding and footing. Now do you get why it is important to get this to work?
Scaling, rounding and footing numbers is never easy. The precision of the values to be aggregated is really the key to the footing – that is, the rounding. But it is all based on how the end user needs to see the data – in this case, NOTHING past the decimal.
Knowing what I know now makes me think that extensibility in every application may be the way to go – in this case, it might have been overload as all other data is captured at the base G/L data level. Extensibility for rounding, but you never know.
I also know that sometimes you just need to keep plugging away, take a break, grab a coffee, take a walk, take a nap, do something else. Then come back to it because that solution might just pop into your head. The last solution came about after hours (ok maybe days), but the final approach seems to be one that is reasonable and acceptable to the client.
Want to learn more about Attribute Dimensions and OneStream Software? Please complete the form below and we'll get back to you shortly.
OneStream aligns to your business needs and changes more quickly and easily than any other product by offering one platform and one model for all financial CPM solutions. OneStream employs Guided Workflows, validations and flexible mapping to deliver data quality confidence for all collections and analysis while reducing risk throughout the entire auditable financial process.