Show TOC

Function documentationEvDRE Locate this document in the navigation structure

 

You use the EvDRE (Data Range Exchange) function to generate Planning and Consolidation reports and input schedules.

Features

The flexible EvDRE function provides the following features:

  • You can use EvDRE to create large reports or input schedules with optimal performance.

    By accepting cell ranges as parameters, EvDRE workbooks are faster to download and upload because there are no send or retrieve functions in the data cells.

  • EvDRE is bidirectional; it can both send and retrieve data. It combines and extends the functionality of other Planning and Consolidation functions such as EvGET and EvSND. EvDRE is faster than these functions because it does not evaluate each cell.

  • You can use EvDRE to build static workbooks (without expansions) as well as dynamic workbooks (with expansions), or workbooks where some dimensions are defined using static members while others dynamically expand.

  • You can define one or more expansions on the rows, columns, or both simultaneously.

  • Workbook options determine how EvDRE sends data. If the workbook option Type is set to Report, you cannot send data; if the option is set to Input Schedule, the template can retrieve and send data. See Workbook Options.

  • For the Microsoft version only, you can create a new style template from an active EvDRE workbook. The following commands are available from the eTools menu:

    • Open EvDRE default Styles. You select this menu option to open the default style template. You can edit it, and then use Save EvDRE Default Styles to save it.

    • Save EvDRE default Styles. You select this menu option to save the current formatting as a style template.

    After defining the template, you can go to Application Set Parameters to define it as the default template for all users creating EvDRE workbooks. After a default template is defined there, changes saved to that template are automatically applied to newly created EvDRE workbooks (that is, there is no need to reset the application set parameter). Changes to a style template do not affect workbooks previously created from the same template. You can define one default style template for each application set. For more information, see Application Set Parameters.

Activities

To create an EvDRE report, use EvDRE Builder or the Drag and Drop Reporting feature.