Show TOC

Function documentationExpansion Functions Locate this document in the navigation structure

 

Functions that allow dynamic expansion of dimensional data in reports and input schedules.

Features

When you use expansion functions in reports and input schedules, you can use the following features:

  • You can dynamically expand dimensional data based on criteria defined in the expansion formula

  • In the expansion formula, you can specify whether to expand the report by row, column, or both; and on which member to base the expansion criteria.

    Note Note

    The expansion copies the first row if there is no column expansion; it copies the first column if there no row expansion; and it copies the upper left cell of the data range if there is both first row and column expansion.

    End of the note.

  • When you choose a cell that contains an expansion formula, the system restructures the report to include the new members, while maintaining its original design.