Support for Pivot of Grids in Forms

A new option is available for data forms that enables you to transpose the grid by pivoting the rows and columns after a data load. The form option is called “Pivot Rows and Columns After Load” and is available in the Form Designer on Form Grid Properties, and at runtime.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Tax Reporting

Business Benefit: The ability to pivot rows and columns provides more flexibility when creating data forms and a configurable runtime option for how data is displayed.

Steps to enable and configure

You can enable this option from the Form Designer or from the Actions menu Edit option at run time.

Key resources

• Enterprise Profitability and Cost Management
  • Working with Forms 2.0 Grids in Dashboard 2.0 in Administering and Working with Enterprise Profitability and Cost Management
• Financial Consolidation and Close
  • Setting Form Grid Properties in Administering Financial Consolidation and Close
• FreeForm
  • Setting Form Grid Properties in Administering FreeForm
• Planning
  • Setting Form Grid Properties in Administering Planning
• Tax Reporting
  • Setting Form Grid Properties in Administering Tax Reporting