script : whats wrong

[Former Member]

Hi experts,

The case :

User selects entitydim

default should calculate the sum of all base level entitydim depending of the selection, and corresponding to a certain criteria :

*XDIM_MEMBERSET ENTITY=BAS(%ENTITY_SET%),VIEW_MAG 
*when entity.ent_typ
*is magasin
*rec(expression=(get(entity="BAS(%ENTITY_SET%)"),entity="view_mag")
*endwhen
*commit

I receive from the debugger :

(M_LAD is a parent)

Tks a lot,

[Former Member]

Hi Olivia,

our experience with BAS() is that it doesn't work in BPC for Microsoft.

We resolved similar issues using SELECT clause assigned to a variable like this:

*SELECT(%MY_VAR%, MY_DIM_PROP, MY_DIM,"[PARENTH1] IN (%LIST_OF_PARENTS%)")

*XDIM_MEMBERSET MY_DIM =  %MY_VAR%

Hope this helps.

Kindest regards,

Santiago