Error when adding HANA Views to RTC CompositeProv

[former_member459384]

Hello Experts,

We are implementing a RTC solution for the first time and we are getting this error message during the creation of the CompositeProv (used to join VirtualProvider and RTC model views): "Error when getting results: insufficient privilege: Not authorized". (See image below).

In a previous forum the same error was solved, however, our Basis applied the solution indicated and the error remains:

https://answers.sap.com/questions/29111/can-not-add-hana-view-to-composite-provider-unsuff.html

We are working in 1610 FSP02 (with BW 7.5.1 SP 2, BPC 10.1). We got the same error either in HANA Studio and in Eclipse.

Could you please, help us?

[danielvalle · Accepted solution]

Hi Bibiana,

I had the same issue, it's very easy to solve.

You need to authorize some Privileges to SAPABAP1 database user to be able adding SAP HANA views when you create a composite provider.

and then, you need to give this privileges:

and this too:

Regards!

Daniel Valle

[kalyanbhattacharya]

We faced the exact similar issue and Daniel's answer helped me solve it.

Regards

Kalyan