1869056 - Processing dimension error "OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object 'xxxx', database '<application set name>', schema 'dbo'.; 42000." - BPC MS

• "- OLE DB error: OLE DB or ODBC error: The SELECT permission was denied on the object 'xxxx', database '<application set name>', schema 'dbo'.; 42000. Errors in the OLAP storage engine: An error occurred while the
  dimension, with the ID of 'Harman_Applications', Name of 'Entity' was being processed.
  Server: The operation has been cancelled." error shows up when processing the dimension from Admin client.
• BPC installation user cannot process the dimension directly and get the same error from 'Microsoft SQL Server Management Studio' - Analysis Services.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP Business Planning and Consolidation (BPC) version 10.X for the Microsoft platform

EPM, BPC MS, Business Planning and Consolidation for the Microsoft platform, SAP BPC FOR Microsoft , KBA , executemodifyapplication , adminapplicationhandler , EPM-BPC-MS-ADM-CNS , Admin console , EPM-BPC-MS , Microsoft Version , Problem