BIDS Helper

Column Usage Reports

Right-clicking on the DSV lets you open two reports about column usage:


Unused Columns Report
This report lists all columns in the DSV which are not used in dimensions, cubes, or mining structures. Download a sample. Double-checking columns on this report is a quick way to identify whether you accidentally missed any columns when designing the cube. Keep in mind, though, the general best practice is only to add columns to the cube that are needed for analysis.

Used Columns Report
This report lists all columns in the DSV which are used in dimensions, cubes, or mining structures. Download a sample. This report can be used for proofreading the setup of your cube or for documentation.