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.

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