Page Comparison

{scrollbar}

----
Cube managing activities include:
* Publishing Cubes isin O3 Server to make them accessible to users
* Generating Cube configuration files for their update
* Removing a cube from O3 Sever
* Putting a cube offline

h2. Publishing Cubes in O3 Server

Before the O3 Server's client users can access a cube, it is necessary to add it to the list of available cubes, also know as publishing the cubes.

O3 Server Administrator arranges the required information in the Properties Pane of each cube in the following tabs:
* _General_, to enter the basic necessary parameters to publish a cube in the server
* _Access Profiles,_ to define the dimensions and measures the users will have access to
* _Views_, to administrate the views of the cubes
* _Profiling,_ to activate the specific monitoring of each cube
* _Update Parameters_, to configure the parameters that will be used to to update each cube

h5. To publish a cube in O3 Server

# Start the *{_}O3 Server Administrator{_}*
# Expand the Services \| Cubes \| Available cubes branch in the Administration Tree
# Righ click on the Available Cubes node and use the Add Cube command.
The Add Cube command is context sensitive and will also be enabled in the Toolbar and the File menu when the Available Cubes node is selected.

At least, in order to publish a new cube you must fill the following information in the General section of the Properties Pane:
* Cube name
* Tick the Available option
* Physical path to the generated cube file (.cube file)
* Add the authorized roles to establish the users that will have access to it
Click on the Add button and enter the role ( the Administrators role will be added by default)
If no profile is indicated, (default value (none)) all users in the entered role will have access to all dimensions and measures of the cube.
* Click on the Apply button. The cube will be published and accessible to all users in the authorized roles.
!O3ServerAdministrator-ServerCubes-General.png|vspace=10,hspace=10!

h3. The General Tab

A cube's General tab lets you define the basic necessary parameters  to publish a cube in the server. In particular, the physical path of the cube (URL), the name it is published by, the authorized roles, etc.

The properties in the General tab of each cube are the following:
|| Property || Description ||
| Cube name | The name the cube is published by in the server. \\
This is the name the end client tools will use to refer to the cube. \\
This name can be completely different to the name of the physical file of the cube |
| Help page | It lets you set up the URL to a help page with relevant information about the cube that the end user will have access to |
| Available | It indicates if the cube is available to be queried. \\
It is possible to disable this option when maintenance or administrative tasks related with cubes are carried out |
| O3 Native Cube or XMLA | To indicate the type of cube to publish, O3 Native or from an XMLA provider |
| URL (O3 Native Cube) | Physical path to the cube (.cube file). \\
It may be a network path in the [file:drive:/path/file.cube]format, or an URL \\
This property is only valid for O3 Native Cubes |
| Model URL (O3 Native Cube) | Physical path to the cube model (.mdl file). \\
This property is only valid for O3 Native Cubes |
| Loading Priority on Startup (O3 Native Cube) | It establishes the cube loading priority at the time of server startup. \\
This lets you open more frequently used cubes automatically before any other user attempts to access them, thus reducing wait time. \\
This property is only valid for O3 Native Cubes |
| WebService URL (XMLA) | Physical path of the WebService. \\
This property is only valid for XMLA providers |
| Catalog (XMLA) | XMLA provider catalog. \\
This property is only valid for XMLA providers |
| Cube (XMLA) | Name in the XMLA provider. \\
This property is only valid for XMLA providers |
| Username (XMLA) | XMLA provider username. \\
This property is only valid for XMLA providers |
| Password (XMLA) | XMLA provider password. \\
This property is only valid for XMLA providers |
| Authorized Roles | List of roles and access profiles assigned to access the cube. \\
In order to add a new role click on the Add button and a new row will appear to enter a new role and indicate its access profile. To remove an authorized role, select it and click on the Remove button |
| Role | They are the authorized roles to access the cube |
| Profile | Access profile assigned to the role. \\
By means of access profiles the dimensions and measures the users can access are limited. \\
Access profiles are defined in the Access Profiles Tab in each cube |
| Can synchronize | It indicates if the authorized role can synchronize views in the cube |
| Add Button | It adds a new role to the list of Authorized Roles |
| Remove Button | It removes the selected role from the list of Authorized Roles |

h2. The Access Profiles Tab

Access profiles are a mechanism to limit the dimensions and measures users can access.

Profiles are defined for each cube as they refer to specific information of its dimensions and measures. By assigning profiles to roles, access of the users defined in O3 Server is restricted. Roles and users are defined in a general way in the O3 Server. 

In this tab the necessary access profiles are added, including two internal tabs for each profile where dimensions and measures are specifically defined.   
!O3ServerAdministrator-ServerCubes-Profiles-Dimensions.png|align=center,vspace=10,hspace=10!
!O3ServerAdministrator-ServerCubes-Profiles.png|align=center,vspace=10,hspace=10!
The properties of the Access Profiles tab for each cube are shown below:
\\
\\
\\
\\
\\
|| Property || Description ||
| Profiles | List of access profiles defined for the cube. \\
Click on the Add button, and a new row will appear to define the new name. \\
To remove a profile, select it and click on the Remove button |
| Name | The name of the selected Access Profile |
| Dimension Access | It contains a list of the cube dimensions from which access policies for each profile is defined |
| Name (Dimensions) | Name of the dimensions |
| Accessible (Dimensions) | It indicates if the dimension is accessible by the defined access profile |
| From level (Dimensions) | Level number from which the profile will have access |
| Restriction (Dimensions) | Logical expression that dynamically determines if the profile will have access to every member in the dimension's hierarchy |
| To level (Dimensions) | Level number up to which the profile will have access |
| Measure Access | It must be indicated whether each measure of the cube will be visible or not when the cube is accessed through that profile |
| Name (Measures) | Name of the measures |
| Visible (Measures) | It indicates if the measure is visible to the defined access profile |

