Actual N-1 + Planning N with dynamic 0FISCPER

[rpattier]

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

[Former Member · Accepted solution]

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

[rpattier · Accepted solution]

Hi Kumar,

Thanks for your answer.

I tried to implement your suggestion and I get the following result for the selection 001.2015->001.2016 (13 months):

-> 001.2015

Column 1: Actual 001.2015

Column 2: Plan data 001.2015

-> 002.2015

Column 1: Actual 002.2015

Column 2: Plan data 002.2015

...

-> 001.2016:

Column 1: Actual 001.2016

Column 2: Plan data 2016

What I would like to get is

-> 001.2015

Column 1: Actual 001.2014

Column 2: Plan data 001.2015

-> 002.2015

Column 1: Actual 002.2014

Column 2: Plan data 002.2015

...

-> 001.2016

Column 1: Actual 001.2015

Column 2: Plan Data 001.2016

FYI: Current value variables are not compatible with "select option" parameter.

Thank you if you have an idea

Kind regards

Ronan

[former_member220624 · Accepted solution]

Hi Ronan,

How about deriving the year first from fiscal period using ofset length like 004.2015 becomes 2015 by using offset length 4(4) and then providing offset of -1 to display the actual data for previous year

Regards,

Amit

[Former Member · Accepted solution]

Hi Ronan,

I am taking 001.2015 as input.

Here you need fiscper changes for only Actual data. Inside column restrictions, maintain offset as -12 as the flow required is exactly -12.

[Right click on selected variable -> select offset -> give 12].

SCN way of thank is .

Regards - Kumar

[rpattier · Accepted solution]

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

[Former Member]

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.