Trim dimension member Id in script logic

[Former Member]

Hi,

I have two dimensions and each dimension has a unique prefix added to the member id's.

Dim 1 has members A_XXX

Dim 2 has members B_XXX

Now the requirement is i have to trim that A_ and B_ for those dimension members in the script logic.I need this because i have to search for the common dimension members from those dimensions DIM1 and DIM2 and do a manipulation based on them.

i am looking for MDX syntax

Regards

[Former Member]

Not exactly sure what manipulation and comparison you will be doing, but in the past when I have had two dimension members and need to compare trimmed ids in script I have just created a property for the trimmed portion in the dimension. So for example, property value would equal XXX for each of your members.

[SEdelstein]

Unfortunately there are no text manipulation commands in Script Logic. You can, however, create a custom function that will return the characters desired. Please see the documentation on crating a custom BADI at:

[http://help.sap.com/saphelp_bpc75_nw/helpdata/en/f0/4254a006574fed9a65f3661a07e3e7/content.htm|http://help.sap.com/saphelp_bpc75_nw/helpdata/en/f0/4254a006574fed9a65f3661a07e3e7/content.htm]

Regards,

Sheldon

[Former Member]

Thanks a ton!

well to that matter what if we replace the text with number.1_XXX, 2_XXX in dimension members? would that be possible?

is there any syntax to trim the values?

Help appreciated!

Regards

[Former Member]

Hi,

You can't trim the values by using Script logic

Thanks