Do you need all the measures?

Yes, I need to provide Line of Business in columns of the Pivot Grid.

In addition have you set the attribute relationships correctly on the Geography hierarchy? Yes, I believe they are correct.

There is no time selected in the MDX - is this correct?

Yes, the database is a snapshot in time for the customer. No history.

Have you set aggregations in the cube?

Yes.

Your example query made did help a little but I'm at 26 seconds and need to get down to 2 seconds.

I think one issue may be that my geo. dimension table is has the same number of rows as my fact table. (?)