title: How do we know if aggregations on the SSAS cube are unused?
body: <p>Sql server version: 2016<br>
  Is there a way to know if aggregation on the cube is unused ? I have tried to get the information on the DMVs <strong>$system.discover_object_activity</strong> (gives me <strong>count</strong> of aggregations on a partitions/measure groups being hit or missed) and <strong>$system.discover_partition_stat</strong> (aggregation name and its processed state). I have read articles on SSAS specific DMVs and challenges in joining the DMVs to get combine data from DMVs to get useful information.  But I am not able to get information if a aggregation is left unused, like a list of aggregations which have been used/unused </p>
  
  <p>The cube which is being investigated has over 200 aggregations. It is cumbersome to manually go through each one of them and check for the combinations. Any help is appreciated.   </p>