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