Skip to Content
0

SAP BPC 10.1 MS BCF balance carry forward not working

Jun 12, 2017 at 04:29 PM

124

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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


Share
10 |10000 characters needed characters left characters exceeded