Set Metric Set Query Hints
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.
Make any changes needed
2.1. Available Settings
Prefer NON-EMPTY - For OLAP - when checked uses "NON EMPTY" instead of "Nonempty()" when generating MDX queries.