Name

The name of the machine hosting the Analytics Server or Cluster Controller.

Type

When Clusters is selected in the Explorer pane, this field is available. There are two types:

• Controller - The object is a Cluster Controller.
• Server - The object is a Analytics Server.

Role

The role of the object in the cluster:

• Controlling - A Cluster Controller that is currently assigned the responsibility for control of the cluster.
• Primary - The primary Cluster Controller. This role is not displayed if the primary Cluster Controller is currently the controlling Cluster Controller.
• Secondary - The secondary Cluster Controller. This role is not displayed if the secondary Cluster Controller is currently the controlling Cluster Controller.
• Clustered server - A Analytics Server that is a member of the cluster. This role is not displayed for the clustered server defined as the master server.
• Master - The clustered server that the Administration Tool connects to for editing repositories in online mode.

Status

The status of the object in the cluster:

• Online - The Cluster Controller or Analytics Server is online. For cluster controllers, this means the controller can accept session requests and assign them to available servers within the cluster. For clustered servers, this means that the server may be assigned sessions by the cluster controller.
• Quiesce - This status is applicable to clustered servers only. This means that any activity in progress on outstanding sessions will be allowed to complete before the server transitions to Offline status.
• Offline - The Cluster Controller or Analytics Server is offline. For Cluster Controllers, this means the controller cannot accept session requests or assign sessions to available servers within the cluster. For clustered servers, this means that the server is not communicating with the controlling Cluster Controller and cannot accept sessions assigned by the controlling Cluster Controller. If the server subsequently becomes available, it will be allowed to participate in the cluster. If you want to stop the Cluster Controller or clustered server after quiescing it, you need to issue the Stop command.
• Forced Offline - This status applies to clustered servers only. The Analytics Server has been stopped. This is identical to the offline status, except that if the Analytics Server comes back online, it will not be assigned requests. The server will remain in this state until the Start command is issued against this server from the Administration Tool Cluster Manager or both Cluster Controllers are shut down and restarted.

Start Time

The timestamp showing when the Cluster Controller or Analytics Server was last started. This field will be blank if the Cluster Controller or clustered server is offline.

Last Reported Time

The time the Cluster Controller or Analytics Server communicated with the Controlling Cluster Controller. If the server or controller is offline, this field may be blank.

Sessions

This field is available when either Servers or an individual server is selected in the Explorer pane. It shows the number of sessions currently logged on to a clustered server.

User

ID of the user who submitted the query that resulted in the cache entry.

Created

Time the cache entry's result set was created.

Last used

Last time the cache entry's result set satisfied a query. (After an unexpected shutdown of a Analytics Server, the Last used time may temporarily have a stale value, that is, older than the true value.)

Creation elapsed time

Time, in milliseconds, needed to create the result set for this cache entry.

Row count

Number of rows generated by the query.

Row size

Size of each row (in bytes) in this cache entry's result set.

Full size

Full size is the maximum size used, considering variable length columns, compression algorithm, and other factors. The actual size of the result set will be smaller than Full size.me, in seconds, needed to create the result set for this cache entry.

Column count

Number of columns in each row of this cache entry's result set.

Use count

Number of times this cache entry's result set has satisfied a query (since Analytics Server startup).

SQL

Text of the SQL that generated the cache entry.

Business Model

Name of the business model associated with the cache entry.

Session ID

Unique internal identifier that the Analytics Server assigns each session when the session is initiated.

User

Name of the user connected.

Client Type

Type of client session. The client type of Administration is reserved for the user logged in with the Siebel Business Analytics administrator user ID.

Catalog

Name of the Presentation layer catalog to which the session is connected.

Repository

Logical name of the repository to which the session is connected.

Logon Time

Timestamp when the session logged on to Analytics Server.

Last Active Time

Timestamp of the last activity on the session or the query.

Session ID

Unique internal identifier that Analytics Server assigns each session when the session is initiated.

Request ID

Unique internal identifier that Analytics Server assigns each query when the query is initiated.

Start Time

Time of the initial query request.

Last Active Time

Timestamp of the last activity on the session or the query.

Status

These are the possible values. Due to the speed at which some processes complete, you may not see all values for any given request or session.

• Idle—There is presently no activity on the request or session.
• Fetching—The request is being retrieved.
• Fetched—The request has been retrieved.
• Preparing—The request is being prepared for processing.
• Prepared—The request has been prepared for processing and is ready for execution.
• Executing—The request is currently running. To kill a request, select it and click the Kill Request button. The user will receive an informational message indicating that the Analytics Server administrator cancelled the request.
• Executed—The request has finished running.
• Succeeded—The request ran to completion successfully.
• Canceled—The request has been canceled.
• Failed—An error was encountered during the processing or running of the request.