Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue in Member Formula after enabling parallelization

Hi all,

System Details :


                SAP BW      - 731 Release - SP9

               CPMBPC     - 801 Release - SP4

               EPM Excel - 10.0 SP 15 Patch 1

Model Details :

              Periodic Model

Background Information :

          Sometimes back I had a performance issue in my BPC 10.0 report. So I implemented the steps mentioned in the SAP NOTE 1854228. After this, the report performance increased very signifiacntly.

Issue Details :

     There are few reports where in the Column axis we were trying to fetch data of both Periodic and YTD Measure along with Time Period. and in the row Axis I have accounts.

     My Issue is if in a single report I keep accounts :

                        CATEGORY 1 - Don't have member formula

                         CATEGORY 2 - have member formula : but accounts used in the formula of member formula are of same account type

                         CATEGORY 3 - have member formula : but accounts used in formula are of different account types ( e.g mix of INC and AST )

     Then the values fetched for any accounts for YTD measure is same as Periodic Measure.

But If I separate this single report to 2 different reports, where

                    1. In one report I kept accounts of Category 1 & 2.

                    2. In 2nd report I kept accounts of Category 3

Then the values for both YTD and Periodic are same.

As an developer I can do this. But this creates problem when user creates some Adhoc reports, where they want all there category of accounts in a single report. So if any body has any idea about how to overcome this issue, then it's very much appreciated.

Former Member
Not what you were looking for? View more on this topic or Ask a question