Variable with range- only 1st value used in manual planning ?

[Former Member]

Hi,

We're trying to define a column in a manual planning layout that will represent a YTD total. We have defined a variable for 0fiscper that contains the range of periods we require in the YTD total. When we execute that manual planning area with this variable used as a restriction on the data column we want, the key figure values displayed only represent those for the 1st period in the range - not all periods in the range !

I'm hoping someone can tell me if manual planning layouts can use variables in this manner. If not, how can this best be done ?

Many thanks,

Blair

[Former Member · Accepted solution]

Hi Marc,

Thanks for your reply.

I have tried using dynamic columns as you suggested, however this gives me a column per value in the variable's range. What I was hoping to achieve was the total values for all periods in the range to be shown in 1 column.

For example, variable ACTYTD of type 0fiscper is assigned the selection interval 001.2006 - 008.2006.

Instead of 1 column per period, I would like to to assign the variable ACTYTD to a data column and have the values for 001.2006 - 008.2006 display in that 1 column only (essentially a total for these periods).

Can it work this way ?

Thanks for your assistance.

Regards,

Blair

[Former Member · Accepted solution]

Hi Blair,

Create a total column using the dynamic column, as a result you would have the individual period columns and the total column in the layout. Now make the individual period columns hidden using any of the options below.

You could achieve the same, by making the column hidden in the transaction UPX_MNTN

> Enhance Planning Layout

> Select the relevant layout

> Select the enhanced button for the key figure

column

> Mark the hidden check box there.

Alternatively if you are using Excel GUI, you could set the column width of the columns preceeding the total column as 0 (in the third screen of the layout) to make them hidden.

Hope it helps

[Former Member]

Hi Anurag,

That did it - Many thanks !

Regards,

Blair

[former_member93896]

Hi Blair,

on the first screen of the layout builder, you have to set the data columns to be dynamic (based on fiscal period).

Regards,

Marc

SAP NetWeaver RIG