proCube User Interface

This topic describes the physical features found within proCube Management Studio for a typical client installation. For information on the physical server features in the Server View, go to Managing the Server.

proCube Management Studio

proCube Management Studio combines two separate applications in one. Now you can simultaneously manage your servers, connect to multiple databases, create slices, and browse your data all within a single interface.


Figure 1.    proCube Management Studio

The proCube Management Studio user interface is comprised of six main parts:

  • Title Bar — Contains the proCube button, Quick Access menus, shows wether you are working with a database or a slice, and displays the current cube and slice.

  • Ribbon —  a visual representation of commands that enable you to quickly find the features that you need. The Ribbon replaces traditional menus and toolbars, and represents a new and more efficient way to get your work done.

  • Server View — Server administration is built directly into the proCube Management Studio user interface. Available servers display in the Server View, and a database can be connected from the same interface where data is browsed.

  • Dimension Views — Page, Column, and Row dimensions for modeling slices.

  • Data Browser —  The proCube Main Window uses Microsoft’s Multiple Document Interface (MDI) standards, meaning you can open multiple slices simultaneously and arrange them as you wish. Slices are displayed from one database or from several.

  • Status Area — The Status Bar appears at the bottom of the application window and provides information related to your working mode and the current database you are accessing. The corresponding fields are empty when those components of the application are not active. A Log viewer is also accessible just above the Status Bar by selecting Log View from the Ribbon.

The title bar

The Title Bar contains commands and or displays for:


Figure 2.    Title Bar





proCube button

Click to select commands for proCube server, Open Database, Print, and proCube Options.


Quick Access Toolbar

A customizable toolbar containing easy-to-acess proCube and Windows commands


Database/Slice Toggles

Toggle the active Ribbon menu to work with a database or a slice.


Current Server and Slice

Displays the current server and slice.



A drop-down menu that lets you select a new look for your proCube Management Studio



A drop-down menu with selections for proCube Help Topics, 9Dots Home, and About proCube version.

The ribbon

The Ribbon visually displays the commands and functionality for. The Ribbon helps you quickly find the  proCube Management Studio commands that you need to complete a task. Commands are organized in logical groups, which are collected together under tabs. Each tab relates to a type of activity, such as working with slices. To reduce clutter, some tabs are shown only when needed. The Ribbon is also featured in Excel 2007.

The Ribbon is divided into four tabs:

  • Home — contains data-manipulation commands for working with the clipboard, views, and data windows.

  • Model  — contains data-modeling commands for working with meta objects and security.

  • Data  — contains bulk-data commands for working with importing data, exporting data, and Xchange.

  • Report — contains slice commands for working with opening and saving slices, editing slice data, viewing slice data, setting parameters, zooming browser views, and worksheets in Excel.

The Home tab

The Ribbon's Home tab contains three groups containing these commands:


Figure 3.    Ribbon Home Tab

Tab Group





Work with data from the Clipboard



Inserts data from the Clipboard at the location of the cursor.



Removes selected data and places it on the Clipboard.



Copies selected data to the Clipboard.


Select All

Selects the entire document.



Toggle on/off selected views.


Status Bar

If selected, the Status Bar displays along the bottom of the proCube Management Studio.


Server View

If selected, the Server View displays along the left side of the  proCube Management Studio.


Log View

If selected, the Log View displays along the bottom of the  proCube Management Studio just above the Status Bar (if selected).



Work with the Slice Browser.



Opens a dialog to work with the different displayed slices.

The Model tab

The Ribbon's Model tab contains commands divided into the following tab groups:


Figure 4.    Ribbon Model Tab

Tab Group



Meta Object


Lets you work with saved data grouped on a dimension, cube or slice basis.



Opens the Dimensions dialog



Clicking this command icon opens the Cube dialog. Clicking the drop-down arrow displays a Transfer Cube command.



Clicking this command icon opens the Slices dialog. Clicking the drop-down arrow displays two commands: New Slice and Open Slice.



Lets you work with security issues.


Users & Groups

Opens the Users & Groups dialog.


Database Privileges

Opens the Database Privileges dialog.


Change Password

Opens the Change Password dialog.


Cube Access

Opens the Cube Access dialog where non-administrators can set cube access rights.

The Data tab

The Ribbon's Data tab contains commands divided into the following tab groups:


Figure 5.    Ribbon Data Tab

Tab Group





Lets you work with data imports.



Opens the Import Metadata dialog.



Import factdata from a text file.



Import security from a text file.


Metadata From XML

Opens a file dialog for the selection of an *.xml file to import into proCube.



Lets you work with data exports.



Opens the Export Metadata dialog.



Opens the Export Cube dialog.



Lets you export security data to an archive file.


Metadata to XML

Opens a file dialog for the definition of an *.xml file to export.



Lets you work with Xchange. Your access to this component determines the availability of the group.


Create Cube

Opens the Create Cube from Relational Source dialog.


