Available dimensions

Lists the dimensions that are available in the active application. You can select one or more dimensions and place them on the In columns and In rows fields using the arrow icons.

In columns

Lists the dimensions that are placed in the column axis of the report. Use the up and down arrows to change the nesting order.

In rows

Lists the dimensions that are placed in the row axis of the report. Use the up and down arrows to change the nesting order.

Spread across worksheets

Lists the dimension that has its members enumerated across the worksheets. See Expansion Across Sheets.

Member selection

Displays the memberset for the dimensions.

See Edit Membersets in Drag and Drop Reporting.

Enable Expand Range

Select to generate an Expand range parameter.

See Expand Range Parameter.

Enable Options Range

Select to generate an Options range.

An Option Range is a range of cells in which you can define your EvDRE options. Alternatively, you can enumerate the options in a comma-delimited list in the Options field.

See EvDRE Options for the Microsoft version or EvDRE Options for the SAP NetWeaver version.

Enable Formatting Range

Select to generate a Formatting range. If not selected, you can still define a format range, but you must do it manually.

If selected, you can keep the default format (the standard report colors or the style template defined by the administrator in the EvDRE_STYLES application set parameter), or import the style from a predefined workbook (either local or server-based).

See Style Imports and Format Ranges.

Enable Sorting Parameter

Select to generate a Sorting parameter.

You can have the system automatically insert a break total into the worksheet, and choose to display the values in descending order.

See EvDRE Sorting Range.