Hi,
I am using a navigation attribute called Chief Position in Analysis Authorization object. This is an attribute of 0EMPLOYEE which is mapped to the Employee Id in backend and loaded into BW. What I want to see is to report on only the authorized data of the holder of Chief Position when he executes the report using single sign on. Means, when he executes the report, it should authenticate him as Chief Position and retrieve only the data related to him/her.
I have used the navigation attribute in the query and created the Analysis Authorization using this object. A role is also created for the Analysis Authorization and assigned the users. After executing the report, it comes up with insufficient authorization. Am I missing anything here?
Should I use a Customer Exit on this attribute to perform the identification as chief position and retrieve the data or just including the navigation attribute in query is enough?
Will assign points to a quick suggestion.
Thanks.
Ramesh