Hidden Dimensions Panel

Use the Hidden Dimensions panel to add members of hidden dimensions to a query. Hidden dimensions are dimensions that are related to the selected measures for a query, but are not shown in a view once the query is calculated. In other words, hidden dimensions are not shown in the Selected list of the Dimensions panel. These hidden dimensions are dimensions for the selected measures; therefore, they are included in the dimensions for the selected cube. Use the Items panel to view the selected measures.

The default selection for a hidden dimension is the top level of the default hierarchy.

The Hidden Dimensions panel appears in the:

Panel component

Hidden Dimensions box -- Displays a list of hidden dimensions for a query and specifies the members of the dimensions to use in the calculation of a query.