on 06-12-2017 5:29 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
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.