This is a tall order and not sure if it could be easily done. Our sales database has a significant amount of dimensions and the build times are getting longer. My objective is to streamline the database design. Is there a way to identify which dimensions are being used on the database in Phocas?
We will want to adjust some of the dimensions to properties to reduce build time, but if we remove at the moment there is a danger that certain dashboard widgets or favourites will no longer work. Is there a way to see where each dimension is being used? Ideally in the designer or alternatively in a data dictionary so developers can monitor usage.
I see a dimension called “Sub group” (out of the 15 dimensions on Customer), how do I know it is in use anywhere?