h3. The Views Tab

From this tab you may see and manage the set of views defined for each cube.

It is a centralized mechanism for the Administrator to control the views authorized users have been creating.

Basically, this section shows information about views and lets the Administrator remove them if necessary.
\\  !O3ServerAdministrator-ServerCubes-Views.png|align=center,vspace=10,hspace=10!\\
\\
\\

Here are the properties in the Views Tab: 
|| Property || Description ||
| Storage Level | Type of view defined. \\
It lets you select Public views, those specific for a role or those private to each user |
| Name | Name of the rule or view |
| Creation Date | Creation date of the view |
| Generated by | User who generated the view |
| Modify Allowed | It indicates if users can modify the selected view |
| Remove Button | It lets the administrator remove the selected view |

h3. The Profiling Tab

O3 Server has a Profiling service that lets you generate access and general performance information for each cube.

By default, profiling at the level of each cube is not activated. To activate profiling at the level of each cube, the service must be activated in the Profiling Tab.
\\  !O3ServerAdministrator-ServerCubes-Monitoring.png|align=center,vspace=10,hspace=10!\\
\\
\\

The properties of the profiling tab are shown below:
|| Propiedad || Descripción ||
| Profiling Active | It activates monitoring of cube usage (See [Monitoring O3 Server]) |
| Profiling File name | Location of the log file. \\
This file is generated when monitoring is activated |

h3. The Update Parameters Tab

This pane lets you set up the parameters that will be used to perform updates in each cube when they are published in the server and being accessed by users.
\\  !O3ServerAdministrator-ServerCubes-UpdateParams.png|align=center,vspace=10,hspace=10!\\
\\
\\

The properties of the Update Parameters tab for each cube are as follows:
|| Property || Description ||
| Create cube configuration file | It indicates if the file is created or not when changes are applied through the "Apply" button |
| IP or Server Name | Identification of the machine where the O3 server where the cube is published is executed |
| Publish type | It states the type of publication of the cube to build. \\
Options: None, Upload the Cube to server once built, Send Cube Contents while building |
| Force Available | It forces cube availability while the cube is being built |
| Delete Previous Cube | It deletes the previous cube once the new one has been built |
| Delete Downloaded File | It deletes the newly built cube file |
| Use default configuration file's path | It uses the default path where to generate the configuration file (.srv file) \\
By default, the path is the same as for the cube (.cube file) |
| Configuration file's path | Specific path where to generate the configuration file |
| Configure exchange path | It indicates if an exchange path is used where to generate the cube while it is being built |
| Exchange path | Specific Exchange Path where to generate the cube |
| Login Information | Login, Password and Password confirmation to access O3 Server. \\
This login will be used by *{_}O3 Builder{_}* to connect to the server and must be administrated |
| Apply button | It confirms changes. When confirming changes, if applicable, the *O3 Builder* configuration file is created |
| Refresh Button | It lets you view the latest information that has been confirmed with the Apply button |

h2. Generating Cube Configuration Files

From *{_}O3 Server Administrator{_}*, it is possible to generate a configuration file that contains all the necessary information for *{_}O3 Builder{_}* to update cubes.

Using this option simplifies cube update process, centralizing configuration and preventing errors when entering the parameters required by *O3 Builder*. 

The Update Parameters tab of the cube lets you enter information to generate the configuration file (.srv file)

To generate the cube configuration file:
# Start *{_}O3 Server Adminstrator{_}*.
# Expand the Services \| Cube \| Available cubes branch in the Administration Tree. 
# Select the cube for which you wish to generate or update the configuration file. 
# Complete or update the properties in the Update Parameters tab of the cube. 
# Click on the Apply button and the configuration file will be generated in the specified location. 

h2. Removing a Cube from O3 Server

Removing a cube means removing the corresponding node in the Available Cubes branch in *{_}O3 Server Administrator{_}*.

This action does not remove the actual cube file in the filesystem, it just removes the references to them in O3 Server.

To Remove an available cube from O3 Server:
# Start *{_}O3 Server Administrator._*
# Expand the Services \| Cube \| Available Cubes branch in the Administration Tree.
# Right-click on the cube on the Available Cubes branch. A menu will drop down.
# Select the Remove command. The cube is removed from the list of Available Cubes.

h2. Putting a Cube Off Line

Sometimes it will be necessary to temporarily deny access to a registered cube in the server to perform maintenance and administrative tasks.

To put a cube off line:
# Start *{_}O3 Server Administrator._*
# Expand the Services \| Cubes \| Available Cubes branch in the Administration Tree.
# Select the cube you wish to disable.
# Disable the "Available" mark for that cube in the General Tab of the Properties Pane.
# Press the "Apply" button to make changes permanent. Users connected to the cube will receive a disconnection message and will be switched to offline mode, not being able to perform any more queries until the cube is enabled again.

----
{scrollbar}
{children}