Symptom
When using functions such as EPMSelectMember or EPMContextMember the formula returns an Invalid member or Invalid Dimension error.
In the same workbook, using the same functions with different dimensions works as expected. The Clear Metadata Cache or Refresh Metadata Cache operations don't seem to have any effect.
Read more...
Environment
- SAP EPM Add-in for Microsoft Office
Product
SAP BW/4HANA 2.0 ; SAP Business Planning and Consolidation 10.1, version for Microsoft ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA
Keywords
EPM Connections , KBA , EPM-XLS , EPM Excel Client , 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.