Wednesday, June 28, 2023

SSAS Partition wise Processing Report

SSAS Cube gets data and do pre aggregation from OLTP systems when we process the cube. We can divide the cube in various partition so that cube can be process in smaller partitions in place of one bigger cube. Partitioning the cube also help in retrieving the data faster. Sometimes processing of SSAS Cube takes lot of time to complete the processing. So it is required to troubleshoot the processing query which increases the processing performance. Below is the report layout and business logic to develop Partition wise cube processing report.

Layout



Business Logic

• This report shows total processing time taken by partitions in the cube.

• This report helps the users to understand the which partition(s) are bulky in nature.

• Bases on this report, System will provide Advisory Report for creating partitions in the report.


No comments:

Post a Comment