Error In while validating in UJKT

[Former Member]

Hi Can you guys help me how to resolve this exception.This logic script is for SKU level.

Thanks

[former_member186338]

Please provide script text and explanation in line with

[former_member186338]

Have you set $COMBOBOX$ variable in UJKT PARAM? Full screenshot required!

[Former Member]

Hi Vadim,

yes i provided the param values as well.

Script:

*XDIM_MEMBERSET ACCOUNT = PL010

*XDIM_MEMBERSET RPTCURRENCY = %RPTCURRENCY_SET%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*SELECT(%PRODSET%,"ID",PRODUCT_ALLOC,"GROUP = '$COMBOBOX$'")

*FOR %PROD% = %PRODSET%

*FOR %TIME% = %TIME_SET%

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan;      WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = %PROD%_NODE; WHERE = BAS(%PROD%);      USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = %TIME%; WHERE = %TIME%;USING = TMVL(-12,%TIME%); TOTAL = <<<;

*ENDALLOCATION

*WHEN ACCOUNT

*IS PL010

*REC(EXPRESSION = 0, CATEGORY=Plan, PRODUCT_ALLOC = %PROD%_NODE,TIME = %TIME%)

*ENDWHEN

*NEXT

*NEXT

[former_member186338]

Start with simple code without FOR/NEXT with single product and time members (fixed).

Only run ALLOCATION.

Ensure it's validating!

Then add WHEN/ENDWHEN...

[Former Member]

No luck , still the exception is same.Please find the screenshot.

[former_member186338]

To test simply validate:

*SELECT(%PRODSET%,"ID",PRODUCT_ALLOC,"GROUP = '$COMBOBOX$'")

*XDIM_MEMBERSET PRODUCT_ALLOC = %PRODSET%

What is the result?

P.S. Only 2 lines!

P.P.S. Sorry - PRODUCT_ALLOC!

[Former Member]

Sorry with single product.

[former_member186338]

And in the allocation - you have not defined variables! %PROD% and %TIME% - why do you think it will work???

[former_member186338]

2 lines!!!!

[former_member186338]

Put some member instead of %TIME%

[Former Member]

   just only 2 lines no Exception

[Former Member]

Sorry only 2 lines validation, no exception.

[former_member186338]

Then press EXECUTE to see the final lgx

[former_member186338]

AND PLEASE BE ACCURATE!

In PARAM you have COMBOX, not COMBOBOX!!!!!!!!

Press Execute

[Former Member]

Thanks Vadim , after executing pls find the UJKT_test result

[former_member186338]

Now test:

*SELECT(%PRODSET%,"ID",PRODUCT_ALLOC,"GROUP = '$COMBOBOX$'")

*FOR %PROD% = %PRODSET%

*XDIM_MEMBERSET PRODUCT_ALLOC = %PROD%_NODE

*NEXT

To ensure that you have correct %PROD%_NODE members!

[Former Member]

Yes Vadim , iam able to see the correct NODE.

[former_member186338 · Accepted solution]

Now - use Execute Simulate (not to perform allocation):

*SELECT(%PRODSET%,"ID",PRODUCT_ALLOC,"GROUP = '$COMBOBOX$'")

*FOR %PROD% = %PRODSET%

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan;      WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = %PROD%_NODE; WHERE = BAS(%PROD%);      USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2014.01; WHERE = 2014.01;USING = TMVL(-12,2014.01); TOTAL = <<<;

*ENDALLOCATION

*NEXT

[Former Member · Accepted solution]

i performed Execute Simulate

//SCRIPT

*SELECT(%PRODSET%,"ID",PRODUCT_ALLOC,"GROUP = '$COMBOBOX$'")

*FOR %PROD% = %PRODSET%

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan;      WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = %PROD%_NODE; WHERE = BAS(%PROD%);      USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2014.01; WHERE = 2014.01;USING = TMVL(-12,2014.01); TOTAL = <<<;

*ENDALLOCATION

*NEXT

//UJKT_TESTRESULT

LGX:

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan; WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = CPG_GRP11_NODE; WHERE = BAS(CPG_GRP11); USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2014.01; WHERE = 2014.01;USING = 2013.01 , ; TOTAL = <<<;

