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:

Figure 19-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:

Figure 20-Hidden Columns

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

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.144.82.21