Use the General tab to select the following design options for the tables and the governors for the data model:
Auto Alias Tables—Enables the product to replace underscores with spaces and display item names in mixed upper/lower case when a table is added to the Content frame from the Table catalog.
Auto Join Tables—Instructs the product to automatically join database tables based on one of three different join strategies as they are added to the Content frame if their names and data types are identical. If Auto Join Tables is not selected, you must manually create joins between topics in the Content frame.
Show Icon Joins—Shows topic joins when a topic is in icon view (minimized). It is recommended that you activate this feature.
Allow Drill Anywhere—Activates the drill anywhere menu item on the menus within the Pivot and Chart sections. This option enables users to drill to any field.
Allow Drill To Detail—Activates the drill to detail menu item on the menus within the Pivot and Chart sections. This option enables users to query the database again once they have reached the lowest level of detail; it only works if the Allow Drill Anywhere option is selected.
Note: | If you want to use certain drilling options, they must be predefined in the data model itself. The ability to use pre-defined drill paths, drill-to-detail and incremental drilling all depend on the data model used by the query. They are not controlled in the individual chart or pivot. The ability to turn off drilling altogether is also found in the data model definition. |
Governors (Interactive Reporting Studio Only)
Return First ____ Rows—Specifies a cap on the number of rows retrieved by a query against the data model, regardless of the size of the potential Results set.
Time Limit ____ Minutes—Specifies a cap on the total processing time of a query against the data model. Seconds are entered as a decimal number. Available for asynchronous connection API software (for example, Open Client) that support this feature.