Skip to Content
0
Dec 14, 2011 at 06:56 PM

ALLOCATION error

44 Views

Hi,

I'm writting an allocation in which I declare a variable (%LIST_CD1%) in a SELECT statement.

Then I use the list to define my CD1 members.

In my CD2 dimension, I want the script to use the corresponding members using the SEG property (which is filled in with the members of CD1).

The Script:

*SELECT(%LIST_CD1%,"ID","CD1","ALLOC='Y'")

*XDIM_MEMBERSET TIME=%TIME_SET%

*XDIM_MEMBERSET C_CATEGORY=%C_CATEGORY_SET%

*RUNALLOCATION

*FACTOR=-USING

*DIM C_ACCT WHAT=BAS(5300000T); WHERE=5300000A; USING=5300000A

*DIM C_DATASRC WHAT=INPUT_MAN; WHERE=ALLOCATED; USING=ALLOCKEY

*DIM CD1 WHAT=%LIST_CD1%; WHERE=BAS(S1701); USING=BAS(S1701)

*DIM CD2 WHAT=<ALL>; WHERE=<ALL>; USING=[SEG]=%LIST_CD1%

*DIM ENTITY WHAT=<ALL>; WHERE=<ALL>; USING=1000

*DIM INTCO WHAT=<ALL>; WHERE=<ALL>; USING=Non_InterCo

*DIM RPTCURRENCY WHAT=LC; WHERE=LC; USING=LC

*DIM CD3 WHAT=NONE; WHERE=<<<; USING=<<<

*DIM CONSOSCOPE WHAT=G_NONE; WHERE=<<<; USING=<<<

*ENDALLOCATION

*COMMIT

When I validate and save the script, it returns the following error message:

Application: CMR

Logic file: Allocation.LGF

Validation status of executable file: Failed

- Invalid column name 'S17090101'. in:select [ID] from mbrCD2 where [SEG]=S17090101

Validation status of syntax: Success

Rem: 'S17090101' is the first member of the list generated by the SELECT statement.

Any idea on how to solve that ?

Thanks in advance for your help.

Yoann