Hi team,
Something for consideration on the Cube and Dimension Lists under Model Spotlight.
A column that counts the number of views on a cube or subsets in a dimension.
Large numbers of views and subsets impacts performance especially now with more users working remotely over vpn. This would be a good check to see where to clean up these objects or adjust TI’s.
This will be really helpful. Especially if the subsets can be split between dynamic | static | control/hidden | public/private subsets AND the views between native | MDX | control/hidden | public/private views. This will enable the Administrator to be informed of the different subsets and views that has been created over time (that might be redundant or can be standardized in the future) that is adding to performance degradation.