Bookshelf Home | Contents | Index | PDF     

Siebel Business Analytics Server Administration Guide > Administration Tool Basics >

Administration Tool User Interface Components

This section includes a description of the following interface components:

Main Window in the Administration Tool

The main window of the Administration Tool is a graphical representation of the following three parts of a repository:

  • Physical layer. Represents the physical structure of the data sources to which the Analytics Server submits queries. This layer is displayed in the right pane of the Administration Tool.
  • Business Model and Mapping layer. Represents the logical structure of the information in the repository. The business models contain logical columns arranged in logical tables, logical joins, and dimensional hierarchy definitions. This layer also contains the mappings from the logical columns to the source data in the Physical layer. It is displayed in the middle pane of the Administration Tool.
  • Presentation layer. Represents the presentation structure of the repository. This layer allows you to present a view different from the Business Model and Mapping layer to users. It is displayed in the left pane of the Administration Tool.

Figure 1 shows the three layers of a repository, as described in the preceding list.

Figure 1. Example Administration Tool Main Window
Click for full size image

Menus in the Administration Tool

The Administration Tool includes the following menus:

File

The File menu contains options to work with repositories as well as several server-related options that are active when a repository is open in online mode. Before you open a repository, the File menu has fewer commands available.

Edit

The Edit menu options allow you to edit a repository and work with join conditions, security settings, and repository variables.

View

The View menu options toggle the view of specific metadata panes, give you access to the Join diagrams, and refresh the repository view.

Manage

The Manage menu allows you to access the management functions described in Table 5.

Table 5. Manage Menu Functions
Menu Option
Description

Jobs

This option is available when a repository is opened in online mode. The Job Manager is the management interface to Siebel Scheduler.

Sessions

This option is available when a repository is opened in online mode. In the Session Manager, you can monitor activity on the system, including the current values of repository and session variables.

Cache

This option is available when a repository is opened in online mode and caching is enabled. The Cache Manager allows you to monitor and manage the cache.

Clusters

This option is available when the Analytics Cluster Server feature is installed. The Cluster Manager monitors and manages the operations and activities of the cluster.

Security

The Security Manager displays security information for a repository and provides a central location for security configuration and management.

Joins

The Joins Manager allows you to work with physical and logical joins.

Variables

The Variables Manager allows you to create, edit or delete variables.

Projects

The Project Manager window allows you to create, edit, or remove projects or project elements. Project elements include presentation catalogs, logical fact tables, groups, users, variables, and initialization blocks. You use projects during multiuser development. For more information, see Setting Up an Analytics Multiuser Development Environment.

Marketing

Applies to Oracle's Siebel Marketing. You need a separate license to use this product.
Tools

The Tools menu options allow you to update all row counts, open the Query Repository dialog box, set options for the Administration Tool, and work with various utilities.

Window

The Window menu options allow you to cascade or tile open layer windows and toggle between them.

Help

The Help menu allows you to obtain the following information:

  • Help Topics. Access the online help system for the Administration Tool.
  • Siebel on Web. Access the Siebel Web site.
  • About Administration Tool. Obtain information about Oracle's Siebel Administration Tool.
  • About Analytics Server. Obtain information about the installed Analytics Server.

Toolbar in the Administration Tool

The toolbar provides access to functions that you use frequently.

To toggle the toolbar on and off

  • Select Tools > Options > Show Toolbar.

To dock the toolbar

  • Place your cursor on the double bars to the left of the toolbar, and then click and drag to where you want to place the toolbar.

Keyboard Shortcuts in the Administration Tool

Table 6 presents the keyboard shortcuts you can use in the Administration Tool to perform frequent tasks.

Table 6. Keyboard Shortcuts
Menu
Command
Shortcut

File

New

Open > Offline

Open > Online

Save

Print

Check Global Consistency

CTRL + N

CTRL + F

CTRL + L

CTRL + S

CTRL + P

CTRL + K

Edit

Cut

Copy

Paste

Delete

CTRL + X

CTRL + C

CTRL + V

DEL

View

Refresh

F5

Tools

Query Repository

CTRL + Q

Icons and Symbols in the Administration Tool

Table 7 presents the icons and symbols used in the Administration Tool with an explanation of what each represents.

Table 7. Icons and Symbols
Icon or Symbol
What It Represents

A database in the Physical layer and in the Logons tab of the User dialog box. Identifies a database for which you can specify a user ID and a password for the Analytics Server to use.

A connection pool in the Physical layer.

A collapsed catalog folder in the Physical layer; a collapsed business model in the Presentation and Business Model and Mapping layers; and a collapsed sources folder within the logical table.

An expanded catalog folder in the Physical layer; an expanded business model in the Presentation and Business Model and Mapping layers.

A collapsed schema folder in the Physical layer.

An expanded schema folder in the Physical layer.

A physical table in the Physical layer, and a logical table in the Presentation and Business Model and Mapping layers.

A physical cube table in the Physical layer.

A table registered as a Siebel event polling table.

A logical table source in the Business Model and Mapping layer.

An alias table.

An object that is a stored procedure call, as specified by the Object Type option in the General tab of the Physical Table dialog box.

An object that has a Select (view) object type.

A primary key for a physical or logical table (yellow).

A foreign key for a physical or logical table in the Joins Manager (gray).

A key for a logical dimension level (blue).

A key for a multidimensional data source physical level (green).

A physical or logical complex join in the Joins Manager.

A dimension in the Business Model and Mapping layer.

A hierarchy for a multidimensional data source in the Physical layer.

A level in the Business Model and Mapping layer.

A level in the Business Model and Mapping layer in which a level key contains one or more columns from another level.

A level for a multidimensional data source in the Physical layer.

A physical or logical column.

A logical column with an aggregation rule.

A derived logical column.

A physical cube column from a multidimensional data source. This icon represents columns that are not measures.

A physical cube column from a multidimensional data source. This icon represents columns that are measures.

An invalid item. For example, a column may be invalid, if it has no physical mapping.

A collapsed business model in the Business Model and Mapping layer that is not available for queries.

An expanded business model in the Business Model and Mapping layer that is not available for queries.

An item that contains an attribute definition.

Overlays other symbols to indicate a new item that has not been checked in (appears in online mode only). For example, this icon would appear on top of an alias table icon to indicate an alias table is new.

A system DSN ODBC entry. Appears in the Import dialog box.

A measure definition.

A user.

A security group.

An LDAP server.

A group.

All users.

Overlays other icons to indicate an object that is checked out. For example, this icon would appear on top of a table icon to indicate that the table has been checked out.

A static repository variable.

A dynamic repository variable.

A system session variable.

A nonsystem session variable.

An initialization block.

A group association (appears only in the results display of the Query Repository dialog box).

A level-to-level relationship (appears only in the results display of the Query Repository dialog box).

A type privilege (appears only in the results display of the Query Repository dialog box).

A query privilege (appears only in the results display of the Query Repository dialog box).

A privilege package (appears only in the results display of the Query Repository dialog box).

An object privilege (appears only in the results display of the Query Repository dialog box).

Overlays other icons to indicate an object that has been cut. Appears with other symbols, for example, to indicate that a cut item is an alias table.

Target levels (Marketing).

Qualified list items (Marketing).

List catalogs (Marketing).

Conforming dimension links (Marketing).

Qualifying Key for qualified list items (Marketing).

Sampling table factor (Marketing).

Segmentation catalog (Marketing).

Primary Segmentation catalog (Marketing).

Online Help in the Administration Tool

Most windows and dialog boxes have help buttons that open online help topics containing information to help you complete a task.

  
Siebel Business Analytics Server Administration Guide