IBP Excel Formatting - Default format for (non-) editable cells in combination w/ permission filter

[peter_casper]

Dear community,

the capability to format editable and non editable cells in a different way just based on the respective authorization of the user was intoduced a couple of releases ago. The feature works pretty well in case the authorizations are generally on key figure level only and not dependent on any limiting permission filter.

However I recognized that the formatting is not getting properly applied in case of permission filter usage. So e.g. if someone has write access to key figure SalesFcst for a specific country and read access for all other countries, the formatting of KF SalesFcst is always (so for every country) according to the format setting for "Default Fformat for Editable Cells". However saving of data for countries which are read only is not possible. The backend is appropriately rejecting entries where the user is lacking write access.

Is it possible to influence the formatting also based on the permission filter in order to be visually in line w/ the authorization setting?

Maybe there is a hidden feature or I simply overlook an essential setting.

Example:

Br, Peter

[Irmi_Kuntze · Accepted solution]

Hi Peter

If you check online help you'll find:

"It is not possible to set up formatting in the SAP IBP Formatting Sheet to highlight cells that the user has write permissions for or format cells that the user can't change because of a permission filter. Since checking permissions provided by permission filters that are assigned to a user happens in the SAP IBP backend, it is not immediately visible which cells the user can't edit when they first open the planning view...."

Yours

Irmi

[peter_casper · Accepted solution]

Hi Irmi,

I obviously missed this bit of online help. So in essence this means that there is no chance to visualize which cells are finally editable and which not once permission filters come into play. Not ideal but nothing we can change quickly.

Thanks for your reply.

Cheers Peter