How to enable BPC security at node level without adding secured dimensions to prompts in Bex Query

[former_member719935]

Hi Experts,

We have a BPC security requirement as below

System: S/4HANA (1809)/BPC Optimized.

Requirement:

We have 3 secured dimensions and security requirement is to restrict users at dimension node level.

Example:

Restrict report access to users at Profit Center node level

1.US Corporate User (Has widespread access to US PCs)

2.IT Corporate User (Has widespread access to IT PCs)

3.NZ Corporate User (Has access to NZ PCs)

4.Etc.

Issue:

One option we can think of achieving this requirement is to add secured dimensions as mandatory prompt variables in the Bex queries after doing the required settings in RSECADMIN.

We are looking for other options where we can avoid adding secured dimensions in the prompts as users are not willing to have secured dimensions in the prompts of all the reports.

Appreciate any thoughts or suggestions.