Skip to Content

Actual N-1 + Planning N with dynamic 0FISCPER

Hi all,

Hi have a request to display in a report a structure with 2 columns:
- Actual data year N-1 (Infoprovider A)

- Planned data year N (Infoprovider B)

0FISCPER is on top of the structure so that the structure can extend dynamically.

There is also a range with 2 variables in static filter for 0FISCPER (Fiscper from & Fiscper to).

I use "constant selection" in column Actual data with an offset [Fiscper from -12 -> Fiscper to -12] so that I can display Actuals N-1 compared to planned data N.

My issue is that I can find a way to display more than 12 months.

For example, if I select 001.2014 to 006.2015 (18 months), Actuals 001.2014 and 001.2015 are cumulated.

Thanks for your help.

Ronan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 03, 2015 at 01:02 PM

    Hi Ronan,

    Choose standard variable for current fiscal period and keep it in your monthly columns.

    Choose another variable with range which will accept input from user. Use this variable for these two key figures.

    So that in this variable, you can give date range and get the expected results as well.

    You can achieve it with single variable as well by taking lower range consideration for monthly calculations.

    Hope answering - Kumar

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Kumar,

      I implemented your solution (variable Current value + Range variable) and removed FISCPER from general filter (so that no need to have "constant selection") and it worked.

      Thank you all for your help.

      Kind regards

      Ronan

  • avatar image
    Former Member
    Nov 03, 2015 at 06:03 PM

    Hi Ronan,

    There would be 2 options

    Option 1: Using Cell Definitions either for Actual year or Planned year with restriction on the respective infoprovider.

    Option 2: This is a better option than cell definition.

    A.) Create a replacement path variable which get's the fiscal year period from the user's input.

    B.) Use offset for this replacement path variable in the RKF. This would not interfere with your Year-1 values.

    Thanks,

    Krishna.

    Add comment
    10|10000 characters needed characters exceeded