Skip to Content
avatar image
Former Member

SAP BPC 10.1 MS BCF balance carry forward not working

Hi all,

I 'am trying to do the balance carry forward on SAP BPC 10.1 MS version.

The package status is succesful, but the logs says "Error running stored procedure SPCOPYOPENING 'Test','REEL','ENTITY','LC', '2017.DEC','%SCOPES_SET%', 'SPSCOPE_636','SPLOG_635'"

As per my understanding we need to use à script logic (See below) and the business Rule.

1) How can i trouble shoot the package/store procedure ?

2) Is it mandatory to have an Audit dimension.

3) What are the steps to make carry forward work BPC MS 10.1 version. (simplest case).

Script logic used :

*RUN_STORED_PROCEDURE = SPCOPYOPENING('%MODEL%','%PHASE_SET%','%SCOPES_SET%','%SCOPETABLE%','%LOGTABLE%')

*COMMIT

Thank you in advance,

Karim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 19, 2017 at 10:42 AM

    This is to help BPC MS 10.1 users to user business Rule Balance carry forward (copy opening Stored procedure) :

    1. You didn't find a way to troubleshoot the package/store procedure SPCopyopening. If anyone have an idea.

    2. it Is not mandatory to have an Audit dimension in the model.

    3. Steps to create à BCF BR :

    1. Create a script logic with the following code :

    *RUN_STORED_PROCEDURE = SPCOPYOPENING('%APP_SET%','%PHASE_SET%','%SCOPES_SET%','%SCOPETABLE%','%LOGTABLE%')

    *COMMIT

    3. setup the category parameters :

    CATEGORY_FOR_OPE (Member of Category from which to copy the closing balance)
    OPENING_PERIOD (Period from which to copy the closing balances)
    OPENING_YEAR (Year from which to copy the closing balances)

    4. Setup the Business Rule Table :

    source account - Inventory
    destination account - Inventory
    Source flow - closing
    Destination flow - Opening
    Source data source - Input
    Destination daa source - Balance carry forword
    Data source type - A

    5. Setup Data manager package and attach the logic file with this package.

    6. Execute the package and


    Add comment
    10|10000 characters needed characters exceeded