Routine to fill ODS with data current year and previous year

[Former Member]

Hello,

I want to create a routine on the field 0FISCPER which fill an ODS with the data of the current year and the previous year.

Can you help me?

[m_verbaan2]

Hi Isabelle,

In the Start routine of the update rules (or Transformations in BI7.0) code something like:

data: l_current_fiscyr(4) type n,

l_prev_fiscyr(4) type n.

l_current_fiscyr = source_package-fiscper(4).

l_prev_fiscyr = l_current_fiscyr - 1.

delete source_package where fiscyear <> l_current_fiscyr and

fiscyear <> l_prev_fiscyr.

(pls note this is pseudo-code mostly)

Hope it helps.

Grtx

M.