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 depending on the data connector it uses.

2. Using query hints

To find and use query hints in your metric set, first ensure that the metric set is checked out to you.

Find or open the Data Analysis Panel, and click the metric set name or Edit icon to edit its settings.

Edit metric set
Edit metric set

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

Expand query hints
Expand query hints

Depending on what data connector provides the data for this metric set, options may appear as described in the following sections. Query hints may not be available when combining data from multiple data connectors.

3. Prefer NON-EMPTY

When the data comes from an OLAP database, you can set a preference for using NON EMPTY instead of the default Nonempty() when generating MDX queries.

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

Select Prefer NON-EMPTY
Select Prefer NON-EMPTY

4. Read uncommitted

When data comes from Microsoft SQL Server or IBM Db2, you can use a 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.

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

For SQL Server, select the Read Uncommitted query hint to enable this option.

Select Read Uncommitted
Select Read Uncommitted

For IBM Db2, select Append WITH UR To SELECT Queries (in Dundas BI 8.0.2 or later).

Select WITH UR query hint
Select WITH UR query hint

5. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

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