Set Metric Set Query Hints


1. Overview

This article shows you how to set the Advanced (Query Hints) of the Metric Set.

2. Set Advanced Settings

Ensure that the Metric Set is checked out.

Open the Data Analysis Panel for the table, and then click Edit.

Look for the Advanced (Query Hints) section and click the triangle to expand the Advanced settings. Only settings that are relevant to the current metric set will be displayed.

Edit Metric set
Edit Metric set

Make any changes needed

Expand Advanced Query
Expand Advanced Query

2.1. Available Settings

Prefer NON-EMPTY - For OLAP - when checked uses "NON EMPTY"  instead of "Nonempty()" when generating MDX queries.

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