Skip to Content
0
May 16, 2018 at 10:55 AM

BPC Embedded: Static (Non-Rolling) Planning Cycle - 2 Years - Exits or A Better Option?

146 Views Last edit May 16, 2018 at 01:12 PM 3 rev

Case

I am trying to define a column structure where I have a combination of Category/Version and Time infoobjects. The query

Selection:

  • Fiscal Period (1st planning period in the planning cycle in the first year)
  • Category (Forecast1, Forecast2, etc)

Example:

By selecting Forecast and Period 2018.005, we should set the range 2018.001-2018.004 to Actual category/version and 2018-005-2019.012 to Forecast.

Exits Solution

I was able to achieve it by defining 11 exit variables for each period 2018.001-2018.011 and using the restricted key-figures functionality. The second year is always Forecast so no need for additional variables.

I don't like this approach as it calls 11 times the exit BADI. I believe it has a bad impact on the performance which has an explanation.

I tried to use just one exit variable and then overwriting the rest manual non-input type variables with a default value, but I wasn't able to Modify/Overwrite i_t_var_range as it is not allowed.

Question

Is there a better and more efficient way to create/develop that scenario? At least from the performance perspective?