Apply BPC logic script on Parent entities

[former_member590808]

Hello

Business users have a requirement where at parent Entities the logic of BPC script should be applied. It should not aggregate data at Parent Level rather it should also give the data which is getting calculated from BPC logic script.

Refer below screenshot for reference:

A-F are entities where if data is -ve then it goes to Y33014 and if it is +ve value goes to Y33015. In column Parent Entity the aggregated numbers are displayed but business users want that at Parent entity also the BPC logic script should check if value is -ve then it should show data in only Y33014. As per my understanding, Parent members cannot be included in scripts/member formulas. is there any alternate way to achieve this ?

Regards

Neha

[former_member186338]

Sorry, but unable to understand your requirement..

"BPC logic script should check if value is -ve then it should show data in only Y33014"

Script logic is about writing data, not about showing results in reports.

What do you mean by +/- ve???

Try to explain once again!

[former_member590808]

+Ve -> Positive data

-ve -> negative data

If data in GL Y33007 is positive copy the data in GL Y33015, if data in GL Y33007 is negative then copy data in GL Y33014. Same logic needs to be extended on Parent Entity column as well. If sum of A-F is positive then show data in Y33015, if sum is negative then show data in Y33014.

[former_member186338 · Accepted solution]

"ENDWHEN ACCUMULATION: 4 RECORDS ARE GENERATED. Member (C_BIPL) of dimension (APL_ENTITY) is not a base member (parent or formula)"

Clear!

You are trying to WRITE to parent member, for sure this is not possible!

You have to write to some base ENTITY member, may be you have to create one under the same parent!

*REC(EXPRESSION= %VALUE% < 0 ? 0: %VALUE%,APL_ACCOUNT1=Y33014,ENTITY=DUMMY_ENT)

P.S. I see that reading from parent is working fine!

[former_member590808 · Accepted solution]

Okay Vadim! Thanks for the clarification.

[former_member186338]

Starting from some not very resent SP BPC script logic supports parent nodes in WHEN/ENDWHEN.

*XDIM_MEMBERSET ENTITY=SOME_PARENT // PARENT values in the loop
*XDIM_MEMBERSET ACCOUNT=Y33007
*WHEN ACCOUNT
*IS *
*REC(EXPRESSION=%VALUE% > 0 ? %VALUE% : 0, ACCOUNT=Y33015
*REC(EXPRESSION=%VALUE% < 0 ? %VALUE% : 0, ACCOUNT=Y33014
*ENDWHEN

If you have very old BPC version then you have to create some dummy entity, aggregate base member entities in this dummy member, then same loop.

[former_member590808]

Tried with this. It gives warning on package execution. We are currently on AO 2.7 SP 3

BPC 11

[former_member186338]

nehayadav0911

"AO 2.7 SP 3" has no relation to your BPC version! Just a client version.

"BPC 11" - SP details???

"It gives warning on package execution" - sample with resulting log?

[former_member590808]

"ENDWHEN ACCUMULATION: 4 RECORDS ARE GENERATED. Member (C_BIPL) of dimension (APL_ENTITY) is not a base member (parent or formula)"

Above is the warning message which I get.

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET RPTCURRENCY = %RPTCURRENCY_SET%
*XDIM_MEMBERSET APL_TIME = %APL_TIME_SET%
*XDIM_MEMBERSET APL_ACCOUNT1 = 
*XDIM_MEMBERSET APL_ENTITY = %APL_ENTITY_SET%

*WHEN APL_ACCOUNT1
*IS BAS(Y33007)
*REC(EXPRESSION= %VALUE%, APL_ACCOUNT1 = Y33007_S)
*ENDWHEN


*WHEN APL_ACCOUNT1
*IS Y33007_S
*REC(EXPRESSION= %VALUE% < 0 ? 0: %VALUE%,APL_ACCOUNT1=Y33014)
*REC(EXPRESSION= %VALUE% > 0 ? 0: %VALUE%,APL_ACCOUNT1=Y33015)
*ENDWHEN