I then started the SQL Profiler connected to the SSAS Server to watch what the system would do when I ran a query across vertical partitions, for instance analyzing sales across all years.