on 02-21-2011 7:17 AM
Dear experts,
I met an BPC script issue when trying to execute more than 2 mdx statements.
Here's script:
*XDIM_MEMBERSET ENTITY_PROC=BAS(<ALL>)
*XDIM_MEMBERSET PRODUCT=BAS(<ALL>)
*XDIM_MEMBERSET TIME_PROC=2011.H1
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET CATEGORY=C800
*XDIM_MEMBERSET PERIOD_PROC=P08
*XDIM_MEMBERSET DATASRC=INPUT
*XDIM_MEMBERSET ACCOUNT_PROC=CG1007,CG1008,CG1009,CG1010,CG1013,CG1014,CG1015,CG1016,CG1017,CG1018
[ACCOUNT_PROC].[#CG1015]=(([ACCOUNT_PROC].[CG1007][ACCOUNT_PROC].[CG1008][ACCOUNT_PROC].[CG1009]) / 1.17 ) * (1 - [ACCOUNT_PROC].[CG1010]) - [ACCOUNT_PROC].[CG1013] - [ACCOUNT_PROC].[CG1014]
*COMMIT
*XDIM_MEMBERSET ACCOUNT_PROC=CG1015,CG1016,CG1017,CG1018
[ACCOUNT_PROC].[#CG1016]=IIF([ACCOUNT_PROC].[CG1015]<0,0,[ACCOUNT_PROC].[CG1015])
[ACCOUNT_PROC].[#CG1018]=IIF([ACCOUNT_PROC].[CG1015]<0,0,[ACCOUNT_PROC].[CG1015]) - [ACCOUNT_PROC].[CG1017]
*COMMIT
When I populated ([#CG1015] and [#CG1016]) or ([#CG1016] and [#CG1018] ) in UJKT, it works fine. But if all these 3 statements included, UJKT will throw an error.
Termination occurred in the ABAP program "SAPLRRK0" - in "CHECK_KHANDLE".
The main program was "UJ0_START_PLAN ".
In the source code you have the termination point in line 34
of the (Include) program "LRRK0F05".
The program "SAPLRRK0" was started as a background job.
Job Name....... "BPC_4KWJ5B407J38PYXVRAHCB1890"
Any ideas on this?
Hi,
I dont see any problem with the script. Can you please try to keep the entire logic in a single commit. How does it go?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've tried to put all MDX statements in one commit, same issue happened in UJKT and DM.
But it is wired that following changes can be executed correctly from DM. I don't know why.
*XDIM_MEMBERSET ENTITY_PROC=BAS(<ALL>)
*XDIM_MEMBERSET PRODUCT=BAS(<ALL>)
*XDIM_MEMBERSET TIME_PROC=%TIME_PROC_SET%
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET CATEGORY=C800
*XDIM_MEMBERSET PERIOD_PROC=$V_PERIOD$
*XDIM_MEMBERSET DATASRC=INPUT
*XDIM_MEMBERSET ACCOUNT_PROC=CG1007,CG1008,CG1009,CG1010,CG1013,CG1014,CG1015,CG1016,CG1017,CG1018
*BEGIN
[ACCOUNT_PROC].[#CG1015]=(([ACCOUNT_PROC].[CG1007]+[ACCOUNT_PROC].[CG1008]+[ACCOUNT_PROC].[CG1009])
/ 1.17 ) * (1 - [ACCOUNT_PROC].[CG1010])
- [ACCOUNT_PROC].[CG1013] - [ACCOUNT_PROC].[CG1014]
*END
*COMMIT
*XDIM_MEMBERSET ENTITY_PROC=BAS(<ALL>)
*XDIM_MEMBERSET PRODUCT=BAS(<ALL>)
*XDIM_MEMBERSET TIME_PROC=%TIME_PROC_SET%
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET CATEGORY=C800
*XDIM_MEMBERSET PERIOD_PROC=$V_PERIOD$
*XDIM_MEMBERSET DATASRC=INPUT
*XDIM_MEMBERSET ACCOUNT_PROC=CG1015,CG1016,CG1017,CG1018
[ACCOUNT_PROC].[#CG1016]=IIF([ACCOUNT_PROC].[CG1015]<0,0,[ACCOUNT_PROC].[CG1015])
*COMMIT
*XDIM_MEMBERSET ENTITY_PROC=BAS(<ALL>)
*XDIM_MEMBERSET PRODUCT=BAS(<ALL>)
*XDIM_MEMBERSET TIME_PROC=%TIME_PROC_SET%
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET CATEGORY=C800
*XDIM_MEMBERSET PERIOD_PROC=$V_PERIOD$
*XDIM_MEMBERSET DATASRC=INPUT
*XDIM_MEMBERSET ACCOUNT_PROC=CG1015,CG1016,CG1017,CG1018
[ACCOUNT_PROC].[#CG1018]=IIF([ACCOUNT_PROC].[CG1015]<0,0,[ACCOUNT_PROC].[CG1015]) - [ACCOUNT_PROC].[CG1017]
*COMMIT
User | Count |
---|---|
6 | |
5 | |
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.