2220162 - CREATE OLAP SCENARIO - 258 insufficient privilege: Not authorized

Creation of connectors for a search and analytics scenario fail with an authorization issue. The HANA user for the search and analytics database connection is not sufficiently authorized to create all required entities.
In the job log you find messages containing the following details:

• Database error 258: Insufficient Privilege: Not Authorized 
• SQL statement: CREATE OLAP SCENARIO 
• Operation “createCalculationScenario” 
• The error occurs for example for object 0CALDAY, the entity which cannot be created is: "0BW:ERP:<sys>:<clnt>$0CALDAY$P"
  
  

• SAP Basis 731 & 740
• Enterprise Search

KBA , BC-EIM-ESH , NetWeaver Enterprise Search , BC-EIM-ODP , Operational Data Provisioning (ODP) in Search&Analytics , Problem