Planning function Analyzer

[Former Member]

Dear all,

I have a planning function where I want to copy from multiple periods to an other period range. I read in a how-to-guide I could use this:

VAR_NAME_1 1 ZPERIODFROM

VAR_VALUE_1 1 2007001

VAR_VALUE_1 1 2007002

VAR_LINES_1 1 2

VAR_NAME_2 1 ZPERIODTO

VAR_VALUE_2 1 2008001

VAR_VALUE_2 1 2008002

VAR_LINES_2 1 2

But it only uses the last period 002. Is this something I can only use in combination with a planning sequence and not in a planning function?

Thanks.

Regards,

J.

[Former Member · Accepted solution]

Could you please try the following. It should work:

http://help.sap.com/saphelp_nw04/helpdata/en/07/ff413a3ace7022e10000000a11402f/content.htm

VAR_NAME_1 1 ZPERIODFROM

VAR_SIGN_1 1 I

VAR_OPERATOR_1 1 EQ

VAR_VALUE_1 1 2007001

VAR_NAME_2 1 ZPERIODFROM

VAR_SIGN_2 1 I

VAR_OPERATOR_2 1 EQ

VAR_VALUE_2 1 2007002

VAR_NAME_3 1 ZPERIODTO

VAR_SIGN_3 1 I

VAR_OPERATOR_3 1 EQ

VAR_VALUE_3 1 2008001

VAR_NAME_4 1 ZPERIODTO

VAR_SIGN_4 1 I

VAR_OPERATOR_4 1 EQ

VAR_VALUE_4 1 2008001

if you are using the external representation of the variable value you need to use

VAR_VALUE_EXT_1

[Former Member · Accepted solution]

Other tags are:

Variable name: VAR_NAME

Hierachy Variable: VAR_NODE_IOBJNM

Range-Operator: VAR_OPERATOR

Range-Sign: VAR_SIGN

Variable value (in internal format): VAR_VALUE

Variable value (in external format): VAR_VALUE_EXT

Variable value (Range-High in internal format): VAR_VALUE_HIGH

Variable value (Range-High in external format):VAR_VALUE_HIGH_EXT

Variable value (Range-Low in internal format):VAR_VALUE_LOW

Variable value (Range-Low in external format):VAR_VALUE_LOW_EXT

Of course you need the append the number suffix (_1, _2, etc.)

How to build planning application Workbooks in BI Integrated Planning

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f0881371-78a1-2910-f0b8-af3e1849...

[Former Member]

Hi,

1) your command is independent wether you use sequences or functions.

2) how does your copy function looks like (what is your from and to value?)

D

[Former Member]

Hi D,

I don't understand what you mean. My from and to values are the fiscal periods as in my question. Also I've a version value and fiscal year with from and to, but these are always single entries.

Regards,

J

Message was edited by:

Juriaan van de Pol

[Former Member]

How did you define your copy function. Please specify how the variables have been assigned. From what I see above, you should have created two "rows" (where you assign the from and to in your copy function) in your standard copy function.

D

[Former Member]

Hi D,

I've created a standard copy function with one row:

From: Period Multiple Single values (Mandatory)

To: Period Multiple Single values (Mandatory)

If I execute this with multiple periods then the function takes the last period entered.

Now I created a copy function like you suggested with three rows. But I want to be flexible in the number of periods I like to copy so I entered:

VAR_NAME_5 1 ZIPMSVFR (From)

VAR_NAME_6 1 Z_FYPMSV (To)

VAR_VALUE_5 1 2008005

VAR_VALUE_6 1 2008005

VAR_VALUE_5 1 2008006

VAR_VALUE_6 1 2008006

VAR_LINES_5 1 2

VAR_LINES_6 1 2

Still it executes only for period 6. Even if I take lines 3 then it will only executes the function for the last given period.

What am I doning wrong?

Regards,

J.

[Former Member]

Hi,

What happens if you execute this in the planning modeler?

D

[Former Member]

Hi D,

There is no problem all things copy like expected. But there's a difference offcourse how you enter your data.

I executed the standard function with three rows two times in the moderer.

First:

Period from: 004.2008;005.2008;006.2008

Period To: 004.2008;005.2008;006.2008

Second:

Period from: 007.2008;008.2008

Period To: 007.2008;008.2008

If I enter the values like this in the analyzer I get the error messages "007.2008;008.2008 isn't a number" or if I use 007.2008 it doesn't do anything. Fiscper needs to be called as 2008007 in the analyzer. (If you remember another post of me, this solved the issue.)

You see anything wrong?

J.

[Former Member]

OK,

so that means the problem is purelay located in BEX.

Could you try working with index = 0 instead of 1

D

[Former Member]

This doesn't change anything. It still executes the function only for the last entered period.

Do you use these type of functions with multiple values in the analyzer? And how does your variable declaration looks like in the analyzer?

I also tried to work with ranges _low and _high doesn't work either. (But that could be because this doesn't return single values to the system.)

J.

[Former Member]

Hi Juriaan

I didn't use multiple values for this type of copy function. What I did is let the user define an interval and write a simple FOX to do a copy with a certain logic (for example use previous year or something).

One other thing, could you send me an email regarding your performance problem: how many rows do you have in your BEX, how many tabs in your workbook and how long does it take to save? I'm having similar discussions with SAP this very moment

Dries