Skip to Content

Editing a key figure in current period at aggregated time period

Nov 08, 2017 at 10:51 AM


avatar image

Dear SAP experts,

Let's consider the following scenario:

  • Key Figure KF_X is defined at Month level
  • KF_X has 'Editable in the Current or Future' mode selected
  • In Excel view user sees KF_X values aggregated to Year level
  • User edits data for KF_X at Year Level
  • For Previous Years system will decline the changes (OK)
  • For Future Years system will allow the changes (OK)
  • For Current Year system will decline the changes as Year aggregation contains Months that are in the past (NOT OK)

The question is the following: what is the best way to work around this problem so that a user can still edit values for the Current Year without changing KF_X to as 'All editable' ?

10 |10000 characters needed characters left characters exceeded

Sorry, but how this question is related to the tag:

EPM Add-In for Excel


Hi Vadim,

In fact the only way we've found to resolve the issue is to open the figure for editing while using the data validation functionality embedded to EPM.

Feel free to propose any other tag you might feel to suit better than that.

Best regards,


* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Rohit Ranjan
Nov 09, 2017 at 11:03 AM

Hello Vladimir

This is an expected behavior. System disaggregates value based on lowest storage level of planning area. See SAP note- 2438953

However if you feel it is a valid business requirement, you can post the feature enhancement request using SAP influence channel (SAP note 2479068)



10 |10000 characters needed characters left characters exceeded