SAP Knowledge Base Article - Public

2848424 - Insufficient Privilege Error when Initial OLAP is ran - WFA on HANA


When trying to "Build Fact Table and Cube" in "WFA on HANA Data Factory" you see the following missing privilege [258]: insufficient privilege


  • SAP SuccessFactors Workforce Analytics
  • WFA on Hana DATA Factory

Reproducing the Issue

1. Log into the Data Factory (WFA Admin -> WFA on HANA Data factory)

2. Run “Build Fact Table and Cube”

Stage Processor Pre-process OLAP data failed. Exception: OlapLib.OlapException: Pre process stage failed for OLAP initial load. ---> System.Exception: There was an error when creating the OLAP database for on the server dbPool2. ---> System.Exception: Error creating a user for the OLAP database for company ---> [258]: insufficient privilege: Not authorized at isStatement, RequestPacket requestPacket, Boolean ignoreErrors, Boolean isParse, Object executingObject, JdbcCommunication session, Boolean avoidReconnect) at , String , Boolean , JdbcCommunication ) at sql, Int32 resultSetType, Int32 resultSetConcurrency, Boolean parseAgain, JdbcCommunication session) at , Boolean , JdbcCommunication ) at ) at , String , Int32 , Int32 , Int32 ) at connection, String sql, Int32 resultSetType, Int32 resultSetConcurrency, Int32 resultSetHoldability) at , Int32 , Int32 , Int32 ) at sql) at arg0) at Hrml.Hana.HanaPooledConnection.GetPreparedStatement(String sql, CommandType commandType)


Caused by insufficient privileges that need to be granted via an COSD Engineering ticket.


Raise a COSD Jira, example such as COSD-39198


WFA on HANA, Initial Load Failure, Missing Priviledge, pre process stage failed for OLAP initial load, [258] , KBA , LOD-SF-WFA , Workforce Analytics & Planning , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem


SAP SuccessFactors HCM Core 1908