Symptom
Customer created a workbook using the SAP Analysis for MS Office version 2010. The workbook has one EPM sheet (based on the EPM plugin) and 2 Analysis sheets (based on the Analysis plugin). Worksheet protection was implemented via the SetSheetOption api using the following VBA code:
api. SetSheetOption "sheet name",300, True, "password", 20592
All sheets get protected (EPM sheets and AO sheets).
When executing the following sheet protection removal code:
api. SetSheetOption "sheet name",300, False, "password"
The code does not remove the protection from the Analysis plugin based sheets and customer is unable to change workbook and data source level settings. EPM sheets do get unprotected.
Read more...
Environment
- SAP Business Planning and Consolidation version for SAP NetWeaver
- SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver
Product
Keywords
EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC , KBA , BI-RA-AO-BPC , Please use component BI-RA-AO-XLA , EPM-BPC-NW , NetWeaver 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.