Google

Wednesday 11 July 2007

BI 7.0 Security and Authorisations

We've installed from business content the DSO's for Controlling Security. The technical names for these cubes are 0CCA_O01, 0CCA_002 and 0CCA_003 with the Datasource 0CO_OM_CCA_USER_1. We've loaded data from our Dev R3 system into all the DSO's and activated it.
We've built a query based on the business content cube 0CCA_C11. Into that query in the filter we've put the variable 0C_OAPP for Controlling Area & combination of 0N_CCTRP & 0H_CCTRP for Cost Centre.
In transaction RSECADMIN we've generated authorisations based on the controlling DSO's. (See Screen Shot)



On generation we seem to get a lot of errors regarding Hierarchy.

For example when it generates the user and authorisation object for one particular user we get the error message "Hierarchy 1000S_C_C (version , key date 31.12.9999) does not exist".
In the case of that particular user we get the error message 29 times in the error log. When I look at the at Auth Object assigned to that user as part of the generation I can see in the hierarchy nodes that it has listed 29 cost centres. (See Attached Screen).



However this user in R3 is responsible for over 50 costs centres. Why are there not 50+ entries in here?
Alternately the error log for another users is green. They too have several cost centres for which they are responsible. But when I look at the Auth object assigned to that user there is no Hierarchy data showing at all.
When I do a test of the Query as each these users both get Authorization errors. I have built a role that I have attached to the user which should give the relevant authorisation. When I look at the error log after the query is run I see an error message.


Anybody got any ideas?