I'm implementing a Market dimension where a user may have access to some markets and within a specific market certain periods. The Market dimension has two levels -- Market Name and Market Period. The Market Period level has an entry for every
period with data within the Market. The fact tables join to the Market dimension at the Market Period level. For obvious reasons, the Market Period level is not visible. It is only to be used for implementing security.
For testing, I have created a role which has the Deselect all members set on the Market Name level and only one market selected. At the Market Period level, I also have Deselect all member and have selected the specific periods that I want to display.
This looks like it should implement exactly what I want.
I reprocess the cube and look at it using the BIDS browser with the test role I setup. I see all markets. I assume that I'm missing something glaringly obvious, but I can't see it.
View Complete Post