Skip to Content
0
Jan 21, 2019 at 03:37 AM

BPC Script Logic: how to check first two character of member in WHEN condition

284 Views Last edit Jan 21, 2019 at 03:38 AM 3 rev

Hello all,

I have a requirement as follows:

While Moving from one cube to another

Need to check if ENTITY member 'ID' starts from 'PC' (DATA) then move to 'A' dimension or start from 'CC' move to 'B' dimension.

E.g.

ENTITY.ID EQ (Start from PC)

move member 'PCS1234' into 'A' dimension

OR

ENTITY.ID EQ (Start from CC)

move member 'CCS1234' into 'B' dimension.

Please help to achieve this in 'WHEN' condition or other solution.

Thank you all.