SAP Knowledge Base Article - Preview

2517725 - BPC 10.0 NW: The EPMScaleData function is not returning the expected results when a Time Dependent Hierarchy is used within the EPM Add-in


When creating an EPM Add-in report off of a BPC model with a dimension that uses a Time Dependent Hierarchy (TDH) and adding the =EPMScaleData(,1,) function to the report, the data returned by this function is not changing according to the keydate selected.

The value remains the same value even though the dimension member transaction data is changing along with the KeyDate. Since the PL122 member should only be included in the CurrentDate TDH.

Keydate = Current KeyDate


KeyDate = 06/01/2017


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



BPC 10.0 NW SP22 or lower (CPMBPC 800 SP22 or CPMBPC 801 SP15)

BPC 10.1 NW SP10 or lower

NW 7.50 SP05 or lower


SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP NetWeaver 7.5


KBA , tdh , troubleshooting , keydate , 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.