Oracle® Business Intelligence Server Administration Guide > Oracle BI Administration Tool Basics > Setting Preferences >

Using the Options Dialog Box—General Tab


Use the General tab of the Options dialog box to set general preferences for the Administration Tool.

To set general preferences

  1. In the Administration Tool, select Tools > Options.
  2. In the Options dialog box, select the General tab.
  3. Select the options you want.

    The following list contains the options that need additional explanation:

    Option
    Action When Selected

    Tile when resizing

    Automatically tiles the layer panes of the repository when you resize the Administration Tool. When this option is checked, the Cascade and Tile options are not available in the Windows menu of the Administration Tool.

    Display qualified names in diagrams

    Makes it easier to identify table sources.

    Display original names for alias in diagrams

    Makes it easier to identify the actual table referenced.

    Show Calculation Wizard introduction page

    Displays the Calculation Wizard introduction page. The introduction page also contains an option to suppress its display in the future.

    Use the Calculation Wizard to create new calculation columns that compare two existing columns and to create metrics in bulk (aggregated), including existing error trapping for NULL and divide by zero logic.

    You start the Calculation Wizard in the Business Model and Mapping layer by right-clicking any logical fact or dimension column of data type numeric, and then selecting the option Calculation Wizard.

    NOTE:  Time Series calculation is not allowed for a logical table not identified as a time dimension. For more information, refer to topics about time dimensions in Process of Creating and Administering Dimensions.

    Check out objects automatically

    (online mode only) Automatically checks out the object when you double-click it.

    NOTE:  If the option is not selected, you will be prompted to check out the object before you can edit it.

    Show row count in physical view

    Displays row counts for physical tables and columns in the Physical Layer. Row counts will not initially display until they are updated. To update the counts, select Tools > Update All Row Counts. You can also right-click on a table or column in the Physical Layer and select the option Update Row Count.

    Note: Row counts are not shown for items that are stored procedure calls (from the optional Object Type drop-down list in the General tab of the Physical Table dialog). Row counts are not available for XML, XML Server, or multidimensional databases. You cannot update row counts on any new objects until you check them in.

    Prompt when moving logical columns

    Allows you to ignore, specify an existing, or create a new logical table source for a moved column.

    Remove unused physical tables after Merge

    Executes a utility to clean the repository of unused physical objects. It might make the resulting repository smaller.

    Allow import from repository

    When checked, the Import from repository option on the File menu becomes available.

    NOTE:  By default, the Import from repository option on the File menu is disabled and this option will not be supported in the future. It is recommended that you create projects in the repository that contain the objects that you wish to import, and then use repository merge to bring the projects into your current repository. For more information, see About Extracting Metadata Subsets Into Projects.

Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.