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.