Show TOC

Function documentationColKey Range Locate this document in the navigation structure

 

The range of cells reserved for the member IDs used to return data to the columns.

Features

When you use the ColKey Range, note the following:

  • 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.

  • On a static report, 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 rows in the range must correspond to the number of dimensions for which the current view is column-specific.

  • You can inset text, blank spaces, or formulas (like break totals) into rows or columns within the data range, without breaking the column or row key ranges in multiple ranges. If you leave at least one blank cell in the column or row keys, the corresponding column or row is not affected by the function.

ColKey ranges and expansions

When an EvDRE function uses expansions, the following occurs:

The ColKey range (and/or the RowKey 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 ColKey range must have two or more columns.

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

End of the note.

Activities

To define the ColKey range, from Interface for Excel, open the EvDRE report or input schedule you are building. In the ColKeyRange rows of the Key range parameter table, enter a range of cells that contain the member IDs for the columns. For more information, see EvRNG. Save the report or input schedule.