MSBI -- SSAS -- Part-12

Aggregations:

                               In SQL Server Analysis Services (SSAS), each measure group by default has at least one partition. When a cube is created, this partition would not have any aggregation schemes defined, so these partitions are not optimized for performance. As you know, aggregations are pre-calculated sets of data which improve query response time and calculations during query evaluation.

Follow the below steps to create Perspectives:-

Step-1:-

Step-2:-

Step-3:-

Step-4:-

Step-5:-

Step-6:-

Step-7:-

Step-8:-

Step-9:-

Step-10:-