Skip to Content
Former Member
Sep 08, 2016 at 01:45 PM

How to make some cells non editable in excel for a key figure which is defined as editable



Our requirement is to make certain cells of a key figure as non editable in the excel front end. This key figure is essentially defined as editable in configuration. Some use cases for this requirement are:

1. Price changes should not be possible at aggregated levels but should be possible at dis-aggregate level

2. A key figure becomes non editable if some other key figure is populated

For similar requirements in DP we used Cell_input() operator. Do we have something possible for IBP as well?