I have created a HANA JDBC connection in IDT and it works fine when I create a UNX using that connection in Webi. However when I log into Analysis Office and use the BOE log on using the Web service url: http://<host>:8080/dswsbobje/services/Session, I run into the following issue:
-I am presented with my connection including the HANA JDBC connection
-I am presented with my Analytic view from HANA
-However when I select that view, I get the following error:
Unable to open data source: <Connection>, <Analytic View>
ERROR [S1000] [SAP AG][SDBODBC DLL][HDB] General error;258 insufficient privilege: Not authorized
I would prefer not using the ODBC connector since that would require DSN creation on client machines among other issues.