Wednesday, June 28, 2023

SSAS Dimension Performance Report

Objective The objective of this report is monitor progressing time of all the dimensions as well as data retrieval time duration so that bottlenecks can be identified to improve the performance of SSAS Cube.

Layout


Business Logic

• This report shows dimension wise performance statistics having Duration and CPU utilization while browsing the data.

• This reports helps the users to take decision on adding or removing the attributes from the dimension in case some of the attributes are not required for business.

• It also helps in taking the decision for creating the hierarchies.

• Bases on this report, System will provide Advisory Report for creating hierarchies in dimension.


No comments:

Post a Comment