Hi all,
I have the following logic and DM package:
Logic
*XDIM_MEMBERSET ZAMAN=2010_Ekim,2011_Ekim
*XDIM_MEMBERSET FIYAT_TIPI=Donem
*XDIM_MEMBERSET FAKULTE_BOLUM=Mat
*XDIM_MEMBERSET INDIRIM_TIPI=0
*XDIM_MEMBERSET OGRENCI_TIPI=2.Ogretim
*XDIM_MEMBERSET PARA_BIRIMI=Dolar
*XDIM_MEMBERSET SINIF=0
*XDIM_MEMBERSET PARA_BIRIMI=USD
*XDIM_MEMBERSET OWNER_DIM=User1
*XDIM_MEMBERSET ENTITY=BAS(H1)
*XDIM_MEMBERSET CATEGORY=PLAN,ACTUAL
[Account].[#Alloc]=$Toplam$
*COMMIT
*RUNALLOCATION
*FACTOR=USING/TOTAL
*DIM ENTITY WHAT=BAS(H1); WHERE=BAS(H1); USING=BAS(H1); TOTAL=BAS(H1)
*DIM ACCOUNT WHAT=Alloc; WHERE=Egitim Ucreti; USING=Egitim Ucreti; TOTAL=Egitim Ucreti
*DIM CATEGORY WHAT=ACTUAL; WHERE=PLAN; USING=ACTUAL; TOTAL=ACTUAL
*DIM TIME WHAT=2010_Ekim; WHERE=2011_Ekim; USING=2010_Ekim; TOTAL=2010_Ekim
*ENDALLOCATION
*COMMIT
Package:
PROMPT(TEXT,%Toplam%,"The amount to be allocated",)
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/ALLOCATION_LOGIC,SUSER,%USER%)
TASK(/CPMB/ALLOCATION_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/ALLOCATION_LOGIC,SAPP,%APP%)
TASK(/CPMB/ALLOCATION_LOGIC,LOGICFILENAME,DENEME 123.LGF)
TASK(/CPMB/ALLOCATION_LOGIC,REPLACEPARAM,Toplam%EQU%%Toplam%)
What I want to do here is reading base members of H1,ACTUAL,2010_EKIM and the alloc value that the user inputs(this is my WHAT ) and then write them to BAS(H1),Egitim Ucreti PLAN and 2011_Ekim (this is my WHERE )with the proportions in BAS(H1),Egitim Ucreti,ACTUAL,2010_Ekim(this is my USING )
I am not sure if I understand the logic of allocation well.The allocation writes no records to the members in WHERE.
What may be wrong with the code?I run the package that allocation is included without any problem an I see that it reads each WHERE,WHAT,USING and alloc in formula log and generate records but records written back is always 0.
By the way, there are records(to write back) corresponding to members written in WHAT and XDIM_MEMBERSET .
Hi Güneş,
you have 2 lines with *XDIM_MEMBERSET PARA_BIRIMI only the second will be used
*XDIM_MEMBERSET PARA_BIRIMI=Dolar
*XDIM_MEMBERSET PARA_BIRIMI=USD
change
*DIM ENTITY WHAT=BAS(H1); WHERE=BAS(H1); USING=BAS(H1); TOTAL=BAS(H1)
*DIM ACCOUNT WHAT=Alloc; WHERE=Egitim Ucreti; USING=Egitim Ucreti; TOTAL=Egitim Ucreti
*DIM CATEGORY WHAT=ACTUAL; WHERE=PLAN; USING=ACTUAL; TOTAL=ACTUAL
*DIM TIME WHAT=2010_Ekim; WHERE=2011_Ekim; USING=2010_Ekim; TOTAL=2010_Ekim
with
*DIM ENTITY WHAT=BAS(H1); WHERE=<<<; USING=<<<; TOTAL=<<<
*DIM ACCOUNT WHAT=Alloc; WHERE=Egitim Ucreti; USING=<<<; TOTAL=<<< by the way is "Egitim Ucreti" a code? Are you sure you can use it with a blank inside?
*DIM CATEGORY WHAT=ACTUAL; WHERE=PLAN; USING=ACTUAL; TOTAL=<<<
*DIM TIME WHAT=2010_Ekim; WHERE=2011_Ekim; USING=2010_Ekim; TOTAL=<<<
Other doubts
you defined *XDIM_MEMBERSET ZAMAN=2010_Ekim,2011_Ekim but after in the Runallocation you use TIME is this right?
You doesn't use *XDIM_MEMBERSET for ACCOUNT.
Kind regards
Roberto
Add a comment