Data Allocation Document

[Former Member]

Hi all,

The document given for data allocation in SAP site is for Microsoft platform.Will that work for Netweaver platform?????

I cannot allocate data even for simple allocation.. even the what and where are not working properly...

and getting many problems in syntax too....

As given in doc,

The syntax is something like below...

*DIM ACCT WHAT=RENT; WHERE=<<<; USING=<<<

i tried this and got error saying [] missing...So i tried many combination and after using the below syntax the error went off...

*DIM ACCT [WHAT=RENT;] [WHERE=<<<<;] [USING=<<<]

and i cannot use COUNT keyword its showing error...

and i cannot initialize factor value to something like 1/100...Its throwing error for this too...

If am using the keyword USING alone in initializing FACTOR (ie. FACTOR=USING) then all the values are getting squared....

Eventhough the error went off the allocation is not working proper for the given dimensions in What and Where....

Please help me out in solving this...

Thanks in Advance...

Regards,

G.Vijaya Kumar.

[SEdelstein]

Hi Vijaya -

The ability to access and post to multiple applications using Allocation does not currently work. All records need to be sourced from within the same (home, or "calling") application.

I was able to successfully allocate in a BPC70NWSP04 system using the following code:

*RUNALLOCATION 
*FACTOR=USING/TOTAL 
*APP WHAT=PLANNING; WHERE<<<;USING<<<;TOTAL<<< 
*DIM P_ACCT WHAT=CE0004010; WHERE=CE0004020; USING=CE0004030; TOTAL=<<< 
*DIM ENTITY WHAT=A1000; WHERE=<<<; USING=<<<; TOTAL=<<< 
*DIM TIME WHAT=2009.JAN; WHERE=>>>; USING=BAS(2009.TOTAL); TOTAL=<<< 
*ENDALLOCATION

(Explanation: a record exists for the data intersection at P_ACCT CE0004010/Entity=A1000/TIME=209.JAN...this record is allocated based upon the value distribution in all months of 2009 for the P_ACCT CE0004030, the allocated values are then stored in all months of 2009 and P_Acct CE0004020)

The follow code also "ran", but posted the allocated values in the wrong application (values were posted into the application called "PLANNING", not the application "PLANNING2" as coded:

*RUNALLOCATION              
*FACTOR=USING/TOTAL 
*APP WHAT=PLANNING; WHERE=PLANNING2; USING=PLANNING; TOTAL=PLANNING 
*DIM P_ACCT WHAT=CE0004010; WHERE=CE0004020; USING=CE0004030; TOTAL=<<< 
*DIM ENTITY WHAT=A1000; WHERE=<<<; USING=<<<; TOTAL=<<<     
*DIM TIME WHAT=2009.JAN; WHERE=>>>; USING=BAS(2009.TOTAL); TOTAL=<<<         
*ENDALLOCATION 

Regards,

Sheldon

[Former Member]

Hi Sheldon,

Is it possible to use the values stored in a property as the factor in an allocation? For example, I have to allocate cost centers to business units based on percentages that are assigned to each cost center by business units which are the property names. Below is my code which validates successfully; however, the package errors out with the following: RUN_LOGIC:Region WHERE <<< or USING [EBU] has many members, but they are not equal.

*RUNALLOCATION
*FACTOR = USING
*DIM COSTCTR         WHAT=BAS(CC_TOTAL_PL);   WHERE=<<<;                USING=[EBU];     
*DIM ACCOUNTCC         WHAT=BAS(SGA_SVC_EXP);   WHERE=<<<;                USING=<<<;     
*DIM ENTITY                 WHAT=BAS(TOTAL_ENTITIES);                            WHERE=<<<;                USING=<<<;            
*DIM BU         	WHAT=NO_BU;                                WHERE=EBU;            USING=<<<;
*DIM DATASRC                     WHAT=<>ALLOC;        WHERE=ALLOC;                USING=<<<;
*ENDALLOCATION
*COMMIT

I appreciate your help.

Regards,

Karen

[Former Member]

Hi Sheldon,

The Problem is,

I have used Formula Property for the value to be allocated. Thats why the logic was not working for me. Once i removed the formula property and tried the same logic, The Script is working fine.

Thanks For your reply,

Regards,

G.Vijaya Kumar.

[esjewett]

Hi,

You may want to take a look at the article on top-down allocations in BPC for NW: [https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/90b58cfe-6ae8-2b10-7b87-e83ebbc5be45]

It includes an example that should get you on the right track.

Because script logic in the NW version is more limited in some respects than script logic in the MS version, you will not be able to do certain types of automatic allocations or other functions that you would be able to in MS.

Ethan