SAP Knowledge Base Article - Preview

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

Symptom

  • "- 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.


', schema 'dbo'.; 42000." - BPC MS"> Read more...

Environment

  • SAP Business Planning and Consolidation (BPC) version 7.0 for the Microsoft platform
  • SAP Business Planning and Consolidation (BPC) version 7.5 for the Microsoft platform

Product

SAP Business Planning and Consolidation 7.0, version for Microsoft ; SAP Business Planning and Consolidation 7.5, version for Microsoft

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.