Use metric set query hints


1. Overview

The Advanced (Query Hints) section of the metric set's settings dialog provides advanced settings that are relevant to the current metric set. For example, when working with OLAP, you can set a preference for using NON EMPTY instead of the default Nonempty() when generating MDX queries.

2. Prefer NON-EMPTY

Ensure that the metric set is checked out.

Open the Data Analysis Panel and click Edit.

In the dialog that appears, expand the Advanced (Query Hints) section.

Edit Metric set
Edit Metric set

Select Prefer NON-EMPTY to use NON EMPTY instead of Nonempty() when generating MDX queries (OLAP only).

Select Prefer NON-EMPTY
Select Prefer NON-EMPTY

3. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri