Issue in Member Formula after enabling parallelization
System Details :
SAP BW - 731 Release - SP9
CPMBPC - 801 Release - SP4
EPM Excel - 10.0 SP 15 Patch 1
Model Details :
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.