Working with Supporting Detail

Supporting detail helps you understand the basis of the data that is not in the member outline. For example, if the bottom-level member in your outline is pens, you can add line items in supporting detail for ballpoint, fountain, marker, and so on. Then you can aggregate their values to the pen member.

Supporting detail helps you build and communicate bottom-up values when planning corporate expenses such as travel and projects, where you must calculate aggregate values. Supporting detail can include text, values, and operators that define how data aggregates.

About supporting detail:

  • Supporting detail does not change members in the outline.

  • To create, change, or delete supporting detail, you must have write access to cells. You must have read access to view supporting detail.

  • To protect values, you cannot enter, adjust, spread, and save data into aggregate values that have supporting detail. The aggregate values are read-only.

  • You can add supporting detail to target and bottom-up versions.

  • You can't add supporting detail to Summary Time Periods, such as Quarters. You can add it only to base time periods (level-0 members).

  • Number and precision formatting is not reflected in the Supporting Detail window.

  • The sequence of operators follows the same logic as is used to process multiple operators in a complex calculation.

  • You can print supporting detail.

  • When using Copy Versions, you can copy supporting detail from one version to another.

  • Your administrator can copy data, including supporting detail, from one dimensional intersection to another. For example, administrators can copy Budget, FY19, Final to Forecast, FY20, First Draft. They can also copy data from one business unit to another, or from FY19 to FY20 to prepare a budget.

See Adding Supporting Detail.