Hiding tables and columns

Applies to version 11.0.4 and subsequent versions unless specifically overridden

You can hide a table or column in a data module. The hidden tables or columns remain visible in the modeling interface, but they are not visible in the reporting and dashboarding interfaces. The hidden items are fully functional in the product.

About this task

Use this feature to provide an uncluttered view of metadata for the report and dashboard users. For example, when you hide columns that are referenced in a calculation, the metadata tree in the reporting and dashboarding interfaces shows only the calculation column, but not the referenced columns. When you hide the identifier columns used as keys for joins, the keys are not exposed in the dashboarding and reporting interfaces, but the joins are functional in all interfaces.

Procedure

  1. In the data module tree, click the context menu icon for a table or column, and click Hide.

    You can also select multiple tables or columns to hide them at once.

    Tip: To un-hide the items, click the context menu icon for the hidden table or column, and click Show.
  2. Save the data module.

Results

The labels on the hidden tables and columns are grayed out in the data module tree and in the diagram. Also, on the General tab of the table or column properties, the check box This item is hidden from users is selected.

The hidden tables and columns are not visible in the reporting and dashboarding interfaces.