SAP Knowledge Base Article - Preview

2203960 - Bex Query generated from BPC model with member formula shows incorrect data in RSRT

Symptom

User creates Bex Query from BPC model which have member formulas. When executing the Bex Query in RSRT, The data of member formula nodes is incorrect.

For example, in BPC member formula, [Category].A =([Category].B, [TIME].CorrentMember.LAG(12)). When display the Bex Query in RSRT for Category.A, it does not show the data of Category.B in 12month before, but shows the data of Category.B in other month.


Read more...

Environment

  • SAP Business Planning and Consolidation 10.0, version for the SAP Netweaver
  • SAP Business Planning and Consolidation 10.1, version for the SAP Netweaver

Product

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

Keywords

BI report, Dashboard report, LAG, LEAD, ParallelPeriod, NextMember, PrevMember , KBA , EPM-BPC-NW-INT , Integration , 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.