Use the Topic Priority tab to define the order that tables are included in the Interactive Reporting SQL statement. Defining a topic priority can significantly speed up large queries.
When defining topic priorities, remember that the centralized fact topic in your data model is the largest and receives the most use during a query. By prioritizing this topic first, followed by the remaining topics in descending order of magnitude, the database server can more efficiently use the internal join logic between tables.
To set topic priorities in a data model:
Topics in the data model appear listed in the Tables list in the order they were placed in the Content pane.
Rank the topics in the desired order. Click the arrow to move selected topics up or down in the list.
Click Auto-Order to automatically detect the magnitude of each topic and rank them accordingly in descending order.
When the topics appear in the desired order, click OK.
To save the current topic priority order as the default, select Save as Default before clicking OK.
Explorer Users: The Topic Priority dialog box appears only if you select a join in the data model.
Since most data models do not have the same set of topics, you cannot save changes to the topic priority as default user preferences. (For more information on default user preferences, see Saving Data Model Options as User Preferences.)