cancel
Showing results for 
Search instead for 
Did you mean: 

Editing a key figure in current period at aggregated time period

vdorodni
Explorer

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' ?

former_member186338
Active Contributor
0 Kudos

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

EPM Add-In for Excel

vdorodni
Explorer
0 Kudos

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,

Vladimir

Accepted Solutions (1)

Accepted Solutions (1)

former_member242371
Contributor
0 Kudos

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

https://influence.sap.com/IBP (SAP note 2479068)

Thanks,

Rohit

Answers (0)