What is ColKey range in SAP EPM-BPC - Business Planning and Consolidation?

SAP Term: ColKey range

• Component: EPM-BPC

• Component Name: Business Planning and Consolidation

• Description: The range of cells in a spreadsheet that is reserved for the member IDs used to return data in the columns. If a report or input schedule uses expansions, the member IDs for the range are taken from the values defined in the Expand range parameter's Dimension and MemberSet rows.

Smart SAP Assistant

• Key Concepts: 
  ColKey range is a feature of SAP Business Planning and Consolidation (EPM-BPC) that allows users to define a range of values for a particular column. This range can be used to filter data in reports and other documents. The ColKey range is defined by the user and can be used to limit the data that is displayed in reports and other documents. 
  
  How to use it: 
  To use the ColKey range, users must first define the range in the EPM-BPC application. This can be done by selecting the “ColKey Range” option from the “Data” menu. Once the range has been defined, it can be applied to reports and other documents by selecting the “ColKey Range” option from the “Filter” menu. 
  
  Tips & Tricks: 
  When defining a ColKey range, it is important to remember that the range must be defined in terms of absolute values. For example, if you want to filter data between two dates, you must specify both dates in absolute terms (e.g., 01/01/2020 and 12/31/2020). 
  
  Related Information: 
  The ColKey range feature is similar to other filtering options available in EPM-BPC, such as the “Filter by Value” option. However, the ColKey range feature allows users to define a more specific range of values for a particular column.