One solution we came up with was to use SQL Server Reporting Services. Each report allows the generation of an MDX statement in the Report Dataset using a drag-and-drop Query Designer similar to the ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results