Cube Properties

Opens the OLAP Exchange Cube Properties dialog.


Modify Relational Dimension

Opens Modify Dimension From Relational Source dialog.


Rebuild Cube

Opens the Rebuild Cube dialog.

The Report tab

The Ribbon's Report tab contains commands divided into the following tab groups:


Figure 6.    Ribbon Report Tab

Tab Group





Commands for working with slices.


New Slice

Opens the New Slice dialog.


Open Slice

Opens the Open Slice dialog.


Save Slice

Opens the Save Slice dialog or the Save As Slice dialog (for an unsaved slice)


Save Slice As

Opens the Save As Slice dialog.


Close Slice

Closes a slice. If the slice is unsaved, you are prompted to save it.



Commands for working with data.



Removes selected data and places it on the Clipboard.



Copies selected data to the Clipboard.



Inserts data from the Clipboard at the location of the cursor.



Clears selected data.



Commands for manipulating data.



Recalculates the slice data.



Toggles on/off the Dimension Views.


Grid Numbers

Shows or hides grid numbers. Label rows and columns with grid numbers to make data easier to interpret and values easier to reference.


Zero Suppression

Show/hide rows and/or columns that contain zeros or do not contain data.



Commands for adding parameters to the display of slice data.



Lets you edits slice data.



Opens the Edit Constraints dialog.


Drill Through

Opens the Drill Through dialog.



Enlarge rows/columns to make your data easier to read. Zoom dynamically or zoom by selecting preset values.


Dynamic Zoom

Move the slider from left to right to zoom in or out of the slice data display.


Zoom Preset values

Selecting a value sets a zoom display level for the slice data.



Commands for working with Excel worksheets from proCube.



Click to access commands for creating a worksheet in Excel or creating a values-only worksheet in Excel.

The content area

The Content Area of the main application window is blank until a slice is opened or created. A slice is like a window into the proCube database file. A slice provides the opportunity to view and model the dimensions and the corresponding data points in a cube. Upon opening or creating a slice, the content area becomes active and displays the Page, Column and Row dimensions and the slice's data within a browser that looks and feels like a spreadsheet.

The Content Area can contain multiple slice-views, allowing you to view data in different slices of a cube. proCube also allows you to view multiple slices from multiple cubes. When more than one slice is open, you can click back and forth between them.


Figure 7.    Content Area Showing Dimension Views and Slice Data

Dimension views

The Page, Column, and Row dimension views display the current slice dimensions. Dimensions in each view can be dragged-and-dropped to a different dimension view and that slice can then be recalculated to produce data from a new perspective.

The three Dimension views can be toggled on/off by selecting or deselecting Preview on the Ribbon's Report tab.


Figure 8.    The Three Dimension Views

The Count column within the Page, Column, and Row dimension views shows the number of members in each dimension. When that number changes, the member selection updates automatically. Members can be reordered by clicking each dimension view's individual header to display an arrow. Click the arrow to sort contents by ascending or descending.

Browsing slices

Each displayed slice gets a color-coded tab that can be clicked to display its data in the browser or be clicked to close it. At the upper right of the slice browser, click to open a pull-down menu that gives you access to that cube’s slices. Here you can open a slice or change the browser focus to another slice view. Behind each displayed slice is a log view displaying the behind-the-scenes code for that slice.


Figure 9.    Slice Tabs

Log views

proCube Management Studio has two types of log views:

  • Slice Log View — Tracks behind-the-scenes operations for each slice.

  • Report Log Views (Log1-Log4) — Tracks operations messaging for the workstation. There are four logs in which information can be written.

Slice Log View

Behind each slice is a log view. Just click the Log View tab to open it, as shown in the figure below.


Figure 10.           Slice Log View

Information from the initial query is shown under Profile: Execution #1. An additional query's information would be written to Profile: Execution #2.

Multiple editing tools appear along the top of the Slice Log View. Clicking Save allows you to save the report text to a file. Other commands let you cut and paste, undo or redo, search and replace, apply bookmarks, and expand/collapse the Profile outline. To save report information, you can cut and paste the text into another program or click Save to place that information in a log file.

Report Log View (Log1-Log4)

The report log view, returns import, export, and error reports for the workstation. This log view is made active from the Ribbon Home Tab's View Group by selecting Log View.

Reports are written to the active Log tab. If you switch from Log1 to Log3, reports are then written to that tab. You may want to switch to a different Log tab to track certain types of information. Any report information contained in Log1-Log4 is lost when the proCube session is closed. To save report information, you can cut and paste the text into another program or click Save to place that information in a log file. The editing tools in the Report Log View are the same as those in the Slice Log View.


Figure 11.           Report Log View

Clicking the push pin icon in the upper, right-hand corner of the Report Log View docks or hides the view. Clicking the X next to the push pin closes the Report Log View (and deselects Log View from the Home ribbon's View Group).



Please sign in to leave a comment.
Powered by Zendesk