Hiding tables and columns

Some tables are available in the data model simply in a support capacity, and would never be used in a report. For example, you may have a table to support many-to-many relationships, weighted allocation, or even dynamic security. Likewise, some columns are necessary for creating relationships in the data model but would not add any value when added to a report. Tables or columns that will not be used for reporting purposes should be hidden from the report view to reduce complexity and improve the user experience. 

To hide a column or table, simply right-click on the object you wish to hide, and then select Hide in report view. If you are in the report view already, the available option will simply say Hide.

Navigate to the relationship view, find the FactInternetSales table, and right-click on ProductKey, then select Hide in report view:

Columns that are hidden are still visible in the data and relationship views, but they have slightly lighter text than columns that are not hidden, as you can see in Figure 20:

Next, go to each table and hide all remaining key columns, except for FullDateAlternateKey.