SAP Knowledge Base Article - Preview

1923343 - EPM Functions display #value! using drill down/expand feature


A report that use EPM Functions (e.g. EPMRetrieveData) in local member formula displays #value! error when the user is using drill down/expand feature.
To enable the drill down/expand feature user checked the option "Perform Worksheet Refresh on Expand/Collapse" on the EPM Sheet Options.



  • SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver
  • EPM Add-in for Microsoft Office 10.0 SP15
  • EPM Add-in for Microsoft Office 10.0 SP15 Patch 1


SAP enhancement package 1 for SAP NetWeaver 7.3


dril down, drill down resource, expand resource, error to expand, local member , KBA , EPM-XLS , EPM Excel Client , 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.