Use metric set query hints

Contents[Hide]

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.

2. Prefer NON-EMPTY

When working with OLAP, you can set a preference for using NON EMPTY instead of the default Nonempty() when generating MDX queries.

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. Read uncommitted

Note
Ensure that you are aware of the features and limitations of the Read uncommitted isolation level before attempting to use it.

If all tables in a metric set are from SQL Server, you can use the Read Uncommitted query hint to specify that statements can read rows that have been modified by other transactions but not yet committed. This option enables dirty reads.

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.

Select Read Uncommitted
Select Read Uncommitted

Select Read Uncommitted and click Submit.

4. 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:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri