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