Hi,
Should you have put the second expression of the Exists() into brackets?
SELECT
[Project Dim].[Project Title].Children on 0
FROM (
SELECT
Exists([Mandant Dim].[Mandant Name].CHILDREN,
{[User Dim].[Username].&[Peter], "User Mandat Fact"}) on 0
FROM [Security Concept])
Second, what about this data
UserDatasourceFact
UserID | SourceID
1 | A
2 | A
"Paul" and "Peter" see same group of projects?
Regards,
Igor
Igor Micev,My blog: www.igormicev.com