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

Trim dimension member Id in script logic

25 Views

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