Logic Script SELECT function does not work

[#1]

Hi Experts,

I define a group of variables like below:

*SELECT(%ENTITY%, "ID", "P_ENTITY", "[Z_OWNER] = Y")

*SELECT(%ENTITY1%, "ID", "P_ENTITY", "[ID] = BAS(%P_ENTITY_SET%) AND [MAPPING] <> %ENTITY%")

then I define Data region for dimension P_ENTITY like below:

*XDIM_MEMBERSET P_ENTITY = %ENTITY1%

However when I run this script with the package, it always failed with error:

RUN_LOGIC:No value assigned to dimension "P_ENTITY"

It should has some certain entities that can be returned with the varialbles I made above.

Does there anything not make sense in my variable definition?

Please help to check and give me some experitse. thanks~

[former_member186338]

Nikhil code is correct!

The reason is simple - you can't use BAS operator inside select! You have to use temporary variable:

*XDIM_MEMBERSET P_ENTITY AS %ENTITY2% = BAS(%P_ENTITY_SET%)

to get a list of base members

[former_member772554]

Yeah, it is going well now, thanks for the comments