Show TOC

Function documentationRowKey Range Locate this document in the navigation structure

 

The range of cells that is reserved for the member IDs used to return data to the rows.

Features

  • If your report or input schedule uses expansions, the system takes the member IDs for the range from the values defined in the Expand range parameter's Dimension and MemberSet rows.

  • If the report is static, the system takes the member IDs from the current view of the report or input schedule, or from other values specified in the Pagekey and CellKey ranges.

  • The number of columns in the range must correspond to the number of dimensions for which the current view is row-specific.

RowKey ranges and expansions

When an EvDRE function uses expansions, the following occurs:

  • The RowKey range (and/or the ColKey range) automatically resizes when you expand the data (  eTools   Expand All  ), and its content is populated with the members defined in the MemberSet parameter.

Note Note

The RowKey range must have two or more than two rows.

End of the note.

If the expansion criteria return no members, the row does not appear.

Activities

To define the RowKey range, from Interface for Excel, open the EvDRE report or input schedule you are building. In the RowKeyRange rows of the Key parameter table, enter a range of cells that contain the member IDs for the rows. For information about entering ranges, see EvRNG.