cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor

I am not an expert in SAP MS, but from my experience in BPC NW I can reconmmend:

Create a new property and fill it for members starting with PC or CC

Then use property in WHEN condition.

There is no way to analyze member string.

0 Kudos

Hello Vadim,

Understand your approach 🙂 , seems this the only solution for Script or can implement Badi and handle this case.

Thanks for the solution

former_member186338
Active Contributor
0 Kudos

abhay5050

Badi in BPC MS????

Answers (1)

Answers (1)

muttepawar-2009
Active Participant
0 Kudos

HI

Script Logic using when Condition

in the above link , explains BPC SCRIPT LOGIC USING WHEN CONDITION.

Regards

Prashant

0 Kudos

Hello Prashant,

Seems above solution is not suitable for this requirement.

Thanks for the reply.