*ENDALLOCATION

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan; WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = CPG_GRP12_NODE; WHERE = BAS(CPG_GRP12); USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2014.01; WHERE = 2014.01;USING = 2013.01 , ; TOTAL = <<<;

*ENDALLOCATION

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

LOG:

FILE:\ROOT\WEBFOLDERS\ENVIRONMENT830 \ADMINAPP\SKU_MODEL\TEST.LGF

USER:HANAUSER830

APPSET:ENVIRONMENT830

APPLICATION:SKU_MODEL

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

ACCOUNT:PL010,

RPTCURRENCY:USD,

ENTITY:US,

TIME:2014.01,

CATEGORY:WHAT:Plan,WHERE:Plan,USING:Actual,TOTAL:<<<

PRODUCT_ALLOC:WHAT:CPG_GRP11_NODE,WHERE:BAS(CPG_GRP11),USING:<<<,TOTAL:<<<

TIME:WHAT:2014.01,WHERE:2014.01,USING:2013.01 ,,TOTAL:<<<

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

ACCOUNT:PL010,

RPTCURRENCY:USD,

ENTITY:US,

TIME:2014.01,

CATEGORY:WHAT:Plan,WHERE:Plan,USING:Actual,TOTAL:<<<

PRODUCT_ALLOC:WHAT:CPG_GRP12_NODE,WHERE:BAS(CPG_GRP12),USING:<<<,TOTAL:<<<

TIME:WHAT:2014.01,WHERE:2014.01,USING:2013.01 ,,TOTAL:<<<

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

[former_member186338]

Now Simulate practically original - but instead of %TIME% use %T%

*XDIM_MEMBERSET ACCOUNT = PL010

*XDIM_MEMBERSET RPTCURRENCY = %RPTCURRENCY_SET%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*SELECT(%PRODSET%,"ID",PRODUCT_ALLOC,"GROUP = '$COMBOBOX$'")

*FOR %PROD% = %PRODSET%

*FOR %T% = %TIME_SET%

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan;      WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = %PROD%_NODE; WHERE = BAS(%PROD%);      USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = %T%; WHERE = %T%;USING = TMVL(-12,%T%); TOTAL = <<<;

*ENDALLOCATION

*NEXT

*NEXT

May be %TIME% is not a best name for variable

[Former Member]

Strange thing : when i just validate , again iam getting UJK_VALIDATION_EXCEPTION:Member "*" not exist

But when i perform Execute simulate its not giving any exception pls find the test result.

[Former Member]

Sorry full log result

LGX:

*XDIM_MEMBERSET ACCOUNT = PL010

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ENTITY = US

*XDIM_MEMBERSET TIME = 2014.01

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan; WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = CPG_GRP11_NODE; WHERE = BAS(CPG_GRP11); USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2014.01; WHERE = 2014.01;USING = 2013.01 , ; TOTAL = <<<;

*ENDALLOCATION

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan; WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = CPG_GRP12_NODE; WHERE = BAS(CPG_GRP12); USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2014.01; WHERE = 2014.01;USING = 2013.01 , ; TOTAL = <<<;

*ENDALLOCATION

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

LOG:

FILE:\ROOT\WEBFOLDERS\ENVIRONMENT830 \ADMINAPP\SKU_MODEL\TEST.LGF

USER:HANAUSER830

APPSET:ENVIRONMENT830

APPLICATION:SKU_MODEL

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

ACCOUNT:PL010,

RPTCURRENCY:USD,

ENTITY:US,

TIME:2014.01,

CATEGORY:WHAT:Plan,WHERE:Plan,USING:Actual,TOTAL:<<<

PRODUCT_ALLOC:WHAT:CPG_GRP11_NODE,WHERE:BAS(CPG_GRP11),USING:<<<,TOTAL:<<<

TIME:WHAT:2014.01,WHERE:2014.01,USING:2013.01 ,,TOTAL:<<<

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

ACCOUNT:PL010,

RPTCURRENCY:USD,

ENTITY:US,

TIME:2014.01,

CATEGORY:WHAT:Plan,WHERE:Plan,USING:Actual,TOTAL:<<<

PRODUCT_ALLOC:WHAT:CPG_GRP12_NODE,WHERE:BAS(CPG_GRP12),USING:<<<,TOTAL:<<<

TIME:WHAT:2014.01,WHERE:2014.01,USING:2013.01 ,,TOTAL:<<<

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

[former_member186338]

With just Validate the $COMBOBOX$ variable is not processed in your BPC version/SP.  Just ignore!

Solved!

[Former Member]

Hi Vadim,

Script looks working fine, but iam not able to get the result, see below log file signed data is 0.

LGX:

*XDIM_MEMBERSET ACCOUNT = PL010

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ENTITY = US

*XDIM_MEMBERSET TIME = 2015.01

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan; WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = CPG_GRP11_NODE; WHERE = BAS(CPG_GRP11); USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2015.01; WHERE = 2015.01;USING = 2014.01 , ; TOTAL = <<<;

*ENDALLOCATION

*WHEN ACCOUNT

*IS PL010

*REC(EXPRESSION = 0, CATEGORY=Plan, PRODUCT_ALLOC = CPG_GRP11_NODE, TIME = 2015.01)

*ENDWHEN

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan; WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = CPG_GRP12_NODE; WHERE = BAS(CPG_GRP12); USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2015.01; WHERE = 2015.01;USING = 2014.01 , ; TOTAL = <<<;

*ENDALLOCATION

*WHEN ACCOUNT

*IS PL010

*REC(EXPRESSION = 0, CATEGORY=Plan, PRODUCT_ALLOC = CPG_GRP12_NODE, TIME = 2015.01)

*ENDWHEN

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

LOG:

LOG BEGIN TIME:2015-10-28 15:42:32

FILE:\ROOT\WEBFOLDERS\ENVIRONMENT830 \ADMINAPP\SKU_MODEL\TEST.LGF

USER:HANAUSER830

APPSET:ENVIRONMENT830

APPLICATION:SKU_MODEL

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

ACCOUNT:PL010,

RPTCURRENCY:USD,

ENTITY:US,

TIME:2015.01,

CATEGORY:WHAT:Plan,WHERE:Plan,USING:Actual,TOTAL:<<<

PRODUCT_ALLOC:WHAT:CPG_GRP11_NODE,WHERE:BAS(CPG_GRP11),USING:<<<,TOTAL:<<<

TIME:WHAT:2015.01,WHERE:2015.01,USING:2014.01 ,,TOTAL:<<<

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

--Read WHAT region

[CATEGORY] =Plan

[PRODUCT_ALLOC] =CPG_GRP11_NODE

[TIME] =2015.01

[ACCOUNT] =PL010

[RPTCURRENCY] =USD

[ENTITY] =US

--Time to load WHAT :0.066016 second(s).

WHAT data:0  records.

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

--Read USING region

[CATEGORY] =Actual

[PRODUCT_ALLOC] =CPG_PROD1,CPG_PROD10,CPG_PROD11,CPG_PROD12,CPG_PROD13,CPG_PROD14,CPG_PROD15,CPG_PROD16,CPG_PROD17

--Time to load USING :0.074694 second(s).

USING data:32  records.

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

--Merge WHAT and USING

--Time to merge WHAT and USING :0.000287 second(s).

Data after merging WHAT and USING   records.

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

--Apply factor

[CATEGORY] =Actual

[PRODUCT_ALLOC] =CPG_PROD1,CPG_PROD10,CPG_PROD11,CPG_PROD12,CPG_PROD13,CPG_PROD14,CPG_PROD15,CPG_PROD16,CPG_PROD17

TOTAL data:32  records.

WHERE=WHAT *USING/TOTAL

--Time to apply factor :0.076365 second(s).

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

--Read destination and calculate difference

[CATEGORY] =Plan

[PRODUCT_ALLOC] =CPG_PROD1,CPG_PROD10,CPG_PROD11,CPG_PROD12,CPG_PROD13,CPG_PROD14,CPG_PROD15,CPG_PROD16,CPG_PROD17

--Time to read destination and calculate difference :0.068691 second(s).

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

--Records succeeded to write back

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

--Time to run Allocation :0.292899 second(s).

[INFO] GET_DIM_LIST(): I_APPL_ID="SKU_MODEL", #dimensions=7

ACCOUNT,CATEGORY,ENTITY,MEASURES,PRODUCT_ALLOC,RPTCURRENCY,TIME

#dim_memberset=4

ACCOUNT:PL010,1 in total.

RPTCURRENCY:USD,1 in total.

ENTITY:US,1 in total.

TIME:2015.01,1 in total.

REC

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 3  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 1  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

ACCOUNT CATEGORY ENTITY PRODUCT_ALLOC RPTCURRENCY TIME SIGNEDDATA

PL010 Plan US CPG_GRP11_NODE USD 2015.01 0.00

1  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

ACCOUNT:PL010,

RPTCURRENCY:USD,

ENTITY:US,

TIME:2015.01,

CATEGORY:WHAT:Plan,WHERE:Plan,USING:Actual,TOTAL:<<<

PRODUCT_ALLOC:WHAT:CPG_GRP12_NODE,WHERE:BAS(CPG_GRP12),USING:<<<,TOTAL:<<<

TIME:WHAT:2015.01,WHERE:2015.01,USING:2014.01 ,,TOTAL:<<<

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

--Read WHAT region

[CATEGORY] =Plan

[PRODUCT_ALLOC] =CPG_GRP12_NODE

[TIME] =2015.01

[ACCOUNT] =PL010

[RPTCURRENCY] =USD

[ENTITY] =US

--Time to load WHAT :0.068104 second(s).

WHAT data:0  records.

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

--Read USING region

[CATEGORY] =Actual

[PRODUCT_ALLOC] =CPG_PROD33,CPG_PROD34,CPG_PROD35,CPG_PROD36,CPG_PROD37,CPG_PROD38,CPG_PROD39,CPG_PROD40,CPG_PROD41

--Time to load USING :0.069189 second(s).

USING data:11  records.

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

--Merge WHAT and USING

--Time to merge WHAT and USING :0.000124 second(s).

Data after merging WHAT and USING   records.

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

--Apply factor

[CATEGORY] =Actual

[PRODUCT_ALLOC] =CPG_PROD33,CPG_PROD34,CPG_PROD35,CPG_PROD36,CPG_PROD37,CPG_PROD38,CPG_PROD39,CPG_PROD40,CPG_PROD41

TOTAL data:11  records.

WHERE=WHAT *USING/TOTAL

--Time to apply factor :0.134339 second(s).

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

--Read destination and calculate difference

[CATEGORY] =Plan

[PRODUCT_ALLOC] =CPG_PROD33,CPG_PROD34,CPG_PROD35,CPG_PROD36,CPG_PROD37,CPG_PROD38,CPG_PROD39,CPG_PROD40,CPG_PROD41

--Time to read destination and calculate difference :0.06638 second(s).

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

--Records succeeded to write back :3

--Records failed to write back

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

--Time to run Allocation :0.445064 second(s).

[INFO] GET_DIM_LIST(): I_APPL_ID="SKU_MODEL", #dimensions=7

ACCOUNT,CATEGORY,ENTITY,MEASURES,PRODUCT_ALLOC,RPTCURRENCY,TIME

#dim_memberset=4

ACCOUNT:PL010,1 in total.

RPTCURRENCY:USD,1 in total.

ENTITY:US,1 in total.

TIME:2015.01,1 in total.

REC

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 3  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 1  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

ACCOUNT CATEGORY ENTITY PRODUCT_ALLOC RPTCURRENCY TIME SIGNEDDATA

PL010 Plan US CPG_GRP12_NODE USD 2015.01 0.00

1  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :1.00  ms.

SCRIPT RUNNING TIME IN TOTAL:2.00 s.

LOG END TIME:2015-10-28 15:42:33

[Former Member]

Actuals, Iam setting in this report.

Target Data iam setting here, but unfortunately its not allowing  CPG_GRP12 level to set the data, bz only baselevel members its allowing.

  plan report

Can you suggest me whats wrong on this please.

[former_member186338]

I don't see data for CPG_GRP11_NODE in the report!

Test with single group!

*FOR %PROD% =CPG_GRP11

[Former Member]

Hi vadim  Testing with single group CPG_GRP11,still the issue seems to be same...

SCRIPT:

*XDIM_MEMBERSET ACCOUNT = PL010

*XDIM_MEMBERSET RPTCURRENCY = %RPTCURRENCY_SET%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*FOR %PROD% = CPG_GRP11

*FOR %T% = %TIME_SET%

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan;      WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = %PROD%_NODE; WHERE = BAS(%PROD%);      USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = %T%; WHERE = %T%;USING = TMVL(-12,%T%); TOTAL = <<<;

*ENDALLOCATION

*WHEN ACCOUNT

*IS PL010

*REC(EXPRESSION = 0, CATEGORY=Plan, PRODUCT_ALLOC = %PROD%_NODE, TIME = %T%)

*ENDWHEN

*NEXT

*NEXT

UJKT,Test_results

LGX:

*XDIM_MEMBERSET ACCOUNT = PL010

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ENTITY = US

*XDIM_MEMBERSET TIME = 2015.01

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan; WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = CPG_GRP11_NODE; WHERE = BAS(CPG_GRP11); USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2015.01; WHERE = 2015.01;USING = 2014.01 , ; TOTAL = <<<;

*ENDALLOCATION

*WHEN ACCOUNT

*IS PL010

*REC(EXPRESSION = 0, CATEGORY=Plan, PRODUCT_ALLOC = CPG_GRP11_NODE, TIME = 2015.01)

*ENDWHEN

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

LOG:

LOG BEGIN TIME:2015-10-28 17:03:59

FILE:\ROOT\WEBFOLDERS\ENVIRONMENT830 \ADMINAPP\SKU_MODEL\TEST.LGF

USER:HANAUSER830

APPSET:ENVIRONMENT830

APPLICATION:SKU_MODEL

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

ACCOUNT:PL010,

RPTCURRENCY:USD,

ENTITY:US,

TIME:2015.01,

CATEGORY:WHAT:Plan,WHERE:Plan,USING:Actual,TOTAL:<<<

PRODUCT_ALLOC:WHAT:CPG_GRP11_NODE,WHERE:BAS(CPG_GRP11),USING:<<<,TOTAL:<<<

TIME:WHAT:2015.01,WHERE:2015.01,USING:2014.01 ,,TOTAL:<<<

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

--Read WHAT region

[CATEGORY] =Plan

[PRODUCT_ALLOC] =CPG_GRP11_NODE

[TIME] =2015.01

[ACCOUNT] =PL010

[RPTCURRENCY] =USD

[ENTITY] =US

--Time to load WHAT :0.067409 second(s).

WHAT data:0  records.

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

--Read USING region

[CATEGORY] =Actual

[PRODUCT_ALLOC] =CPG_PROD1,CPG_PROD10,CPG_PROD11,CPG_PROD12,CPG_PROD13,CPG_PROD14,CPG_PROD15,CPG_PROD16,CPG_PROD17

--Time to load USING :0.069117 second(s).

USING data:32  records.

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

--Merge WHAT and USING

--Time to merge WHAT and USING :0.000286 second(s).

Data after merging WHAT and USING   records.

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

--Apply factor

[CATEGORY] =Actual

[PRODUCT_ALLOC] =CPG_PROD1,CPG_PROD10,CPG_PROD11,CPG_PROD12,CPG_PROD13,CPG_PROD14,CPG_PROD15,CPG_PROD16,CPG_PROD17

TOTAL data:32  records.

WHERE=WHAT *USING/TOTAL

--Time to apply factor :0.072591 second(s).

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

--Read destination and calculate difference

[CATEGORY] =Plan

[PRODUCT_ALLOC] =CPG_PROD1,CPG_PROD10,CPG_PROD11,CPG_PROD12,CPG_PROD13,CPG_PROD14,CPG_PROD15,CPG_PROD16,CPG_PROD17

--Time to read destination and calculate difference :0.073433 second(s).

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

--Records succeeded to write back :1

--Records failed to write back

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

--Time to run Allocation :0.315264 second(s).

[INFO] GET_DIM_LIST(): I_APPL_ID="SKU_MODEL", #dimensions=7

ACCOUNT,CATEGORY,ENTITY,MEASURES,PRODUCT_ALLOC,RPTCURRENCY,TIME

#dim_memberset=4

ACCOUNT:PL010,1 in total.

RPTCURRENCY:USD,1 in total.

ENTITY:US,1 in total.

TIME:2015.01,1 in total.

REC

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms. 4  RECORDS QUERIED OUT.

QUERY REFERENCE DATA

CALCULATION TIME IN TOTAL :0.00 ms.

1  RECORDS ARE GENERATED.

CALCULATION END.

ENDWHEN ACCUMULATION: 1  RECORDS ARE GENERATED.

DATA TO WRITE BACK:

ACCOUNT CATEGORY ENTITY PRODUCT_ALLOC RPTCURRENCY TIME SIGNEDDATA

PL010 Plan US CPG_GRP11_NODE USD 2015.01 0.00

1  RECORDS HAVE BEEN WRITTEN BACK.

WRITING TIME :0.00  ms.

SCRIPT RUNNING TIME IN TOTAL:1.00 s.

LOG END TIME:2015-10-28 17:04:00

[former_member186338]

Sorry but I can't see any issues! Some data is generated...

But you have to provide clear reports with data before allocation and after allocation, including data to allocate in CPG_GRP11_NODE.

And temporary remove WHEN/ENDWHEN loop just to test allocation! Why are you trying to test long script?

[Former Member]

Iam using CPG_GRP12_NODE becuase its contains less data. I removed the when and When as well.

script

*XDIM_MEMBERSET ACCOUNT = PL010

*XDIM_MEMBERSET RPTCURRENCY = %RPTCURRENCY_SET%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET TIME = %TIME_SET%

*FOR %PROD% = CPG_GRP12

*FOR %T% = %TIME_SET%

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan;      WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = %PROD%_NODE; WHERE = BAS(%PROD%);      USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = %T%; WHERE = %T%;USING = TMVL(-12,%T%); TOTAL = <<<;

*ENDALLOCATION

*NEXT

*NEXT

Testresult_ujkt

LGX:

*XDIM_MEMBERSET ACCOUNT = PL010

*XDIM_MEMBERSET RPTCURRENCY = USD

*XDIM_MEMBERSET ENTITY = US

*XDIM_MEMBERSET TIME = 2015.01

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan; WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = CPG_GRP12_NODE; WHERE = BAS(CPG_GRP12); USING = <<<; TOTAL = <<<;

*DIM TIME WHAT = 2015.01; WHERE = 2015.01;USING = 2014.01 , ; TOTAL = <<<;

*ENDALLOCATION

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

LOG:

LOG BEGIN TIME:2015-10-28 18:16:11

FILE:\ROOT\WEBFOLDERS\ENVIRONMENT830 \ADMINAPP\SKU_MODEL\TEST.LGF

USER:HANAUSER830

APPSET:ENVIRONMENT830

APPLICATION:SKU_MODEL

FACTOR:USING/TOTAL

ALLOCATION DATA REGION:

ACCOUNT:PL010,

RPTCURRENCY:USD,

ENTITY:US,

TIME:2015.01,

CATEGORY:WHAT:Plan,WHERE:Plan,USING:Actual,TOTAL:<<<

PRODUCT_ALLOC:WHAT:CPG_GRP12_NODE,WHERE:BAS(CPG_GRP12),USING:<<<,TOTAL:<<<

TIME:WHAT:2015.01,WHERE:2015.01,USING:2014.01 ,,TOTAL:<<<

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

--Read WHAT region

[CATEGORY] =Plan

[PRODUCT_ALLOC] =CPG_GRP12_NODE

[TIME] =2015.01

[ACCOUNT] =PL010

[RPTCURRENCY] =USD

[ENTITY] =US

--Time to load WHAT :0.111024 second(s).

WHAT data:0  records.

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

--Read USING region

[CATEGORY] =Actual

[PRODUCT_ALLOC] =CPG_PROD33,CPG_PROD34,CPG_PROD35,CPG_PROD36,CPG_PROD37,CPG_PROD38,CPG_PROD39,CPG_PROD40,CPG_PROD41

--Time to load USING :0.068331 second(s).

USING data:11  records.

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

--Merge WHAT and USING

--Time to merge WHAT and USING :0.000125 second(s).

Data after merging WHAT and USING   records.

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

--Apply factor

[CATEGORY] =Actual

[PRODUCT_ALLOC] =CPG_PROD33,CPG_PROD34,CPG_PROD35,CPG_PROD36,CPG_PROD37,CPG_PROD38,CPG_PROD39,CPG_PROD40,CPG_PROD41

TOTAL data:11  records.

WHERE=WHAT *USING/TOTAL

--Time to apply factor :0.072055 second(s).

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

--Read destination and calculate difference

[CATEGORY] =Plan

[PRODUCT_ALLOC] =CPG_PROD33,CPG_PROD34,CPG_PROD35,CPG_PROD36,CPG_PROD37,CPG_PROD38,CPG_PROD39,CPG_PROD40,CPG_PROD41

--Time to read destination and calculate difference :0.064421 second(s).

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

--Records succeeded to write back :3

--Records failed to write back

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

--Time to run Allocation :0.419278 second(s).

SCRIPT RUNNING TIME IN TOTAL:1.00 s.

LOG END TIME:2015-10-28 18:16:11

Reprts before allocation(Actuals)

TargetSetting:(Before allocation as well)

After allocation:

Pls suggest me further,if you find any thing wrong.

[former_member186338]

Same stupid question - where can I see base member CPG_GRP12_NODE on the report????

[Former Member]

    Sorry its my bad, i copied the wrong report , now updated with the new reports

    Thanks,

[former_member186338]

Do you understand me? Where is CPG_GRP12_NODE on the report????????

[Former Member]

Sorry Vadim, It seems to be some Data mess in the Product_dim.

Thanks for your support, i think i need to clean up the data first.

[Former Member]

[former_member186338]

You have the script that will allocate this value:

ACCOUNT = PL010

RPTCURRENCY = USD

ENTITY = US

TIME = 2015.01

CATEGORY = Plan

PRODUCT_ALLOC WHAT = CPG_GRP12_NODE

Strange description is not a big issue!

Show it on the report!

[Former Member]

with CPG_GRP12_NODE

[former_member186338]

And it's empty - zero will be allocated! No surprise!

[Former Member]

finally iam able to see some disrtibuted data, but no clue on wht basis is caliculating. its giving some data.Can you suggest me is it a correct data. this is executed only for CPG_GRP12 and with out When block.

Actuals

Target settting 20000

After disrtibution Plan

Thanks inadvance

[former_member186338]

20000 was distributed proportionally to the base values in 2014.01 to base values in 2015.01. You can check it:

2014.01

CPG_PROD40=300000

CPG_GRP12=473999 (Total)

CPG_PROD40_ratio =300000/473999=0.632913

2015.01

CPG_GRP12_NODE=20000

CPG_GRP12=CPG_GRP12_NODE * CPG_PROD40_ratio = 20000*0.632913=12658.25...

[Former Member]

Thanks Vadim, really appreciated for your patience. It seems to be perfect.One final question, if you explain this 2 lines it will be great or atleast what is the significance for this operator  =<<<

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM CATEGORY WHAT = Plan;      WHERE = Plan; USING = Actual; TOTAL = <<<;

*DIM PRODUCT_ALLOC WHAT = %PROD%_NODE; WHERE = BAS(%PROD%);      USING = <<<; TOTAL = <<<;

Thanks a lot Vadim

[former_member186338]

Read help! Fully explained!

[Former Member]

Thanks vadim, the below url explained.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e09eb0c0-87b1-2b10-06be-f1061a206...

[former_member186338]

This document is for BPC MS, and is not fully compatible with BPC NW.

Read standard help: *RUNALLOCATION - SAP Business Planning and Consolidation, version for SAP NetWeaver - SAP Library