* Select part of variable in BPC 10 NW
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
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%)
*REC(EXPRESSION=%VALUE%, ENTITY = ????A )
System details : BPC 10 NW - HANA
Thanks in advance