Question: Is there a way to force zeros into the cube from an api.data.calculate where one of the source intersections may have no data?

[OSAdmin]

Question (con't)

For example, if we have "Bonus = Sales * Bonus %", not all intersections in the sales account will have values but the client wants the result of the calculate function to load a zero to the corresponding bonus intersections.

Answer

• First, loading zeros into the database in the above situation would increase the amount of values being (arguably, unnecessarily) stored in the database. Be aware of inadvertently causing data explosion within the calculations. 
• Where both source accounts contain a value (a zero or otherwise), OneStream will store the result of the calculation. 
• In this example, if one of the source intersections does not contain a value (i.e is NoData), then the implementer will need to force the source cell amount to zero in order for it to be part of the calculation. The calculation will then create a zero which OneStream will store. 
• Note: in this situation do not use the RemoveZero/RemoveNoData functions or an eval statement to remove NoData or Zero value cells from the calculation.   

Example:

Source: Office Hours 2020-7-2 - Partner Enablement