UnHide (Method)

Applies To:

OLAPMeasure object

Description:

Retrieves hidden measure items from the selected row or column to the OLAPQuery section.

Syntax:

Expression.UnHide()

Expression Required:

An expression that shows a hidden OLAPMeasure object

Example 1:

This example shows how to hide the fact Amount Sales.

ActiveDocument.Sections["Chart"].Facts["Amount Sales"].Hide()

Example 2:

This example shows how to hide the OLAP measure Sales Average:

ActiveDocument.Sections["OLAPQuery"].Measures["Sales Average"].UnHide()