MSBI -- SSAS -- Part-11

Partitions:

                      By Default all the Measure Group data will be stored in a Single Physical Block.

Whenever user queries the data for a particular year, it needs to search all the years’ data and may get the data at particular year which may take time.

If we create partitions, the cube data will be split into multiple physical blocks.

So, whenever user queries the data for particular year, it will directly goes to respective physical block & get the data for user query.

Advantages:-

1.     It will decrease the Cube Processing time.

2.     And it will increase the cube performance.

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:

Step-11:

Step-12:

Step-13:

Step-14:

Step-15: