Modify a Database's Supported Query Features

You can view and modify how the database's supported query features are set. The data source determines how the default query feature values are set.

In most cases, you should keep the default selections and values. If you enable or change query features that the data source doesn't support, your query may return errors and unexpected results. If you disable supported SQL features, the server could issue less efficient SQL to the data source. Before you change any of the defaults, confirm that the query feature is supported by the data source. For more information, see What Are Supported Query Features?

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer icon and locate and double-click a database.
  4. In the database's tab, click Advanced.
  5. Go to the Supported Query Features section of the Features table and modify the database's query features as needed.
  6. Click Save.