Skip to Content
0

Data Manager package Not working properly using destination app script logic

Nov 04, 2017 at 07:10 AM

81

avatar image
Former Member

Dear BPC Team,

We are moving the data form one model(EXP) to other model(MIS) using destination app script logic and some times it is getting succedded and some times not(check attachment). So, Please suggest us the reason for failure of data manager packages. Please find the script logic used for the same.

Error:-

ERROR : RUN_LOGIC:MDX statement error: Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV',

Logic Script :

*XDIM_MEMBERSET PROFIT_CENTER = BAS(%PROFIT_CENTER_SET%)

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET MEASURES = YTD

*XDIM_MEMBERSET VALUATION = AMT

*DESTINATION_APP = MIS_CLNT1

*SKIP_DIM = DRIVER, EMPLOYEE, VALUATION, SCENARIO

*RENAME_DIM OP_ACCOUNT = GL_ACCOUNT

*ADD_DIM FLOW=F_999

*ADD_DIM INTERCO=I_NONE

*ADD_DIM SCOPE=NON_GROUP

*ADD_DIM ACCOUNT = OP_ACCOUNT:GRP_GL

*WHEN OP_ACCOUNT

*IS <> RENT_INC,RENT_EXP

*WHEN OP_ACCOUNT.ACCTYPE

*IS = EXP,INC

*WHEN CATEGORY

*IS %CATEGORY_SET%

*REC(EXPRESSION = 0,AUDITTRAIL=INP_EXP,CATEGORY=%CATEGORY_SET%)

*REC(EXPRESSION = (%VALUE%),AUDITTRAIL=INP_EXP,CATEGORY=%CATEGORY_SET%)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

Regards,

Dumpa Reddy

screenshot-2.jpg (40.1 kB)
screenshot-3.jpg (39.6 kB)
10 |10000 characters needed characters left characters exceeded

Please remove not related secondary tag:

EPM Add-In for Excel


0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Nov 04, 2017 at 07:52 AM
0

There is nothing wrong with your script.

Please check this note:

https://launchpad.support.sap.com/#/notes/2417959

Show 4 Share
10 |10000 characters needed characters left characters exceeded

P.S. Some lines/statements of this script are useless and can be removed:

*WHEN OP_ACCOUNT
*IS <> RENT_INC,RENT_EXP
*WHEN OP_ACCOUNT.ACCTYPE
*IS = EXP,INC 
*REC(EXPRESSION = %VALUE%,AUDITTRAIL=INP_EXP)
*ENDWHEN
*ENDWHEN

and remove useless COMMIT at the end!

0
Former Member

Dear Vadim,

Thanks for your quick response. Issue still persists.

We have applied the note in the BW system and have restarted the server.But Still issue persists.

Can you please suggest

Regards,
DUmpa Reddy

0
Former Member

Error after applying SAP Note.

screenshot-4.jpg (135.9 kB)
0

When you convert answer to comment my reply on this answer is lost!

From the deleted rely: Please read note:

https://launchpad.support.sap.com/#/notes/638701

Also, please remove unrelated question tag:

EPM Add-In for Excel

0