Hi, I'd like to apologise in advance for any weird grammer that may occur - this is not my native language. I am not sure if what I/we want/need is possible but here we go: I was tasked with remanufacturing some reports which so far have been sent out manually as Excel-Sheets. We intend to use a WRS-Report based on an OLAP cube instead in their place. However, the data inside is fairly sensitive which means I need to filter by User-ID in regards to who gets to see what report. This is going to happen via User-groups. Now my problem is following: There is a 3-tier hierarchy regarding the divisions. Tier1 could be "A" and "B". Tier2 could be "AA", "BB" and "CC" Tier3 could be "AAA", "BBB", "CCC", "DDD", etc all the way to "KKK". However, the hierarchy doesnt look neat like in Ex.1 but more like Ex.2: (Ex.1) (Ex.2) So far, I've tried (and failed) to ONLY give access to the (DDD)-report without giving access to the (A)-report and (A-empty) report as well. My best-working try so far has been achieved with the following MDX expression in the SAS OLAP Cube Studio, however I'd like (and need) to prevent the User to see anything in the "empty" division. { [Abteilung].[Abteilung].[Alle Abteilung], [Abteilung].[Abteilung].[Alle Abteilung].[A], [Abteilung].[Abteilung].[Alle Abteilung].[A].[ ], [Abteilung].[Abteilung].[Alle Abteilung].[A].[ ].[DDD] } When leaving out the third line inside the {}, all I see is the A-report but with no way to as well look at the DDD-report. There are also cases when the recipients of the reports may look at AA and CCC (but not A or AAA/BBB) or B and III (not BB or HHH). So: Is it at all possible to do what I need and if yes, how? I already tried to "disable" the middle tier view with a <!--condition, however I might've misunderstood what use those have/bring as my result didn't change.
... View more