Good question Devendra, not done much with MDX so learnt something new, thank you.

You have removed all reference to data and that seems to have stopped any advice. Depending on your PMS system you should find that there are objects; maybe a separate database,...

Looking at the detail you have posted it is clear that this is a law firm, and I should think that the data you are looking for is already...

Good question many thanks!

Alternatively you may consider  the use of a string splitter, excellently demonstrated by Jeff Moden in his String Splitter article.
NB I have to agree with Thom on the choice...

Good question, thanks Steve.

Good question thanks Steve,

Good question thanks Steve.

Another chance to learn more of R thanks Steve.

Good question on which to start the week thanks Steve.