BPC/BW Planning Function Error - Parent Member

[Former Member]

Hi

Running BPC Embedded (10.4) and BW 7.4.

Im trying to use a parent member in a planning function but cannot save the function as I get the following error: "Formula element 'TOTALSHOPS' could not be recognized".

TOTALSHOPS is a member of the data source dimension which has a number of children underneath it.

The code for this simple formula is below:

DATA ZVAL TYPE F.

ZVAL = { ZVALUE | 0GL_ACCOUNT = 0000401000, ZDATASRC = TOTALSHOPS, ZPRODUCT = # }.

{ ZVALUE } = { ZVALUE } * ZVAL.

The conditions for this formula are one GL account where a % currently sits (and I want the answer to ultimately sit) and a bottom level member for both data source and product (401000 and # are bottom level members too).

I know I could probably just create a copy function which runs before this, to copy out the intersection at the parent data source to a base level member, but im sure there must be a way of doing this within the one function?

Any advice appreciated.

Cheers

JB

[gregor_dieckmann · Accepted solution]

Hi John,

in BPC Embedded you cannot access 'parent members' in planning functions, only 'base members' are exposed in planning functions. In BW a parent member is never stored in the fact table, i.e. values for parent members are by definition aggregated values (and never stored somewhere). In addition, a parent member technically may be a text node or a node with respect to a foreign characteristic this is why you cannot put these objects in a FOX statements where only base member values are expected.

In other words you have to access key figure values on inner hierarchy nodes you have to aggregate the value in FOX.

Regards,

Gregor

[Former Member · Accepted solution]

Hi Gregor

Thanks for coming back to me and for explaining this, will keep this in mind going forward.

Does your final paragraph ...

In other words you have to access key figure values on inner hierarchy nodes you have to aggregate the value in FOX.

... suggest that there is a way to use an inner hierarchy node if you use some sort of aggregation function within the FOX formula? I am not necessarily expecting to be spoon fed all of the correct syntax for this, but if there is a link you can provide to the particulars of the function then I will take a shot at it myself.

Cheers

JB

[gregor_dieckmann · Accepted solution]

Hi John,

by now FOX has no build in 'hierarchy aggregation function'. In the FOX editor check the FOX documentation (Info button) and there the section 'loop constructs'. So the idea is to compute the node value from the leaves e.g. from transaction data (hierarchy node selection in the filter and FOREACH loop). Another idea: you may also check whether

FOREACH Variable IN VARIABLE Var

with Var a hierarchy node variable solves the problem.

Regards,

Gregor

[Former Member · Accepted solution]

Thanks Gregor, I appreciate your time.