Skip to Content
0
Former Member
Dec 05, 2008 at 12:10 PM

Incorrect value with Script Logic

26 Views

Hello,

From initial value called 2008.ORC we want to calculate for each month the percentage , from child DIASMES.

Now, with the script logic ( I´ll put down later) we have an incorrect value in the column 2008.TOTAL.

In other words, I´m sure I´m wrong with "WHAT" or "WHERE sentence or maybe the operation "FACTOR=USING/TOTAL" fails because the crossing between dimensions it´s incorrect.

*RUNALLOCATION

*FACTOR = USING/TOTAL

*DIM FABRICA_MAQ WHAT=BAS(FABRICAFF); WHERE=BAS(FABRICAFF); USING=BAS(FABRICAFF);

*DIM PRODUTOS WHAT=BAS(TOTALPROD); WHERE=BAS(TOTALPROD); USING=SP;

*DIM TIME WHAT=2008.ORC;WHERE=BAS(2008.TOTAL); USING=BAS(2008.TOTAL);

*DIM TIPO WHAT=BAS(TOT); WHERE=BAS(TOT); USING=ST;

*DIM VARIAVEIS WHAT=MIXACABADA; WHERE=MIXACABADA; USING=DIASMES;

*DIM DATASRC WHAT=INPUT; WHERE=INPUT; USING=INPUT;

*DIM VERSAO WHAT=BUDGET; WHERE=BUDGET; USING=BUDGET;

*ENDALLOCATION

*COMMIT

The Key is to see in the column 2008.TOTAL ( when we selected "BAS") the value of parent divided into "DIASMES" !

Thanks !! 😊