maretix (3/20/2015)
Dimension Codice_Filiale (It is like for you Dimension Stores..)I attach dimension structure and image about Role User FullStore and Role SelectedSpecificStore
Stat_Resp_Age_Cli is dimension like Customer
Analisys is about customer named B.DORIANO
CED.role can view all stores
CO16.role can view only store CO16...
[Importo Venduto Cliente Totale Azienda] is the calculated measure that should be sum all sales of all stores.
[Importo Venduto] is the measure that sum sales
You can see same result.
Thanks in advance..:-)
Ok, the good news is that there is nothing wrong with your roles or the way you've assigned them (although in my opinion you don't have to define dimension-level security for a role which will have permissions on everything).
What I think is happening here, is that the designer is generating a "bad" query for the view you are selecting. If you look at the source of your browsing view, you will most likely see that the designer is making use of sub-queries (or derived tables) to facilitate the filter.
The designer is known for doing this sort of thing, and I will recommend that you try and write an MDX query (without using the cube browser) like I have shown to see if you get the correct result.