I want to know whether we can run a while loop in MDX. My scenario is that I have a result set in MDX (Like I would have in SQL). There in my dataset I have 4 columns. Now I need to create a 5th column using the values of the other 4 columns. I did
that in SQL using a while loop and using Update statements. Is there a way to do the same in Mdx as well ?
Please guide me on the same.
View Complete Post