Page Comparison

{scrollbar}

----
O3 Server administration activities include:
* Changing server status
* Shutting down the server
* Sending messages to users
* Seeing information about open cubes and closing them
* Enabling the enforcement of rules
* Seeing information about connected clients and disconnecting them
* Activating O3 Server monitoring
* Seeing statistic information about published cubes
* Importing and exporting O3 Server elements

h2. Changing O3 Server Status

You may see and modify the Server status from the Administration Tree. Change of status is necessary when a range of administrative tasks are performed, such as creation of users, roles, etc.

In order to see or change status:
# Start *{_}O3 Server Administrator{_}*
# Expand the Services branch in the Administration Tree
# Click on the Cubes node, in the Services branch. Server status is displayed in the Properties Pane
# To modify Server status, click on the Status drop-down list
# Select one status from the list
# Press the Apply button. Server status will be updated
!O3ServerAdministrator-CubeServiceStatus.png|vspace=10,hspace=10!

h3. Available O3 Server Statuses

Possible O3 Server statuses are described in the following table
|| _Status_ || _Description_ ||
| Down | O3 Server is shut down and does not admit additional connections |
| Interrupted | Services for connected users are interrupted. All access processes currently taking place are interrupted |
| Admin | It is the status for administrative tasks, such as registering new cubes, or changing users' roles |
| Running | It is the standard running status. All services and authorized connections are available |

h2. Shutting Down O3 Server

It is possible to switch off O3 Server from\*_O3 Server Administrator_\* using the Shut Down Server command. Execution of this command means notifying connected users, blocking new connections and shutting down O3 Server after the wait time indicated when executing the command.

To shut down O3 Server:
# Start *{_}O3 Server Administrator{_}*.
# Select the File \| Shut Down Server command in the Administration Tree.
# Enter the wait time for shutdown. A message is sent to all connected users.
# O3 Server will shut down once the wait time has expired.

h2. Sending Messages to Users

You may send messages to connected users through *{_}O3 Server Administrator{_}* using the Send Message Command

To send messages to users:
# Start *{_}O3 Server Administrator{_}*
# Select the File \| Send Message command . The "Send Message" dialog box pops up
# Type the text of the message you want to send.
# Press the Send button. A box with the message will pop up on connected users' screens
!O3ServerAdministrator-SendMessage.png|vspace=10,hspace=10!
!O3ServerAdministrator-SendMessage-Client.png|vspace=10,hspace=10!

h2. Seeing Information about Open Cubes and Closing Them

From the Administration Tree you may see information about the server's current activity. This information includes the cubes which are open and the users currently consulting each of them.

To see open cubes and close them:
# Start *{_}O3 Server Administrator{_}*
# Expand the Services \| Cubes \| Open Cubes branch in the Administration Tree
# Update the list of cubes running, by means of the right button of the mouse
# Expand the branch of the cube you are looking at. Information about the open cube will be displayed in the properties pane in two tabs: Cube and Runtime
# To close the cube, right-click on the cube and select the Remove option
!O3ServerAdministrator-RunningCubes.png|vspace=10,hspace=10!
!O3ServerAdministrator-RunningCubes-Runtime.png|vspace=10,hspace=10!

Closing a cube means shutting down all users' connections to the cube and sending a message to them. Users will remain connected to other open cubes. The cube will remain published, and a future connection attempt will be successful. To prevent further connection to the cube it is necessary to disable its publication.

In order to see users opening cubes or to shut down the connection:
# Start *{_}O3 Server Administrator{_}*
# Expand the Services \| Cubes \| Open Cubes branch in the Administration Tree
# Update the list of running cubes by means of the right button of the mouse
# Expand the branch of the cube you are looking at. A list of connected users will pop up
# In order to show users' information, click on the Users branch
# To shut down the user's connection to the cube, right-click on the user and select the delete operation
!O3ServerAdministrator-RunningCubes-User.png|vspace=10,hspace=10!

Shutting down a user's connection to a cube only shuts down connection to a specific cube and those they might have to other cubes are maintained.

The user will later on be able to reopen the cube they were disconnected from. To prevent the user from reopening the cube, security settings must be changed.

Please note:

The branch to expand in order to shut down connections is in both cases "Open Cubes" and not "Available Cubes". If a cube is deleted from the "Available Cubes" branch, it is permanently deleted from the server and will have to be published again.

h3. Cube Tab Information

Information available in this tab is merely informative. The field that shows the number of open connections to such cube is highlighted. There will be an open connection for every client that has connected to the server, accessed the cube and kept it open.

The following table describes this tab's properties:
|| _Property_ || _Description_ ||
| Name | Cube Name |
| URL | The physical location of the cube. It may be a network path, in the format:drive:/path/file.cube, or an URL |
| Connections | Number of users accessing the cube |

h3. Runtime Tab Information

The table below describes this tab's properties:
|| _Property_ || _Description_ ||
| Mínimum number of blocks  \\ | Minimum cache needed to run the cube, measured in blocks |
| Máximum number of blocks   \\ | Cache size as defined by the cube designer, measured in blocks. This value can be modified by the administrator |
| Number of blocks in use | Cache current use, measured in blocks |

h3. Information about Users Consulting Cubes

The table below describes the properties of users consulting each one of the open cubes.
|| _Property_ || _Description_ ||
| User | The Operating System user identification |
| Login | The O3 Server user identification. It may be the same as the User's |
| Host | The Name or IP address of the workstation |
| Conected | Date and Time the user connected to the server |

h2. Enabling the Enforcement of Rules

From the Administration Tree in *{_}O3 Server Administrator{_}* it is possible to enable and disable the automatic enforcement of rules when O3 Server is started.

To enable the enforcement of rules at O3 Server startup:
# Start *{_}O3 Server Administrator{_}*
# Expand the Services \| Rules branch from the Administration Tree
# To enable the enforcement of rules, tick the box "Check rules on startup" in the Properties Pane and indicate the username and password of the administrator user with whom rules will be enforced
!O3ServerAdministrator-Rules.png|vspace=10,hspace=10!

NB:
Rules defined on each cube are applied after it has been built regardless of the option "Check rules on Startup" being enabled or not.

h2. Seeing Information about Connected Users and Disconnecting them

You may see the users currently connected to O3 Server from *{_}O3 Server Administrator{_}*.

To see the users connected to O3 Server or disconnect them:
# Start *{_}O3 Server Administrator{_}*
# Expand the Services \| Clients branch in the Administration Tree
# Refresh the group of connected clients by means of the right button of the mouse
# To shut down a client's connection, tick the client and click on the disconnect button in the Administration Pane
!O3ServerAdministrator-ConnectedUsers.png|vspace=10,hspace=10!

The disconnection of a user means shutting down all connections they might have to different cubes. The disconnected user will have to start a new session to continue working with O3 Server. The user in green is the *{_}O3 Server Administrator{_}* connection the administrator is currently using.

h3. Client Information

The table below shows the properties of connected clients.
|| _Property_ || _DescriptionH{_}ost ||
| Username | The operating system user identification |
| Login | The O3 Server user identification |
| IP | The Workstation name of IP address |
| Connection time | Date and Time the user connected to the server |

h2. Activating O3 Server MonitoringProfiler

In order to count on statistic information and analyze the use of O3 Server, it is necessary to activate *{_}O3 Server Administrator{_}* MonitoringProfiler.

To activate O3 Server MonitoringProfiler:
# Start *{_}O3 Server Administrator{_}*
# Expand the Services \| Profiler branch in the Administration Tree
# To activate monitoring, select the options in the Properties Pane and define the files where information will be saved
!O3ServerAdministrator-Monitoring.png|vspace=10,hspace=10!

h3. O3 Server Profiler Options

|| _Property_ || _Description_ ||
| Server Profiler active \\ | It activates Server profiler |
| Cube Profiler active \\ | Activates profiling of the cubes in the server |
| Server time frame \\ | Time frame in seconds |
| Server general | It indicates the Server profiler log file |
| Server cube \\ | It indicates the Cubes profiler log file |
| Server Session ( in the time frame)  \\ | It indicates the Time frame activity log file |
| Server sessions \\ | It indicates the connection and disconnection log file |

h2. Seeing Statistic Information about Cubes

The server generates a set of statistic data that enable the administrator to improve the use of available resources, thus achieving a better performance.

For instance, when cache use is analyzed, the administrator can modify its size and achieve a better performance or optimize the use of resources.

To see the Statistic Information about cubes:
# Start *{_}O3 Server Administrator{_}*
# Select the Statistics \| Cubes branch in the Administration Tree
# Select the cube and a set of statistic data will be displayed in the Properties Pane
!O3ServerAdministrator-Statistics.png|vspace=10,hspace=10!

NB:
To enable statistic information you need to have activated O3 Server Monitoring first.

h3. Statistic Data

The following table describes the statistic properties of cubes.
|| _Property_ || _Description_ ||
| Start time | Date and Time execution started |
| Current time | Current Date and Time |
| Cache % | Percentage of correct answers in the cache |
| Average  I/O operations \\ | Number of reading/writing operations in the disc |
| Total  Query \\ | Total number of queries performed |
| Average Elapsed Time | Average query time measured in milliseconds |

h3. Updating Statistic Information

All the information about cubes being executed is very dynamic, as it depends on actions performed by different clients of the server . The set of data shown in the Properties Pane must be explicitly updated each time the administrator wishes to consult it.

In order to update statistic information perform any of the following actions:
* Press the Update button in the corresponding Properties Pane
* Select the File \| Update command
* Right-click on the corresponding branch of the cube. A menu will drop down. Select the Update command

h2. Importing and Exporting O3 Server elements

Through *{_}O3 Server Administrator{_}* you may Import an Export the existing elements in the server. Depending on the selected options, it is possible to export all the cubes, definitions, scorecards, rules, actions and models. The elements selected in the export are kept in a file (.zip) and for importing them the file name must be indicated.

This mechanism can be used, for instance, for version migration procedures, and for work environments with independent production, development and testing servers.

To export O3 Server elements:
# Start *{_}O3 Server Administrator{_}*
# Select the Tools \| Export Server command in the Administration Tree
# Enter the destination file where the selected elements of the server will be saved
# Select the type of elements to export and click on the Export button. On finishing the process, a message will be shown
!O3ServerAdministrator-Export.png|vspace=10,hspace=10!

To import O3 Server Elements:
# Start *{_}O3 Server Administrator{_}*
# Select the Tools \| Import Server from the Administration Tree
# Enter the destination file where the exported files were saved
# Click on the Import button. When the process is finished a message will be displayed
!O3ServerAdministrator-Import.png|vspace=10,hspace=10!

----
{scrollbar}
{children}