* Select part of variable in BPC 10 NW

[former_member599409]

Hi Experts,

Please help in  getting correct syntax  for below requirement.  may be easy one but i am not getting it.

i have entity as below

( PARENTh)    1000ENT

memebrs               1000A

                             1000B

                             1000C

                      2000ENT

                           2000A  

                           2000B

                           2000C

now i want to read Bas of 1000ENT(example) and write it to 1000A, it should dynamically work.

Script  what i got so far.   if %ENTITY_SET% = 1000ENT , %TIME_SET% = 2014.MAR

*SELECT (%ENT%, "[ID]", ENTITY, "[ID] = '%ENTITY_SET%'")

// Selects Entity ID.  in this case 1000ENT

//How to make the selection of left 4 of %ENT% ????

*XDIM_MEMBERSET ENTITY = BAS(%ENTITY_SET%)

*WHEN TIME

*IS %TIME_SET%

*REC(EXPRESSION=%VALUE%, ENTITY = ????A  )

System details : BPC 10 NW - HANA

Thanks in advance

Pavan

[former_member186338 · Accepted solution]

Hi Pavan,

There is NO way to get a part of string in script logic. You have to use dedicated property.

Vadim

[former_member599409 · Accepted solution]

Thanks Vadim,

now, I have used one of existing property.