Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Generate SAP BW Privileges to Hana

Former Member
0 Kudos

Hi!

Everything set up according to the main article - Authorizations for Generating SAP HANA Views

1) User <X> created via SU01 with correct roles:

2) Composite Provider (ZMM1VP01) created over Calculated View (CV_MM1D04) with Hana External View selected

3) AP generated as expected

4) After querying Hana External View with this user got error

5) Message in trace file

[49849]{443440}[190/-1] 2018-01-25 16:44:51.596522 i AuthorizationceAuthorizationCheckImpl.cpp(00470) : AuthorizationCheckHandler::isAuthorizedToSelect (AP check on CalcScenarioDS): User <X> is not authorized on _SYS_BIC:znn.mm1/CV_MM1D04 (t -1) (main view: SAPMBD:0BW:BIA:ZMM1VP04 (t -1)due to XMLAP check

[49849]{443440}[190/-1] 2018-01-25 16:44:51.596645 e CalcEngine ceModelBuilder.cpp(01342) : CalcEngine Exception: exception 306003: Authorization failed in Calculation Engine. User is not authorized to 'SELECT'

CONSLUSION:

User has not access to underlying CV. Expected, that additional AP will be generated.

Q: How CP or user or smth should be configured to delegate access to underlying objects?

0 REPLIES 0