Use Metric Set Query Hints

Contents[Hide]

1. Overview

The Advanced (Query Hints) section of the Configure The Metric Set Binding panel provides advanced settings that are relevant to the current metric set. For example, when working with OLAP, you can set a preference to 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 Configure The Metric Set Binding panel, 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