Skip to Content

Generate SAP BW Privileges to Hana

Jan 25 at 02:17 PM


avatar image


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'


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?

su01.png (125.6 kB)
cp.png (39.7 kB)
cv.png (43.2 kB)
error.png (6.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers