Use the Session Manager

The Session Manager contains an upper pane and a lower pane:

• The top pane, the Session pane, shows users currently logged in to the BI Server. To control the update speed, from the Update Speed list, select Normal, High, or Low. Select Pause to keep the display from being refreshed.

• The bottom pane contains two tabs:

  • The Request tab shows active query requests for the user selected in the Session pane.

  • The Variables tab shows variables and their values for a selected session. You can click the column headers to sort the data.

The tables describe the columns in the Session Manager dialog.

Column Name	Description
Client Type	The type of client connected to the server.
Last Active Time	The time stamp of the last activity on the session.
Logon Time	The time stamp that shows when the session initially connected to the BI Server.
Repository	The logical name of the semantic model to which the session is connected.
Session ID	The unique internal identifier that the BI Server assigns each session when the session is initiated.
User	The name of the user connected.

Column Name	Description
Last Active Time	The time stamp of the last activity on the query.
Request ID	The unique internal identifier that the BI Server assigns each query when the query is initiated.
Session ID	The unique internal identifier that the BI Server assigns each session when the session is initiated.
Start Time	The time of the individual query request.

1. In the Model Administration Tool, open a semantic model in online mode and select Manage then Sessions.

2. Select a session and click the Variables tab.

3. To refresh the view, click Refresh.

4. To close Session Manager, click Close.

Follow these steps to disconnect a user from a session.

1. In the Model Administration Tool, open a semantic model in online mode and select Manage then Sessions.

2. Select the user in the Session Manager top pane.

3. Click Disconnect.

   The user session receives a message that indicates that the session was terminated by an administrative user. Any currently running queries are immediately terminated, and any outstanding queries to underlying databases are canceled.

4. To close the Session Manager, click Close.

Follow these steps to terminate an active query.

1. In the Model Administration Tool, open a semantic model in online mode and select Manage then Sessions.
2. Select the user session that initiated the query in the top pane of the Session Manager.

   After the user is highlighted, any active query requests from that user are displayed in the bottom pane.

3. Select the request that you want to terminate.
4. Click Kill Request to terminate the selected request.

   The user receives a message indicating that the query was terminated by an administrative user. The query is immediately terminated, and any outstanding queries to underlying databases are canceled.

   Repeat this process to terminate any other requests.

5. To close the Session Manager, click Close.