Use metric set query hints
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.
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