*FOR/*NEXT & allocation SAP BPC 11

[Former Member]

Hello all,

Business case: there are different sum of allocation for several company. We need to allocate thos sums to accounts for every company using allocation accounts of another company.
1 case when i use script of allocation for one company is work ok.
in next case i try to use *next/for: allocation return 0 data (in selection i use the company from case 1).

Please, i need help, i want to use next/for + allocation for several company

1. The first case:

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET SCOPE = %SCOPE_SET%

*XDIM_MEMBERSET RPTCURRENCY = RUB

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM DATASOURCE WHAT = DT80920111; WHERE = DT21011701; USING = DT80920001; TOTAL = <<<;

*DIM ACCOUNT WHAT = Z9551100001; WHERE = BAS(P3144722000),BAS(P3144727000),P3144721021,P3144721031,P3144721041,P3144721051,P3144721061,P3144721071,P3144721081,P3144721091,P3144721101,P3144721111,P3144721121,P3144721131,P3144721141,P3144721151,P3144721161,P3144721171,P3144721181,P3144721991,P3144723001,P3144724001,P3144725001,P3144726001,P3144728001,P3144729001,P3144730001; USING = <<<; TOTAL = <<<;

*DIM FLOW WHAT = FL10061; WHERE = FL00991; USING = <<<; TOTAL = <<<;

*DIM FIXASSETS WHAT = FA10401; WHERE = BAS(FA_ALL); USING = <<<; TOTAL = <<<;

*DIM CURRENCY WHAT = CU_NONE; WHERE = BAS(CU_ALL); USING = <<<; TOTAL = <<<;

*DIM FVRATE WHAT = FV_NONE; WHERE = FV_NONE; USING = <<<; TOTAL = <<<;

*DIM REGION WHAT = RG_NONE; WHERE = BAS(RG_ALL); USING = <<<; TOTAL = <<<;

*DIM PRODUCT WHAT = PR_NONE; WHERE = BAS(PR_ALL); USING = <<<; TOTAL = <<<;

*DIM FUNCTIONS WHAT = FU_NONE; WHERE = FU_NOTDEF; USING = <<<; TOTAL = <<<;

*DIM MATURITY WHAT = MA_NONE; WHERE = MA_NONE; USING = <<<; TOTAL = <<<;

*DIM COSTCENTER WHAT = CC_NONE; WHERE = BAS(CC_ALL); USING = <<<; TOTAL = <<<;

*DIM PARTNER WHAT = IC_NONE; WHERE = BAS(IC_ALL); USING = <<<; TOTAL = <<<;

*DIM COMPANY WHAT = EN1521; WHERE = <<<; USING = EN1601; TOTAL = <<<;

*DIM PROJECT WHAT = IP_NONE; WHERE = <<<; USING = <<<; TOTAL = <<<;

*ENDALLOCATION

LOG:

WHAT data: 1 records.

-----------------------------------------

Existing WHERE data: 19 records.

-----------------------------------------

USING data: 19 records.

-----------------------------------------

TOTAL data: 1 records.

-----------------------------------------

--Обратная запись записей выполнена: 19

--Обратная запись записей не выполнена:--Обратная запись записей не выполнена: 0

SCRIPT RUNNING TIME IN TOTAL:10.00 s.

LOG END TIME:2018-07-19 18:01:47

2. The second case:
But when i try to add construction select next for, like (the same company in the selection):

*SELECT(%ENT_N%,"ID","COMPANY","[ID]=EN1521")

*FOR %ENT% = %ENT_N%

*RUNALLOCATION
code like 1, instead

*DIM COMPANY WHAT = EN1521; WHERE = <<<; USING = EN1601; TOTAL = <<<;

*DIM COMPANY WHAT = %ENT_N%; WHERE = <<<; USING = EN1601; TOTAL = <<<;

the log return 0 written data...

3. When I include all companies in the "What and where", the system records the same data for all companies...

Thank you,

looking forward to you answer,

Olga Ya.

[former_member186338]

First - you are not providing full script with for/next!

Second - endallocation will reset scope defined by xdim_memberset - you have to include scoping inside for/next