Hide column on basis of users authorization
We have a query designed in business explorer 7.0 that is shown in the portal. Users should be able to view each column (key figure) based on the role that they are assigned to. We save this user/role mapping in a DSO, and we also save a role/column (each column has its code) mapping.
Is it possible to use these mappings to determine at run time which column the user is allowed to see? I'm thinking of writing an exit, but I'm not sure if this is possible.