Explanation is req for Planning func using fox

[subramanianselvan]

Hi all

Pls explain the following func.

FOREACH FUNCAREA.

FOREACH PLGITM IN SELECTION.

{0BALANCE, #, Q3CY, 009, CY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH} = {0BALANCE, #, Q3CYPRE, CLSDPER3PRE, CY, FUNCAREA, 0SEM_C06, PLGITM, 001, 010, #} + {0AMOUNT, #, Q3CY, 009, CY, FUNCAREA, 0SEM_C18, PLGITM, 000, 020, FCMONTH}.

{0BALANCE, #, Q4CY, 012, CY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH} = {0BALANCE, #, Q3CY, 009, CY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH} + {0AMOUNT, #, Q4CY, 012, CY, FUNCAREA, 0SEM_C18, PLGITM, 000, 020, FCMONTH}.

{0BALANCE, #, Q1NY, 003, NY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH} = {0AMOUNT, #, Q1NY, 003, NY, FUNCAREA, 0SEM_C18, PLGITM, 000, 020, FCMONTH}.

{0BALANCE, #, Q2NY, 006, NY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH} = {0BALANCE, #, Q1NY, 003, NY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH}+ {0AMOUNT, #, Q2NY, 006, NY, FUNCAREA, 0SEM_C18, PLGITM, 000, 020, FCMONTH}.

{0BALANCE, #, Q3NY, 009, NY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH} = {0BALANCE, #, Q2NY, 006, NY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH}+ {0AMOUNT, #, Q3NY, 009, NY, FUNCAREA, 0SEM_C18, PLGITM, 000, 020, FCMONTH}.

{0BALANCE, #, Q4NY, 012, NY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH} = {0BALANCE, #, Q3NY, 009, NY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH}+ {0AMOUNT, #, Q4NY, 012, NY, FUNCAREA, 0SEM_C18, PLGITM, 000, 020, FCMONTH}.

{0BALANCE, #, Q1NY, 003, NY, FUNCAREA, 0SEM_C06, PLGITM, 001, 020, FCMONTH} = {0AMOUNT, #, Q1NY, 003, NY, FUNCAREA, 0SEM_C18, PLGITM, 001, 020, FCMONTH}.

{0BALANCE, #, Q2NY, 006, NY, FUNCAREA, 0SEM_C06, PLGITM, 001, 020, FCMONTH} = {0BALANCE, #, Q1NY, 003, NY, FUNCAREA, 0SEM_C06, PLGITM, 001, 020, FCMONTH}+ {0AMOUNT, #, Q2NY, 006, NY, FUNCAREA, 0SEM_C18, PLGITM, 001, 020, FCMONTH}.

{0BALANCE, #, Q3NY, 009, NY, FUNCAREA, 0SEM_C06, PLGITM, 001, 020, FCMONTH} = {0BALANCE, #, Q2NY, 006, NY, FUNCAREA, 0SEM_C06, PLGITM, 001, 020, FCMONTH}+ {0AMOUNT, #, Q3NY, 009, NY, FUNCAREA, 0SEM_C18, PLGITM, 001, 020, FCMONTH}.

{0BALANCE, #, Q4NY, 012, NY, FUNCAREA, 0SEM_C06, PLGITM, 001, 020, FCMONTH} = {0BALANCE, #, Q3NY, 009, NY, FUNCAREA, 0SEM_C06, PLGITM, 001, 020, FCMONTH}+ {0AMOUNT, #, Q4NY, 012, NY, FUNCAREA, 0SEM_C18, PLGITM, 001, 020, FCMONTH}.

ENDFOR.

ENDFOR.

-

---

Operand:{Key figure name, 0ACCNT_ASGN, 0FISCPER, 0FISCPER3, 0FISCYEAR, 0FUNC_AREA, 0INFOPROV, 0SEM_POSIT, 0VERSION, 0VTYPE, ZFCMONTH}

___________________________________________________________________________________

In Filter one cube 0sem_c06 is restricted. Our scope is to copy values from 0sem_c18, acc to the period condition.

For each func area and planning item means..from which cube it will search.

regards

perasel

[Former Member]

Hi,

It seems that you are using IP, in that case can you tell in which filter the restriction is on InfoProvider. Is it in the filter used in planning sequence or in Input-ready query?

Also, first statement in your code i.e.

{0BALANCE, #, Q3CY, 009, CY, FUNCAREA, 0SEM_C06, PLGITM, 000, 020, FCMONTH} = {0BALANCE, #, Q3CYPRE, CLSDPER3PRE, CY, FUNCAREA, 0SEM_C06, PLGITM, 001, 010, #} + {0AMOUNT, #, Q3CY, 009, CY, FUNCAREA, 0SEM_C18, PLGITM, 000, 020, FCMONTH}.

contains variables Q3CYPRE, CLSDPER3PRE whose values are not clear.

It seems that you have not pasted complete FOX, so, based on whatever you have pasted below are my comments:

It runs for each function area in records selected by planning function and for the item in selection

1. For the end of the first Quarter( which is posting period 003) of the Current Year & Next Year, it simply assigns value of 0AMOUNT from 0SEM_C18 cube to 0BALANCE of 0SEM_C06 for versions 000 (for current year) & 001(for next year) and value type 020.

2. For the quarters Q2, Q3, Q4(ending in 006, 009 & 012 posting periods) of current year & next year, it adds 0AMOUNT of the same quarter & period from cube 0SEM_C18 to 0BALANCE of previous quarter & end period of that previous quarter from cube 0SEM_C06, and assign that sum to 0BALANCE of this quarter & period in cube 0SEM_C06 for versions 000 (for current year) & 001(for next year) and value type 020.

Basically it is calculating closing balance for each quarter by adding amount of current quarter to the balance of last quarter for current & next year and storing the values in 0SEM_C06 cube in two different versions 000 & 001.

Is this code running already?

Regards,

Deepti