Siebel Analytics Server Administration Guide > Administration Tool Basics >
User Interface Components
This section includes a description of the following topics:
Main Window
The main window of the Administration Tool provides a graphical representation of the three parts of a repository, each of which is described briefly in this section.
- Physical layer. Represents the physical structure of the data sources to which the Siebel 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. It shows the business models, which 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 10 shows the three layers of a repository, as described in the preceding discussion.
Figure 10. Example Administration Tool Main Window

|
Menus
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
|
Job Manager
|
This option is available when a repository is opened in online mode. It opens the Job Manager window, which is the management interface to Siebel Analytics Scheduler.
|
Session Manager
|
This option is available when a repository is opened in online mode. It opens the Session Manager, which you can use to monitor activity on the system.
|
Cache Manager
|
This option is available when a repository is opened in online mode and caching is enabled. It opens the Cache Manager window, which allows you to monitor the cache.
|
Cluster Manager
|
This option is available when the Siebel Analytics Cluster Server feature is installed. It opens the Cluster Manager window, which you can use to monitor and manage the operations and activities of the cluster.
|
Security Manager
|
This option opens the Security Manager, which displays security information for a repository and provides a central location for security configuration and management.
|
Joins Manager
|
This option opens the Joins Manager, where you can work with physical and logical joins.
|
Variables Manager
|
This option opens the Variables Manager window, which you can use to create, edit or delete variables.
|
Tools
The Tools menu options allow you to set options for the Administration Tool, access the Time Series Wizard, and work with various management functions.
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 access the online help system for the Administration Tool.
Toolbar
The toolbar provides access to functions that you use frequently.
To toggle the toolbar on and off
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
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
|
CTRL + N
CTRL + F
CTRL + L
CTRL + S
CTRL + P
|
Edit
|
Cut
Copy
Paste
Delete
|
CTRL + X
CTRL + C
CTRL + V
DELETE
|
View
|
Refresh
|
F5
|
Tools
|
Query Repository
|
CTRL + Q
|
Icons and Symbols
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 Siebel Analytics Server to use.
|
|
A database that does not have a connection pool or a database for which all its connection pools have the option Shared Logon selected on the General tab of the Connection Pool dialog box. Identifies a database for which you cannot specify a user ID and password.
|
|
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 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 key for a physical or logical table.
|
|
A foreign key for a physical or logical table in the Joins Manager.
|
|
A physical or logical complex join in the Joins Manager.
|
|
A dimension in the business model and mapping layer.
|
|
A level in the business model and mapping layer.
|
|
A physical or logical column.
|
|
A logical column with an aggregation rule.
|
|
A derived logical column.
|
|
An invalid item.
|
|
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.
|
|
A new item (appears in online mode only). Can appear with other symbols, for example, to indicate a new item is an alias table.
|
|
A system DSN ODBC entry. Appears in the Import dialog box.
|
|
A measure definition.
|
|
A user.
|
|
A security group.
|
|
An LDAP server.
|
|
A group hierarchy.
|
|
All users.
|
|
An object that is 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).
|
|
An object that has been cut. Can appear with other symbols, for example, to indicate that a cut item is an alias table.
|