Set Administration Tool Options

Use these steps to set Model Administration Tool preferences and options.

1. In the Model Administration Tool, select Tools, then select Options.
2. In the Options dialog, on the General tab, select the options to use.
3. On the Repository tab, select Show tables and dimensions only under display folders or Hide level based measure.
4. On the Sort Objects tab, specify which repository objects appear in the Model Administration Tool in alphabetical order.
5. On the Source Control tab, create or edit a configuration file to integrate with a source control management system, or change the status of an MDS XML repository.
6. On the Cache Manager tab, select the columns you want to display in the Cache Manager.
7. Select an item to change the order of columns in the Cache Manager, then use the Up and Down buttons to change its position.
8. On the Multiuser tab, specify the path to the multiuser development directory and the name of the local developer for this Model Administration Tool.
9. On the More tab, you can set the scrolling speed for Model Administration Tool dialogs. To set the scrolling speed, position the cursor on the slider.
10. Click OK when you're finished setting preferences.

Administration Tool General Options

The table describes some of the Model Administration Tool options available in the Options dialog on the General tab.

Option	Action When Selected
Display qualified names in diagrams	Displays fully qualified names in the Physical Diagram and Business Model Diagram. For example, selecting this option displays "B - Sample Fcst Data"..."B02 Market" rather than B02 Market in the Physical Diagram. Selecting this option can help identify objects by including the name of the parent database or business model, but it can also make the diagram harder to read because the fully qualified names are longer. If you choose not to select this option, you can still see fully qualified names by moving the cursor over an object in the diagram, or by selecting an object in the diagram and then viewing the text in the status bar.
Display original names for alias in diagrams	Displays the names of original physical tables rather than the names of alias tables in the Physical diagram. Select this option when you want to identify the original table rather than the alias table name.
Show 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. See Use the Calculation Wizard.
Check out objects automatically	Automatically checks out an object when you double-click it. If you don't select this option, you're prompted to check out objects before you can edit them. This option only applies when the Model Administration Tool is open in online mode. See Edit Repositories in Online Mode.
Show row count in physical view	Displays row counts for physical tables and columns in the Physical layer. Row counts aren't initially displayed until they're updated. Row counts aren't shown for items that are stored procedure calls from the Table Type list in the General tab of the Physical Table dialog. Row counts aren't available for XML, XML Server, or multidimensional data sources. When you're working in online mode, you can't update row counts on any new objects until you check them in.
Prompt when moving logical columns	Lets you ignore, specify an existing, or create a new logical table source for a moved column.
Remove unused physical tables after Merge	Runs a utility to clean the repository of unused physical objects. It might make the resulting repository smaller.
Allow import from repository	When selected, the Import from Repository option on the File menu becomes available. By default, the Import from Repository option on the File menu is disabled. It's recommended that you create projects in the repository that contain the objects that you want to import, and then use repository merge to bring the projects into your current repository. See Merge Repositories.
Allow logical foreign key join creation	When selected, provides the capability to create logical foreign key joins with the Joins Manager. This option is provided for compatibility with previous releases and is generally not recommended.
Skip Gen 1 levels in Essbase drag and drop actions	When selected, excludes Gen 1 levels when you drag and drop Essbase cubes or dimensions from the Physical layer to the Business Model and Mapping layer. See Work with Essbase Data Sources.
Hide unusable logical table sources in Replace wizard	By default, the Replace Wizard shows all logical table sources, even ones that aren't valid for replacement. When this option is selected, unusable logical table sources are hidden in the Replace Wizard screens. Click Info for details on why a logical table source that maps to that column doesn't appear in the list. Selecting this option might result in the Wizard page loading more quickly, especially for large repositories.
Allow first Connection Pool for Init Blocks	Selecting this option isn't a best practice and might cause performance issues. By default, when you select a connection pool for an initialization block, the first connection pool under the database object in the Physical layer doesn't display as available for selection. This behavior ensures that you can't use the same connection pool for initialization blocks that you use for queries. If the same connection pool is used for initialization blocks and for queries, then queries might be blocked whenever initialization blocks run. Alternatively, initialization blocks used for authentication might be blocked by long-running queries, causing delayed or suspended logins. Select this option to change the default behavior and allow the first connection pool to be selected for initialization blocks. See About Connection Pools for Initialization Blocks.
Show Upgrade ID in Query Repository	Upgrade IDs aren't displayed by default in the Query Repository dialog. When this option is selected, Upgrade IDs are displayed as a column in the Query Repository results. In addition, you can set a filter on Upgrade ID to search for a particular value. This option is useful for MDS XML format repositories in which the Upgrade ID is included in the file name.
Extender For BIAPPS	The availability of this option depends on your configuration.
Show Tenant Info in Online Login	If you're working in a multi-tenant environment, then select this option to show the Tenant info field in the Open Online dialog.
Display Translation Key in the presentation tree	Select this option to instead display the translation key values for all presentation objects.
Edit presentation names	By default, the presentation object names are read-only. Select this option to allow the names of presentation objects to be modified.
Drag and drop: Show only hierarchal columns	For Essbase data sources, selecting this option hides presentation columns and shows only hierarchal columns in Answers.

Administration Tool Repository Options

You can set preferences for the repository in the Model Administration Tool.

Repository tab options include the following:

• Show tables and dimensions only under display folders

  You can create display folders to organize objects in the Physical and Business Model and Mapping layers. They have no metadata meaning. After you create a display folder, the selected objects appear in the folder as a shortcut and in the database or business model tree as an object. You can hide the objects so that only the shortcuts appear in the display folder.

  See Set Up Display Folders in the Physical Layer and Set Up Display Folders in the Business Model and Mapping Layer.

• Hide level based measure

  By default, each level of a dimension hierarchy in the Business Model and Mapping layer shows both dimension columns that are assigned to that level, and level-based measures that have been fixed at that level. Level-based measures are objects that aren't part of the dimension table, but that have been explicitly defined as being at a particular level.

  Hiding level-based measures in dimension hierarchies can reduce clutter. The measures are still visible in the logical fact tables.

  See Level-Based Measure Calculations.

• System logging level

  This option determines the default query logging level for the internal BISystem user. The BISystem user owns the Oracle BI Server system processes and isn't exposed in any user interface.

  A query logging level of 0 (the default) means no logging. Set this logging level to 2 to enable query logging for internal system processes like event polling and initialization blocks.

  See Managing the Query Log in Administering Oracle Analytics Server.

• LDAP

  If you're using any alternative LDAP servers, the Oracle BI Server maintains an authentication cache in memory for user identifiers and properties to improve performance when using LDAP to authenticate large numbers of users. Disabling the authentication cache can slow performance when authenticating hundreds of session. The authentication cache isn't used for Oracle WebLogic Server's embedded directory server.

  Properties for the authentication cache include:

  • Cache refresh interval

    The interval at which the authentication cache entry for a logged on user is refreshed.

  • Number of Cache Entries option (authentication cache) and Number of Cache Entries

    The maximum number of entries in the authentication cache, pre-allocated when the Oracle BI Server starts. If the number of users exceeds this limit, cache entries are replaced using the LRU algorithm. If this value is 0, then the authentication cache is disabled.

  You need to specify some additional LDAP properties when you're using a secure connection to your LDAP server. In other words, provide the following information when you've selected SSL on the Advanced tab of the LDAP Server dialog:

  • Wallet directory

    The location of the Oracle wallet that holds the client certificate and Certificate Authority (CA) certificate.

  • Password and Confirm password

    The password for the Oracle wallet.

  The authentication cache properties and Oracle wallet properties are shared for all defined LDAP server objects.

See Set Administration Tool Options.