Does anyone know of a way to "extract" the formulas for all calculated members of a cube into some kind of flat, readable file? Alternatively, a less-painful method of getting an overview of the code than using Analysis Services' Cube Editor and clicking on each Calculated Member would be helpful. Yes, I'm new to MDX. Many thanks!
This is what "Registered User" was referring to - but it won't answer your question if I'm understanding it correctly.
olappivottableextend.codeplex.com/
Fortunately, if I understand your question correctly, there is a very simple solution. When you are using BIDS against your cube, on the "Calculated Members" tab, click on the 12th icon from the left which is "Script View" - I think this is what you are looking for.
ssas-info.com/images/fbfiles/images/calc_tab.jpg
Credit to ssas-info for the image (can't embed or post links because of my "reputation" - doesn't make sense, but ok).