Setting Up Version-Based Security for Drill-Downs

Sarah MARECAR

I am working on Board and have created a cube with two versions: one that includes an 'Employee' dimension, and the other without it (version 0 being the base with the 'Employee' dimension).

In our Board screens, we have the ability to filter by 'Employees' and drill down to see the list of employees. However, some users need to see all the data/layout on these screens without being able to view or filter on the 'Employee' list due to confidentiality concerns.

Is it possible to set up security on the versioning so that users who don’t have access to the 'Employee' dimension can't see the employee list when drilling down? And how could this be done without having to replicate screens for each use case? I'm not sure if I'm being clear, but I hope this makes sense.

Thanks in advance for any advice.

Sarah MARECAR

Helmut Heimann

Hi @Sarah MARECAR ,

the version of a cube is only used for performance reasons, and the system chooses the version that has the best performance in a specific layout.

There currently is no way of using that version in the Database Security / Cube Visibility.

Best,
Helmut