Question:
Hi all
I am trying to build table based authorisations into an SAP BW solution. The idea is that the administrator will maintain a table of users and the nodes of a hierarchy relating to their authorisation. The solution should then create the relevant roles and profiles and a variable will restrict authorisation accordingly.
Am i wandering in the realms of fantacy or is this possible? I have heard of it being done but can find no documentation.
Any ideas anyone?
Many thanks
Gareth
Answer:
Hi,
I have done something like that in BPS where the User ID plays a bigger role.
In BW it should be possible to find the user ID in the system code at query runtime but I guess if it is too hard to find that then how about introducing a User ID as a characteristic variable in the cube. Then use an exit variable to lookup in the Z table for a go/nogo and also populate the hierarchy node/s variable based on the user ID??
Answer:
If you do a search on 0CCA_O01 in help.sap.com there's a solution in Business Content that could help. It doesn't seem to be exactly what you need, but it could be a plan B.
It uses an ODS where you maintain the rights and creates user profiles automatically when you run a report that bases itself on the data contained in the ODS. I'm sure we can automate that quite a bit. I'm working on something right now that will use this concept for sales access for external vendors. Hundreds of them to maintain, so by maintaining a file uploaded daily in BW, users and profiles will be automatically created based on it.
_________________
Eric