Database precision

Decimal precision is used to round results before writing back to the database tables. In general, precision is based on the setting specified for the Currency dimension though there are exceptions. For example, the consolidation engine always uses the precision of the Currency dimension.

For Detail Budgeting analysis views, the precision set under Update View Properties is used for display purposes. Data is not rounded during calculations or when writing back to the table.

For journals and intercompany data, you have the option of setting precision as a line attribute. If the line precision is missing, it defaults to the precision of the Currency dimension. If the currency precision is missing, it defaults to the system default.

The system default is set using the System Decimal Precision global setting which is set on the Model Settings page.

Here are some guidelines for changing the precision:

• Set System Default Precision to a value that is applicable for most of the financial data in the application, then set decimals for currencies that require different precisions.
• Only set a special precision for formula lines or lines with user-defined formulas if the calculated values require a different precision than the precision of the currency or the system.
• For financial data (expenses, income, assets, liabilities, etc.), let the system's or currency's decimal setting dictate the precision of the data.
• For non-financial data (statistics, head count, square footage, etc.), let the line's decimal precision dictate the precision of the data.