Skip to Content
Former Member
May 19, 2010 at 03:08 PM

Trim dimension member Id in script logic



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 😊