Order of Supporting Detail

The supporting detail order affects the resulting value that is saved to Essbase. Understanding the calculation order helps you correctly enter supporting detail. Supporting detail leverages the calculation order of + (addition), - (subtraction), * (multiplication), and / (division). A simple Unit times Rates example demonstrates how to correctly enter supporting detail.

Incorrectly Entering Supporting Detail

Because Rate in this following table is set to the unary operator +, the calculation order first adds the Rate and then multiplies by the Unit, resulting in incorrect data being saved.

	Jan	Feb	Mar
Rate +	250	250	250
Unit *	10
Total:	2500	250	250

Correctly Entering Supporting Detail

This following table demonstrates the correct order of the Units times Rates calculation, with correct values saved.

	Jan	Feb	Mar
Unit +	10.0
Rate *	250.0	250.0	250.0
Total:	2500

Verify the supporting detail order, ensuring that correct values are calculated and saved.