When using the Business Units, the option ‘Find unused fields’ was available. This was very handy and enables you to only load data that is used in the data warehouse layer(s).
This option disappeared since the introduction of the ODX Server. In the ODX Server (version 20.10.x) it is very cumbersome to only load columns that are used (luckily in V6XXX it is improved). That's why I most of the time select all columns in the tables in the ODX Server.
If the ‘find unused fields’ option is reintroduced that analyzes columns loaded in the ODX Server and columns that are mapped to the MDW, it makes it easy to identify what is used and what is not used.
This will only work efficiently if there is a way to automatically select/deselect columns in the ODX server based on the ‘find unused fields’ analysis.
