Skip to Content
author's profile photo Former Member
Former Member

BPC V10 Logic failing. *WHEN and *XDIMMEMBERSET BAS conflicting

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on May 22, 2013 at 03:33 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.