Hi experts,
Seeking your opinion and expert assistance with an issue related to applying time functions to a cube in the same layout where cube visibility is applied for data visibility restriction.
If you use cube visibility function to lock a cube in the first picture below it works. However, If you then apply a time function on a cube in the same layout, the cube will show the values and ignore the cube visibility lock and then negate the security selection applied on the cube visibility feature and hence all data will be available for the user to browse regardless of the selection applied.
My question is are we configuring this incorrectly when trying to apply a time fuction on a cube in a layout where cube visibility is being applied or is this a known bug?
Images of the issue shown below
- Cube visibilty with no time function applied
2) Cube visibilty with time function applied - this happens with both yearly cumulated value and yearly moving total (the others have not yet been tested)
@Alex Pelucchi
Thanks
Ken