Report Access design

FM Query Object demo:

 

 1 SELECT        DISTINCT    
 2             B.CostCenterCode,
 3             B.CostCenterName,
 4             B.DepartmentName,
 5             B.BusinessUnit    AS BUName,
 6             B.Region        AS SubCompanyName,
 7             A.Country
 8 FROM        NEDW.dbo.D_AccessControl AS A  
 9 LEFT JOIN    NEDW.dbo.D_COSTCENTER AS B 
10 ON            A.CostCenterCode = B.CostCenterCode
11 WHERE        B.CostCenterCode IS NOT NULL
12             AND A.UserName = #sq($account.defaultName)#