Context:
1 role authorize all facts data with a filter in Dimension Data on a society
Need:
Some members in the first role need access to some facts (but not authorize on all facts) in other society
I create a second role with dimension data filter on other societies and cell data Enable read permissions with this code :"Measures.CurrentMember IS [Measures].[QUANTITE STOCK]"
Problem: Members in this second role AND in the first role can see all facts for all society.
For example, i want they can see [Measures].[CA HT N] only for the society in the first role but I want they can see [Measures].[QUANTITE STOCK] for all societies in the two roles.