on 09-10-2014 8:38 PM
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.
Hi Shubhranshu,
Can you provide some example of member formula with issue?
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
16 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.