Executing FOX Formulas for all key figures in NW2004s

[Former Member]

In planning functions of type Formula it is possible to write FOx

functions that operate on all key figures contained within the Planning

Level.

SAP Help for NW2004s states on the following page <a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/d3/8057f830a911d4b2be0050dadfb23f/frameset.htm">SAP Help for Formulas</a> that "For the fields to be changed, select characteristics only and not the generic entry key figure name. The transformation is performed for all the key figures of a planning

level. It is not necessary to formulate a separate equation for all key

figures."

This was available in both SEM-BPS and BW-BPS however in the NW2004s

Planning Modeller, when selecting the 'fields to be changed' there is

no generic 'Key Figure Name' option.

Is this a defect we should raise with SAP or is there a reason for this change? If so

do we need to manually iterate though each key figure in a foreach loop?

RM

[Former Member]

Hi Srini,

No the opposite is the case: Key Figure will always be in the operand and the Key Figure option in the 'fields to be changed' will no longer appear.

To replicate this function it will now be necessary to do a FOREACH loop through each key figure.

Cheers,

R

[Former Member]

Hi RM,

Thanks for the update.

Cheers

Srini

[Former Member]

We just received confirmation from Waldorf that this functionality has been removed from Integrated Planning in NW2004s.

Their response was that this feature was not often used.

[Former Member]

RM,

Just to confirm, SAP said they will be taking out the Key Figure from the operand unless explicitly stated in the fields to be changed ? Did they tell you what patch of NW2004s they are going to have this.

Cheers

Srini

[Former Member]

Hi Andrew,

Your statement that "you should find that by default that when you execute your fox all three key figures will be transformed, without having to specify them directly" is what I expected. However sytactically the planning modeller states this is incorrect as the operand is expecting Key Figure, however there is now way of removing the key figure selection from the operand!

Cheers

[Former Member]

you should find that by default that when you execute your fox all three key figures will be transformed, without having to specify them directly.

If you only want to affect one of them you just to exclude the other two from the aggregation level

[Former Member]

Hi Andrew,

So in terms of specifics I have, in new world terminology, an Aggregation Level with 3 key figures. I wish to work on all 3 key figures. However in my Planning Function the Key Figure Name option is not present in the fields to be changed and the operand includes Key Figure.

In SEM/BW-BPS I would have selected this option and Key Figure would not appear in my operand.

Cheers,

[Former Member]

its not refering to what you include or do not include in fields to be changed but the query/level definition yuo execute the function against.

Think about it in SEM_BPS terms, you definie a Planning Area, Planning Level, and Package, then within a level you create the plannnig functions. If your level had more than one key figure in it then "Key Figure Name' became available to be selected as a field to be changed in your FOX formulae conditions and you could reference them in your FOX Code paremeter group.

If you did not select 'Key Figure Name' then by default it works on all key figures.

Remeber when you create a Planning Level you get to chose what Characteristics AND Key Figures are included.

It is not talking about the selection of fields to be changed, but the actual definition of the query/laevel that you are executing against.

[Former Member]

Hi Andrew,

Thanks for your reply. Maybe I didn't explain this sufficiently.

I agree that you could exclude the key figures from the function definition by not selecting Key Figures to be changed. This way you could just reference characteristics (e.g. {Value Type 1 = Value Type 2} ).

However in NW2004s there seems to be no way of removing Key Figure from the Formula operand and therefore I have to explicitly loop throguh the key figures.

[Former Member]

yes, that is the default functionality, I think you are reading it incorrectly, your third paragraph is entirely consistent with the second it does not sound like a problem.

as the help says it will apply the logic to ALL key figures selected in the level, if you only want to work with one key figure you only include it in the level definition, if you include multiple key figures the logic is applied to all of them. You no longer select or reference key figures directly in the fox code and formulae field to be changed. What you select in the Level definition is what is transformed.