When trying to use a Microsoft SSAS OLAP cube data source in Framework Manager you get this error message:
MO-ERR-0028 The user starting the process doesn’t have the correct privileges
The solution is as follows:
- Use a network domain account for the Cognos service
- On Cognos server, in Local Security Settings under Local Policies/User Rights Assignment add the cognos service account to “Act as part of the operating system”
- ON SQL Server give cognos service security access to cube
- For the SSAS Data Source in Cognos Connection use IBM Cognos 8 service credentials for Signon.