Thanks for the reply. I will take a look at the commands as you suggested. We can't just write MDX and actually depend on the Designer to allow our business users to build their own queries for Power Pivot. What's interesting is the data returned to the results pane is quick, it's building the filter part of the query which is painful. Even a member with 2 or 3 values like True/False from the Date Dimension will take a full minute to display the 2 or 3 options within the Expression area. Or, just dragging the member to the Filter pane will take almost a minute to show up. It almost seems like the Designer is getting hung up somewhere.