BPC 10.0 Allocation using percentage set in fixed period (Dec)

[former_member232506]

Dear Team,

I am trying to do an allocation in BPC 10.0 system but getting an error while running script for multiple time members. The error is : UJK_VALIDATION_EXCEPTION:Member "2017" not exist.

Script example is below:

//Get source Category

*SELECT(%SRC_CAT%,SRC_ALLOCATE,CATEGORY,ID = %CATEGORY_SET%) //YEAR

*SELECT(%YEAR_1%,YEAR,TIME,ID = %TIME_SET%)

//Scope

*XDIM_MEMBERSET AUDITID = BAS(TOTAL_INPUT)

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET COST_CTR = %COST_CTR_SET%

*XDIM_MEMBERSET COST_ELEMENT = <ALL>

*XDIM_MEMBERSET ANALYSIS = SBU_NONE

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET TIME = BAS(%TIME_SET%)

*FOR %TIME% = %TIME_SET%

*RUNALLOCATION *FACTOR = USING/TOTAL

//AUDITID

*DIM AUDITID WHAT = BAS(TOTAL_INPUT); WHERE = <<<; Using = AL01_SBU; Total = <<<

//CATEGORY

*DIM CATEGORY WHAT = %CATEGORY_SET%; WHERE = <<<; Using = %SRC_CAT%; Total = <<<

// RPTCURRENCY

*DIM RPTCURRENCY WHAT = LC; WHERE = <<<; Using = LC; Total = <<<

// ANALYSIS

*DIM ANALYSIS WHAT = SBU_NONE; WHERE = >>>; Using = BAS(TOTAL_SBU); Total = <<< // COST_ELEMENT *DIM_NONAGGR COST_ELEMENT WHAT=[RATETYPE]="AVG" ; WHERE = <<<; Using = CE_NONE; Total = <<<

// TIME

*DIM TIME WHAT = BAS(%TIME%); WHERE = <<<; Using = %YEAR_1%.12; Total = <<<

*ENDALLOCATION

*NEXT

In *DIM TIME WHAT= BAS(%TIME), I have also tried %YEAR_1%.01 using When and Endwhen based on Monthnum property but still get the same issue. The script is working for a single month. It doesnt work when I try to execute it for multiple months in the same year.

Appreciate your help. Thanks, MJ

[former_member186338]

Not possible to answer to "Former Member"

And for the person who is unable to understand the difference between BPC NW and BPC MS tags...

[former_member232506]

Consider SBU as Profit centre. When cost are planned, they are planned with member "None" for Profit centre.

[former_member186338]

Looks like you have no time to provide full and clear info!

Then I have no time to answer your question! It's a free service, by the way!

[former_member232506]

//Get source Category
*SELECT(%SRC_CAT%,SRC_ALLOCATE,CATEGORY,ID = %CATEGORY_SET%)

//YEAR
*SELECT(%YEAR1%,YEAR,TIME,ID = %TIME_SET%)

//Scope
*XDIM_MEMBERSET AUDITID = BAS(TOTAL_INPUT)
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET COST_CTR = %COST_CTR_SET%
*XDIM_MEMBERSET COST_ELEMENT = <ALL>
*XDIM_MEMBERSET ANALYSIS = SBU_NONE
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET TIME = BAS(%TIME_SET%)

*FOR %TIME% = %TIME_SET%
*RUNALLOCATION

*FACTOR = USING/TOTAL

//AUDITID
*DIM AUDITID WHAT = BAS(TOTAL_INPUT); WHERE = <<<; Using = AL01_SBU; Total = <<<

//CATEGORY
*DIM CATEGORY WHAT = %CATEGORY_SET%; WHERE = <<<; Using = %SRC_CAT%; Total = <<<

// RPTCURRENCY
*DIM RPTCURRENCY WHAT = LC; WHERE = <<<; Using = LC; Total = <<<


// ANALYSIS
*DIM ANALYSIS WHAT = SBU_NONE; WHERE = >>>; Using = BAS(TOTAL_SBU); Total = <<<

// COST_ELEMENT
*DIM_NONAGGR COST_ELEMENT WHAT=[RATETYPE]="AVG" ; WHERE = <<<; Using = CE_NONE; Total
= <<<

// TIME
*DIM TIME WHAT = BAS(%TIME%); WHERE = <<<; Using = %YEAR_1%.12; Total = <<<

*ENDALLOCATION
*NEXT

The scenario is:
Source: Costs are planned without on SBU (Analysis dimension- SBU_NONE) with rest of dimensions (Cost centre, Cost element, Reporting currency, Time, Audit ID, Category)

Factors are maintained against each SBU in DEC (one month only) which needs to be applied across all months in same year. 

Target: Allocate cost without SBU to individual SBU as per factors planned.
SRC_ALLOCATE identifies the Category to be used for factors as it may not be maintained against each individual Category member.

Let me know if you still have any question. 

Thanks, MJ

[former_member186338]

Read again: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

Use code only for code - your post still looks bad!

No other info provided!

No samples!

Do you really need an answer?

[former_member186338]

Costs are planned without on SBU

What do you mean???

[former_member232506]

Hi Vadim,

I have updated setting and tag too. Are you able to review it now?

Thanks

[former_member186338]

Now, please read: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

And provide required info!

I am unable to comment without understanding the required logic and other things...

Also use "Code" button to make your question readable!