We have a couple of dimensions that we no longer use and have become obsolete, is there a way to hide or remove them?
This question has come a recently for a variety of reasons and there is new functionality to handle it. There are a number of scenario where it might be useful to hide a dimension or a measure.
A few of the scenarios we’ve heard about:
1. The information is no longer being updated or is no longer available – often seen due to an ERP change or process change.
2. Dimension or measure was added for a specific one time or short term analysis and is not longer used, but we may decide to populate it again at some point.
3. We have base Stratum or RI measures or dimensions that are included as part of the base model but we are not currently populating them.
4. We added dimensions or measures to make them available via Power BI or Excel but they are not needed in Stratum and they are just cluttering up the list of measures or dimensions in Stratum.
In Version 7 there are 2 Admin functions, one called Dimensions and the other called Measures that allow you to enable/disable a Dimension or Measure. If you disable a dimension or measure they will not show up in the drop downs or windows for users to select. These disabled dimensions and measures will continue to show in the Admin functions and they still exist and are populated in the Stratum cube.
Hope this helps – any questions or comments post ’em here.