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.

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

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.

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.

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

5. See also

Metric set analysis tools
Connect to OLAP data and apply a formula
Microsoft Docs: SET TRANSACTION ISOLATION LEVEL
IBM Documentation: Isolation levels