1 Cube with 2 roles : Public role and Private Role. Public Role will use cell security to define wich cell values are public. Private Role will allow any cell to be seen
My problem is:
When a user connect to the cube with Public role he will se "value" or "#N/A". When a user connect with Private Rolw i wiil see onlyt "value". How can i tell the user in the last case which values are defined as "value" or "#N/A" based on the public role ?
I really need to tell my private user which values are public and which values are private, and i can only do that using cell security within a public role which the private user doesn't belong