Skip to Content
author's profile photo Former Member
Former Member

Allocation records succeeded to write back is 0

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 .

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 13, 2012 at 02:25 PM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.