on 05-22-2013 10:26 AM
All
We have some very basic logic that copies data from one model to another.
After our upgrade to V10 it is no longer working. The *WHEN clause to exclude the INPUT_BA member from the C_DATASRC dim is being ignored and all records are being written. If we comment out the *XDIM_MEMBERSET C_DATASRC = BAS(D_TOTAL) line, the logic works as expected.
Any ideas why? I don't want to have to trawl through all our logic and manually amend it if possible!
Thanks in advance
Gayle
Below is the original code.
*XDIM_MEMBERSET C_ACCT = BAS(MGPROFIT)
*XDIM_MEMBERSET C_DATASRC = BAS(D_TOTAL)
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%
*XDIM_MEMBERSET FLOW = BAS(F_TOT)
*XDIM_MEMBERSET GROUPS = N_GROUP
*XDIM_MEMBERSET INTCO = BAS(INP_INTERCO)
*XDIM_MEMBERSET RPTCURRENCY = USD
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET VERSION = ACTUALS
*XDIM_MEMBERSET MEASURES = PERIODIC
*WHEN C_DATASRC
*IS INPUT_BA
// Do nothing. ie remove the BA journals
*ELSE
*REC(FACTOR=1,C_DATASRC=INPUT,C_ACCT=GP_LEGAL,INTCO=ICNONE)
*ENDWHEN
*COMMIT
Hi Gayle,
which version of BPC have you installed MS or NW?
Have you tried using "<>", i.e.
*XDIM_MEMBERSET C_ACCT = BAS(MGPROFIT)
*XDIM_MEMBERSET C_DATASRC = BAS(D_TOTAL)
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%
*XDIM_MEMBERSET FLOW = BAS(F_TOT)
*XDIM_MEMBERSET GROUPS = N_GROUP
*XDIM_MEMBERSET INTCO = BAS(INP_INTERCO)
*XDIM_MEMBERSET RPTCURRENCY = USD
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET VERSION = ACTUALS
*XDIM_MEMBERSET MEASURES = PERIODIC
*WHEN C_DATASRC
*IS <> INPUT_BA
*REC(FACTOR=1,C_DATASRC=INPUT,C_ACCT=GP_LEGAL,INTCO=ICNONE)
*ENDWHEN
*COMMIT
Kind regards
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We have resolved this now. SAP Note : 1808780
@Roberto : Thanks for your reply
SAP Knowledge Base Article
Symptom
l In Script logic WHEN/ELSE clause reads more records than it should.
l The script generates records which are not in the scope of XDIM_MEMBERSET statement.
l This issue started after upgrading BPC75 SP09 to BPC10 SP08
Environment
SAP Business Planning and Consolidation 10.0 for SAP NetWeaver
Reproducing the Issue
1. Run the following script from UJKT.
2. The script returns the records which are not base member of 2011.Q1 or 2011.Q2
*XDIM_MEMBERSET TIME=BAS(2011.Q1,2011.Q2)
*WHEN TIME
*IS <> BAS(2011.Q1)
*REC(FACTOR=2.0)
*ENDWHEN
Cause
This is a known issue.
Resolution
l Apply SAP NOTE 1808780to resolve this issue.
l This fix is included in Support Package 10 for CPMBPC 800, and Support Package 03 for CPMBPC 801.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.